Hello — I’m working on setting up a flow that loops through each row in a table, applies filters to a report, exports the filtered report as a PDF, and saves it to SharePoint. The flow is mostly working: the PDFs are generated correctly and saved with the right naming convention in the correct folder.
The issue is that the filters aren’t being applied. Instead of showing data for the specific entity in each row, the report defaults to a “select all” view.
This is how my flow is set up (manually triggered):
- Run a query against a dataset
- Parse JSON
- Create new folder
- Initialize variable
- Apply to each
- Set variable
- Compose
- Export to file for Power BI reports
- Create file
I believe my issue is at the Export to file for Power BI reports, specifically the Report Level Filters.
Right now I have it written as this:
800_number_dimension/mstr_agnt_nm_tel_nbr eq 'AGENCY XYZ 000-000-0000'
