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 

  • alexkarwoski's avatar
    alexkarwoski
    Frequent Visitor
    1 year ago

    This sounds interesting, but I do need the report output. But basically I am getting the same report snapshot regardless of the values select, I have the for loop, the export, and the filters, they just are not doing anything.

    thanks

  • 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?