Hi Laura! Firstly, thank you so much for this awesome video. It explained the whole concept in a very lucid manner. Really appreciate it. Now, I have a question. Say, I want to automate the whole process for different filters (-30 to 30) and save those tables according to the applied filter names. How should I approach? Thanks in advance.
I would have a list of the different parameters maybe in an Excel list. Then use a for each to loop through them using a concatenate to create the query to send the queries. And then save the output as csv files. Hope that makes sense
hi thanks for the video, but this method has a limitation of rows, how to import all the rows into a csv table & then place it in one drive/sharepoint, I have already tried the mentioned flow but not getting all the rows in my csv.
Thanks! Is it also possible to further specify the email list based on the dataset in the report? Eg. dataset Data Quality + related buyers: send only data of each specific buyer to related buyer email?
Thank you for the video @Hat Full of Data! Would I be able to query each column separately using this method and paste into a SharePoint list? Thank you!
Simple answer: Create a different visual with just one column, and copy that query to your Flow. Repeat for each column. Better answer: Create a query from a table with all of your columns, and manually edit that query to only return the column you want. If you try the simple and understand what the query is saying, you can figure out the better.
I was wondering if below scenario is possible with power Automate or not ?? Let's say if we want cross report slicer sync in power bi , this feature is currently not available in PBI , is it achievable using Power Automate
So, I came across a requirement to establish that I have to do the same thing except sending the data into a mail, I have to to add a new row to a dataverse table. Do you think is it doable?
One method would be to use an apply to each step to loop through all the rows and use an add item to dataverse. If it is huge number of records there might be better methods
Hello. I have hyperlinked text in a Power BI table visualization that I’d like to bring in to Power Automate and then include in an email while preserving the clickable links. Do you know if that’s possible?
A bit under whelmed -what good it is, sending a few html records. Pls talk about sending 10s of thousands of records as an Excel file or csv or pdf attachment. Thanks
Sending a quick update to a manager as a teams message is a regular request. If you are handling 10s thousands of records you could save as csv as an action but Power Automate is not the best tool to handle large record counts. It is not a Data Integration tool. Azure Data Factory, Fabric or other options would be better suited in my opinion.
Can you make a video or comment how to format the table? I am stuck on this. My table has several columns and shows a lot of brackets and Column names that will not be familiar to the user.
Hola, no viene al tema del video pero, como puedo cambiar el interfaza de panel de informe, veo el area de trabajo es amplia y los iconos son pequeños. Gracias
Hello, great video. Instead of sending an email, I'd like to move the content gathered from the query to a sharepoint list. Do you think its something fesable? If so, any documentation that you can share that would help me?
I'd recommend adding a parse json step after the get data and then look at the advanced step of create table and it gives options to rename the columns.
Hi Laura, is there any way of doing exactly the same thing but to an excel table instead of email? I have some data in excel that needs to have live feed of data that comes from power bi table just like the one in your video, the powerbi data comes from a direct query so I can't edit it in power query unfortunately 😕 thanks, Alex.