Forum Discussion
Power Automate - Export to File for Power BI Reports - Filtering
Hi Casey_Alderson ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
Since your issue revolves around Power Automate’s "Export to File for Power BI Reports" action and dynamically applying filters, the Power Automate Forum would be the best place to seek guidance. While Fabric users may have experience with Power BI exports, Power Automate experts are more likely to provide precise instructions on formatting the report filter parameter for handling dynamic date ranges.
Please refer the below link:
https://powerusers.microsoft.com/t5/Power-Automate-Community/ct-p/MPACommunity.
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Hey there Casey!
To export a Power BI report with the dynamic filter from a slicer (like a date slicer) while using Power Automate, follow these steps:
Using the Report Filter Parameter: Power Automate allows you to use report filter parameters to dynamically filter the data when exporting a report. This will allow the export to reflect the selected date range in your slicer.
You can achieve this by adding a filter parameter to the Power BI report and configuring it in Power Automate. Here's what you need to do:
Configure the Filter Parameter in Power BI:
In Power BI, you can set up a parameter for the slicer (for example, a date range). This parameter will allow dynamic filtering based on the slicer selection.
When you publish the report to Power BI Service, ensure that you have this parameter defined in the report. For date filtering, it could be a DateTime parameter.
Set Up Power Automate to Use the Filter Parameter:
In Power Automate, when you create the Export to File for Power BI Reports action, make sure to include the report filter parameter.
Add the filter parameter to the "Export to File" action in Power Automate. You'll need to pass the current value of the date range parameter to the export function.
You can do this by specifying the filter parameters in the "Export to File" action. This way, the export will reflect the slicer’s current selection rather than the last published state of the report.
Pass the Dynamic Date Range:
If you need to get the selected date dynamically, you could use Power Automate to capture the current slicer value and pass that into the report filter when triggering the export.
For example, you can retrieve the slicer values using Power BI REST API or other available connectors in Power Automate.
Testing:
After setting up the report filter parameter and the Power Automate flow, make sure to test it by selecting a new date range in your report, then running the flow to see if the export captures the correct data for the selected date range.
By following these steps, you'll be able to create a dynamic export that respects the filters selected in the report, without relying on the last published state.
Hope this helps!
😁😁