Forum Discussion
Power automate dynamic export
you need to check the output of the trigger but it's likely something like
item()?['Column1']
Yes, exactly. I am trying to create a power automate flow which will take the power BI report and generate 8 different reports based on the value in the slicer (there are 8 different values). But every time I try to filter the report in power automate it doesn't work (last time I tried to write in ReportLevelFilters field = Table1/column1 eq item()?['Column1'] as you suggested). The report is always in "select all" state and it doesn't take into account value of the slicer which I use in power Automate.
You will want to show how you specify the report export filter. It has to follow OData conventions, and your chosen field has to actually impact the report's semantic model.
Fun fact: you will find that the number of daily exports is rather limited.
I specify the report export filter as the usage of my slicer column in the ReportLevelFilters field in export to file step (second image). It follows OData conventions but the report that i receive after exporting is not filtered.
How can I check that the column used in the slicer impact the report's semantic model?
Another think that I noticed right now is that if I filter the slicer and then save the report, I receive filtered report by the last saved slilcer values. But when I tried to clear all filters and then save this report, I have the version with selected value in the slicer and not the cleared one. When i send email with the report, I receive the latest saved version and it cannot be fileterd.
Do you know how can I clear filters, save the report and make the power automate filter the report in export to file step?You would consult your data model. Check the direction of the arrows.
Your Flow code is missing the single quotes around the Power BI value.
The problem is now solved! Thank you for your help!
Hi, i have the same problem. But how did you fix it?
