Forum Discussion

Casey_Alderson's avatar
Casey_Alderson
Helper I
1 year ago
Solved

Power Automate - Export to File for Power BI Reports - Filtering

Hi All,    I have a BI report that serves as a reconciliation of financial accounts and activity. The only filter is a between date slicer that is used to select the period of time being considered...
Need Help
  • v-menakakota's avatar
    v-menakakota
    1 year ago

    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.

     

Casey_Alderson's avatar
Casey_Alderson
Helper I
1 year ago

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

v-menakakota's avatar
v-menakakota
Community Support
1 year ago

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.

 

  • Casey_Alderson's avatar
    Casey_Alderson
    Helper I
    1 year ago

    Thank you, I'll add a question there as well. Thank you for the suggestion!

    • v-menakakota's avatar
      v-menakakota
      Community Support
      1 year ago

      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.

       

    • v-menakakota's avatar
      v-menakakota
      Community Support
      1 year ago

      Hi Casey_Alderson ,

      Could you please confirm if you've submitted this issue in the Power Automate Forum?

      If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum  we’ll be happy to assist.

      Thank you for being part of the Microsoft Fabric Community.

      • Casey_Alderson's avatar
        Casey_Alderson
        Helper I
        1 year ago

        The thread can be closed. Thanks