Forum Discussion
Filtered URL nog working with % in filtered value
Hi,
We use filtered URL's to filter specific articles in a report.
This has been working properly for quite a while.
An example of a working link:
filter=Artikelen%2FArtikelCode%20eq%20%27FLEX00948%27
In this case we filter on article FLEX00948 in table Artikelen and Column ArtikelCode.
Now we have article codes which end with -%. Like: PE0040V0520SBMM-%
If I try to filter this value, the link is not working. I know there is an escape code for %, which is %25, but is is still not working. This should be the addition to the url in my idea: filter=Artikelen%2FArtikelCode%20eq%20%27PE0040V0520SBMM-%25%27
Anyone ideas?
Hi Tomkru
Thank you posting in Microsoft forum community
I appreciate you for sharing details the link which you provided was not Accessible.
Please consider the following steps to address this issue:
- Ensure that every special character in the filter value is correctly encoded. For the % character, the escape sequence is %25. However, the - character does not need encoding as it is not a reserved character.
- Confirm the syntax for filters in the report URL matches the expected format. For example, eq is for equality comparison.
- If the eq operator is causing issues, you might want to try using the contains operator instead.
Please refer to the below Document Link for detail information:
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
