Using Power Automate to send Power BI reports with filters.

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.