Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Using a filter on PDF Export in Power Automate - Multiple filters

Hello all,   I am struggling with filtering a report that I am trying to export from Power BI.   Let's say the table is called Report Comments, and I want to filter on the Month column.   ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for the reply from lbendlin , please allow me to provide another insight: 


    Hi  Anonymous ,

    You mean that you want to put multiple filter into the Power Autoamte filter Power BI report export action?

    If so, please kindly try this format:

    ?filter=CS_KPI_Comments/Month eq 'June' and table/Column eq ''

    May refer to this documentation example posted:

    Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks for the reply from lbendlin , please allow me to provide another insight: 


Hi  Anonymous ,

You mean that you want to put multiple filter into the Power Autoamte filter Power BI report export action?

If so, please kindly try this format:

?filter=CS_KPI_Comments/Month eq 'June' and table/Column eq ''

May refer to this documentation example posted:

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you, my solution was close to this in the filter query:

    Report_Comments/Month eq 'June' and table/Column eq ''

     

    For some reason it didn't work the first time I tried it, but I'm sure I missed something minor. The link has proven to be very useful as well for filtering other items like date.