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.
Hello freginier
Thank you so much for your support. This sounds like what I need but I'm running into some issues with the setup of the Parameter (i don't have a lot of experience with them). I created a Parameter in desktop based on the DateTable[Date] field but it came through as text type so it didn't function when I tried to use it in the slicer. When i tried to change the format to Date there was an error on the table portion of the parameter stating it couldn't process text as a date.
Could break down how to add and calibrate the parameter to make this solution work?
Thank you again!
Casey
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.Thank you, I'll add a question there as well. Thank you for the suggestion!
Hi Casey_Alderson ,
I hope this information is helpful. If it is, please Accept it as a solution and give it a 'Kudos'. This will assist other community members in resolving similar issues more quickly.Thank you.