Power BI Export using Power Automate but filters applied not working

[Mani7553]

Hi All,

I'm new to Power BI.

Im trying to export PDF from power BI report from web service using power automate.

But whatever the filters i'm applying in power BI report are not appearing in pdf exported using power automate.

Instead my pdf file is showing some default data only. 

If anyone can help me in this issue with detailed step by step procedure, it would be great help for my activity.

Regards,

Mani

[rohit1991]

Hi @Mani7553 ,

Power Automate doesn’t apply your filters unless you pass them explicitly. In the Export To File action, go to advanced options and set your filters under ReportLevelFilters using JSON. Make sure the field names match exactly.

Or, save a bookmark with the filters applied in Power BI and use the bookmark ID in the flow.

[JCERVANTES]

Hello Everyone,

I'm having a similar issue. I'm not all that well versed with Power Automate, so this is all learning experience for me. 

Basically, like the initial post, I've set up a flow to export specific pages. In the area where report level filters, I've added the URL, the syntax seems correct, except all I get are default/unfiltered data on the visuals. Any guidance on this I'd really appreciate it.

[Mani7553]

@Anonymous 

Hi, Thanks for the reply.

I got success in getting the mail as you given the document link.

But, "You may need to specify the filter in the action parameters. Use the field in the action to pass through the filter configuration you wish to apply to the report." 

here in this passing report level filter i faced an error and when im trying to send mail through power automate button, it does not considers the changes done in FIlter on Power BI Service Report.

It considers only the filter selection applied during publish of Power BI Desktop file to workspace.

Can you please elaborate how to apply report level filters in power automate flow.

Regards,

Mani

[Anonymous]

Hi @Mani7553 ,
Based on the error message you provided, I checked the relevant problem documents, it seems like the error is related to the Power Automate flow may not be configured to apply the filters when exporting the report.
You may need to specify the filter in the action parameters. Use the field in the action to pass through the filter configuration you wish to apply to the report.
For details on how to export and email Power BI reports using Power Automate, you can refer to the following official documentation files
Export and email a report with Power Automate - Power BI | Microsoft Learn
Power BI - Connectors | Microsoft Learn

Best regards

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly