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
4 Replies
v-saisrao-msftCommunity Support
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
- v-saisrao-msft
Hi Tomkru
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you. - v-saisrao-msft
Hi Tomkru
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
- v-saisrao-msft
Hi Tomkru,
Could you please confirm if your query have been resolved? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.
Thank you