Power BI Export using Power Automate but filters applied not working

Question

Hi All,&nbsp;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.&nbsp;If anyone can help me in this issue with detailed step by step procedure, it would be great help for my activity.&nbsp;Regards,Mani

anonymous · Answer

Hi&nbsp;Mani7553&nbsp;,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.&nbsp;Use the&nbsp;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 filesExport and email a report with Power Automate - Power BI | Microsoft LearnPower BI - Connectors | Microsoft Learn
Best regards
Albert He
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly

mani7553 · Answer

Anonymous&nbsp;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.&nbsp;Use the&nbsp;field in the action to pass through the filter configuration you wish to apply to the report."&nbsp;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.&nbsp;Regards,Mani

anonymous · Answer

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.&nbsp;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.&nbsp;

rohit1991 · Answer

Hi Mani7553 ,
&nbsp;
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.
&nbsp;
Or, save a bookmark with the filters applied in Power BI and use the bookmark ID in the flow.

Forum Discussion

Related content

Power Automate Apply to each error

Automated refreshes

Apply data to all rows in a filtered column

Apply Filter before Calculating Average

Automating API link updates