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

[_Slowpoke]

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 , @_Slowpoke 

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