Forum Discussion

mokumar's avatar
mokumar
New Member
4 years ago

ReportLevelFilters is not working using PowerAutomate

Hi All,   I am trying to email a report with the help of PowerAutomate using the action Export To Files for Power BI Reports (more info can be found here )   that is how the action looks like wit...
Need Help
alexkarwoski's avatar
alexkarwoski
Frequent Visitor
1 year ago

 

2 seconds ago

I have a similar problem.

 

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?