Using Power Automate to send Power BI reports with filters.

[alexkarwoski]

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 respectively.

Essentially what I want to do is iterate through these filters in power automate and generate a report for each state, name, age combination. For example, say state was GA, name was Alex, and age was 1,2, and 3. I want to click a Power Automate button in Power BI. I want generate the report for a certain page using Export for Power BI Report in power automate for the combinations
GA,Alex, 1
GA,Alex, 2
GA,Alex, 3

I have this all set up. And when I check the filters that were passed this is exactly what they are. However, the report is the same for all three pages. It shows the merged summary from having the multiple selections. I am on a premium capacity server, and have been stuck for a few days.

Any thoughts?

[SaiTejaTalasila]

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]

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?

[alexkarwoski]

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

[rajendraongole1]

Hi @alexkarwoski - you should create a loop that iterates over each unique combination of filters.For each iteration, explicitly pass the filters as single values by using separate Export to File actions within the loop.

To handle the multiple ages, use an “Apply to Each” action in Power Automate.
Pass one age at a time as a filter to the Export to File action, along with the specific state and name filter.
This should generate separate exports for each unique combination (e.g., GA, Alex, 1, GA, Alex, 2, and GA, Alex, 3).
3. Check Filter Context in Power Automate Actions
Ensure that each “Export to File for Power BI” action has the following:

State filter: State eq 'GA'
Name filter: Name eq 'Alex'
Age filter: Set this dynamically using the current value in your “Apply to Each” loop for age.

the filter syntax in Power Automate can be sensitive.

check if you can use the “Export with Current Values” option in Power Automate. This might ensure that the filters you pass are respected, as it explicitly tells Power BI to use the current state of the filters as set in the export request.

Hope this helps.

[alexkarwoski]

This is the exact approach I am currently using, besides the Export with Current Values which I do not see. However, each output is still the same, and I have diuble checked the filters work. Its just printing whatever is on the screen when the report is saved.