Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Tomkru
Regular Visitor

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?

1 ACCEPTED SOLUTION
v-saisrao-msft
Community Support
Community 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

View solution in original post

4 REPLIES 4
v-saisrao-msft
Community Support
Community Support

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

v-saisrao-msft
Community Support
Community Support

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
Community Support
Community Support

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
Community Support
Community 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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.