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.

 

I am using the ReportLevelsFilters function, but whatever I try, it doesn't look like it's filtering anything. I also tried the following string:

 

 

 

'Report Comments'/Month eq June

 

 

 

But without the desired results... The reports come out unfiltered.

 

Does anyone know what I am doing wrong? And more importantly; how can I do it right?

 

-----

So I was able to solve this issue by removing the spaces in the tables. I did some testing in the url, by pasting 

 

?filter=Report_Comments/Month eq 'June'

 

at the end of the url in the report viewer, which worked. Then I put

 

Report_Comments/Month eq 'June'

 

In the filter query and that also worked.

An issue I have now is, how do I create multiple filters here?

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.

3 Replies

  • 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.