Forum Discussion

alexkarwoski's avatar
alexkarwoski
Frequent Visitor
1 year ago

Using Power Automate to send Power BI reports with filters.

On a Power BI dashboard I have a report page I want to send out. Currently I have three filters, two only allow for 1 selection and the other allows for multiple. Lets call them state, name and age r...
Need Help
SaiTejaTalasila's avatar
SaiTejaTalasila
Super User
1 year ago

Hi alexkarwoski ,

 

As rajendraongole1 mentioned you need use a for each loop.

In my case I have worked on similar thing to export data to CSV file and send it over email.

1.I have created one table in my report with division, email id and id columns and used performance analyser to get the dax query and on power automate I pulled the details using run a query against a dataset and phrase json.

2.Inside for each loop again I used one more run a query against a dataset and passed id column as parameter in my dax to pull the details based on user id, create CSV table and send an email.

 

Thanks,

Sai Teja 

R_Tamariz_C's avatar
R_Tamariz_C
Regular Visitor
1 year ago

Hi SaiTejaTalasila, can you shared more about this solution? I would like to know if you get a performance problem when retrieving more than 1 million rows and how you handle them?