Filter a Power BI Tile using query string paramaters and IN operator.

[Anonymous]

I'm trying to filter a power Bi Tile on my PowerApps application, as it written in this article: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

It's works well with the "eq" operator but when I tried to use the "in" operator it doesn't work.

For example adding this to the end of the TileUrl works:

&filter=Etat_Consigne_Approb/Approbateur eq ('XXXX xxxx')

But this doesn't work:

&filter=Etat_Consigne_Approb/Approbateur in ('XXXX xxxx','ZZZZ zzzz')

Thanks by advance

I can provide other info if necessary

[Alzo]

Was this solved? I can use the 'in' operator for a full report but not for a tile?

[v-yueyunzh-msft · Accepted solution]

Hi , @Anonymous 

According to my research, each value in the set after the in operator needs to be separated by a space, you can try something like this

&filter=Etat_Consigne_Approb/Approbateur in ('XXXX xxxx', 'ZZZZ zzzz')

Here is an introduction document about the operator in the URL filter, you can see and try according to the example inside:

OData IN Operator filter function - OData | Microsoft Learn

Best Regards,

Aniya Zhang

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

[ppuser3]

Hi, the space also doesn't work. Any other fixes? The IN operator is not working via Power Apps for a Power BI tile. I've tried everything includign the allow new API, special characters, etc.