Power Automate - ReportLevelFilters to get PDF Exports using Export To File for Power BI Reports

Question

Power Automate - ReportLevelFilters to get PDF Exports using Export To File for Power BI Reports

Dhadigala, Navatha (CONTRACTOR) 0

Hi All, Need any suggestions or corrections, I have filter on all pages like this ( 'ProviderGroupID'[Salvage_Provider_Group_Name] ) used in Dashboard - I want to make use of that filter and use it in PowerAutomate ReportLevelFilters to get PDF Exports for that filter using multi valued filters., used code below, it doesnt filter data based on provider, by default it takes ALL. Please let me know any ideas on this. Thank you

User's image

[

{

"$schema": "http://powerbi.com/product/schema#basic",

"target": {

  "table": "ProviderGroupID",

  "column": "Salvage_Provider_Group_Name"

},

"operator": "In",

"values": ["State Farm"]

}

]

1 answer

Your answer

Answer 1

Hi @Dhadigalanavatha,

Welcome to Microsoft Q&A forum, and thank you very much for reaching out to us.

Based on your description, you want to apply the ProviderGroupID filter in Power Automate’s ReportLevelFilters to export PDFs using multi-valued filters. However, when you tested it, the export ignores the filter and returns all data, not just the specified provider. Kindly correct me if I am wrong.

From my research, the ExportToFile API and Power Automate action currently support only one report-level filter per export. If you try multiple filters or complex conditions, it may fail silently or default to “All” values.

As a workaround, instead of relying on ReportLevelFilters, you can apply filters directly in the Power BI report URL before triggering the export. This approach allows multiple filters by appending query parameters.

Additionally, I also found a thread discussing a similar request. Feel free to check it out for additional insights.

I also strongly recommend reaching out to the Dynamics community for further support. As a Microsoft Q&A Moderator, I don’t have access to your specific configuration, and my testing environment is limited. Since this involves dynamic identity, you may also want to raise a support ticket through the Power Platform Admin Center.

Thank you very much for your time. If you have any further questions or need clarification, feel free to let me know. I’ll be happy to assist you as much as possible.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Dhadigala, Navatha (CONTRACTOR) 0 Reputation points

2025-10-23T14:06:33.4233333+00:00

Hi Kha-N,

Thank you for your response. Yes, that's correct, my requirement is to get column related data filtered from the Query Table - ProviderGroupID in Dashboard ( Source is Synapse SQL -gets ProviderID, ProviderGroupName those are unique ). Whatever I do, it takes default values ALL and gives the same PDF export. I'll try suggested solutions too, Thank you !
Kha-N 3,100 Reputation points Microsoft External Staff Moderator

2025-10-23T23:21:44.16+00:00

Hi @Dhadigalanavatha,

Thank you very much for your response.

If you found this discussion partially helpful, please consider marking this thread as accepted by clicking ‘Accept the answer.’ Doing so helps highlight useful information for others facing similar issues and contributes to building a stronger, more informed community.

Warm thanks.

Share via

Power Automate - ReportLevelFilters to get PDF Exports using Export To File for Power BI Reports

1 answer

Your answer