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

[Anonymous]

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?

[Anonymous · Accepted solution]

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]

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.

[lbendlin]

Wrong filter format.  You need to escape special characters and specify the table name differently.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters