undefinedPower Automate – Send Dynamic Region-wise Power BI PDF Reports to Users Based on Dataset

[sreekanth9]

Hi Team,

I have a requirement in Power BI + Power Automate and I need guidance on the best approach.

We have a Power BI report with region-wise data, and inside the Power BI dataset we already have a table like this:

emailregion

[email protected]	south
[email protected]	east
[email protected]	north

My requirement is:

1. Every day automatically trigger the flow
2. Read email and region values directly from the Power BI dataset
3. Filter the report based on the respective region
4. Export only that filtered region report as PDF (or PNG if possible)
5. Send the exported file to the respective user email automatically

Example:

• South manager should receive only South region report
• East manager should receive only East region report
• North manager should receive only North region report

I do not want to use Excel, OneDrive, or SharePoint because all required data is already available inside the Power BI dataset.

Currently I am using:

• Run a query against a dataset
• Apply to each
• Export to File for Power BI Reports
• Send an Email (V2)

But I am facing issues with:

1. Dynamic email field in “To” section showing blank
   (Error: Provide at least one email address in 'To', 'CC' or 'Bcc')
2. Dynamic filter in Export to File action
   Example:

region eq '@{items('Apply_to_each')?['region']}'

Sometimes it throws loop reference errors like:

“The repetition action(s) 'Apply_to_each' referenced by 'inputs' are not defined in the template.”

I would like to know:

• What is the correct production-ready approach for this requirement?
• How should we properly configure dynamic email and dynamic region filters?
• Is PNG export supported directly from Power Automate for Power BI reports?

Please guide me with the best practice.

Thanks.