topic Re: Using a filter on PDF Export in Power Automate - Multiple filters in Developer

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

Anonymous — Tue, 13 Aug 2024 13:58:03 GMT

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?

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

lbendlin — Fri, 09 Aug 2024 17:55:58 GMT

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

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

Anonymous — Mon, 12 Aug 2024 02:46:45 GMT

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.

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

Anonymous — Tue, 13 Aug 2024 14:00:56 GMT

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.