Forum Discussion
Power Automate exports PowerBI Report in default configuration instead of the current state of slice
Hi,
I am trying to utilize power automate to export a PowerBI report repeatedly for each specific entry in the group that I am using slicers to filter the data down to. However, when I export the report it always exports in the default configuration with no slicers applied even though they were selected prior to executing the flow. How can I fix this?
Hi Anonymous ,
To enable dynamic selection of slicer values on the report side, set the slicer to not turn on mandatory Single Selection on the Power BI report side. Once you remove it, successfully test this by passing the filter value as a header in the URL. The same content is dynamically generated in the Power Automate process and passed in the filter parameters section of the Export PDF of PBI report connector in Power Automate.
--Used this below URL in the reportlevelfilter in the PBI connector.
https://app.powerbi.com/groups/******/reports/******/ReportSection*****?filter=<Table name>/<column name> eq '<column value>'
Also in the "Apply to each" after getting the value use set variable to set the value that is been pasted lately which should be used to pass in the next widget of "Export to file for Power Bi report" within the reportlevelfilter.
For more details, please refer: Now Export Power BI Reports with Filters using Power Automate by taik18 - YouTube
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
To enable dynamic selection of slicer values on the report side, set the slicer to not turn on mandatory Single Selection on the Power BI report side. Once you remove it, successfully test this by passing the filter value as a header in the URL. The same content is dynamically generated in the Power Automate process and passed in the filter parameters section of the Export PDF of PBI report connector in Power Automate.
--Used this below URL in the reportlevelfilter in the PBI connector.
https://app.powerbi.com/groups/******/reports/******/ReportSection*****?filter=<Table name>/<column name> eq '<column value>'
Also in the "Apply to each" after getting the value use set variable to set the value that is been pasted lately which should be used to pass in the next widget of "Export to file for Power Bi report" within the reportlevelfilter.
For more details, please refer: Now Export Power BI Reports with Filters using Power Automate by taik18 - YouTube
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.