Filter a power BI with power automate

[Arkhos94]

I'm building a power automate to filter a power BI, export it to PDF then send it by email

I did a first try and could do each step without issue, but I failed on the second try on the "filter a power BI" step

To filter the power BI, I add on the "ReportLevelFilters Filtre" field a filter written like this : TableName/ColumnName eq ‘value’

On my first try I had no issue, my filter was : SIGA/Group eq 'GroupName'

On my second try I have an issue because both the table name and column name has multiple words. I tried :

- 'Site list'/'Site ID' eq '46925'

- Site list/Site ID eq '46925'

- Site list/Site ID eq 46925

But none worked. Can someone tell me the correct syntax ?

[lbendlin · Accepted solution]

see here for the correct syntax. Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

you need to escape the spaces.

[mukuljuyal]

Hi i am facing same issue, can you  share  how you design solution.

Actually i want to export but before that want to apply filter on date as well as a string filed

[Arkhos94]

Hello

I know use an excel file (as I have to repeat the filter operation 174 times) but I don't think it change the problem.

My issue was cause by the space character : you have to replace it by "_x0020_"

So instead of using the filter :

Siga/Siga R1 Rattachement eq '999999'

I use the filter :

Siga/Siga_x0020_R1_x0020_Rattachement eq '999999'

(to filter it 174 time I use an excel file with the filter in one column and 1 line per filter => my automate filter the power BI, export it as a PDF, save the PDF in a sharepoint then mail it to a group of 5 to 10 people, then repeat. I also added a counter variable in the loop to count how many export are performed)

[mukuljuyal]

 i am trying Cluster_daily'/Objectid eq "01-C". in my case Cluster_daily is table in pbi and Objectid is a coloum, where i an trying to filter 01-C in that, however it is not working

[lbendlin]

same issue. Underscore is a special character and needs to be escaped.

[mukuljuyal]

my url filter Clusterdaily/RecordDate%20gt%202023-12-23T00:00:00Z%20and%20Clusterdaily/Cluster%20eq%20'01-C'

is working fine but not working when i am using it in export through power automate 

Clusterdaily/RecordDate gt 2023-12-23T00:00:00Z and Clusterdaily/Cluster eq '01-C'

[lbendlin]

There are other differences between V3 and V4. OData V3 does not support Dates, only DateTime. So if you use the V3 format, you must qualify it with the full date time. Date literals like "datetime'2019-05-20'" aren't supported in V3 notation. But you can just write it as "2019-05-20" in V4 notation. Here are two equivalent filter queries in V3 and V4:

OData V4 format: filter=Table/Date gt 2019-05-20
OData V3 format: filter=Table/Date gt datetime'2019-05-20T00:00:00'

[mukuljuyal]

Hi ,

Thanks for support, Now filter are working. Actual issue lies with PBI as url filter was conflicting with filter provision done in PBi