Forum Discussion
Power automate dynamic export
you need to check the output of the trigger but it's likely something like
item()?['Column1']
You need to provide the Report Level Filters. Make sure that column actually controls the data model.
Yeah, I provide that filter
"filter": { "table": "Name", "column": "companies", "operator": "eq", "value": "current loop value" }. Doesn't help. How do I ensure that column controls data model?
you cannot use eq for lists of values. use in
Thanks for the responses! As I said, I am trying to filter my report based on the values in the slicer. In the slicer there are 8 values and I need to export power BI report in PDF per every value in the slicer and send it to email. As a first step, i tried to export the report with one (instead of loop for 8 values) specific value selected ( ReportLevelFilter: Table/column eq 'Value'). However, the report which I receive in email is not filtered at all and still returns the report where all values of the slicer are selected. Do you know what may be the reason for that and how to solve it?
(Also when I tried to insert ?filter=<Table>/<column> eq <'Value'> in the URL link of my report, the page wasn't filtered.)
The flow i currently have:
