Forum Discussion
Filter a Power BI Tile using query string paramaters and IN operator.
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
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
3 Replies
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
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.
Was this solved? I can use the 'in' operator for a full report but not for a tile?
