Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
HI Team,
I am facing one issue while passing filter via URL using query string parameter. Table column contains / in it and have checked Microsoft Docs which suggested to use escape character for / which is %2F even after using this also its not accepting as filteration of data.
Please advise if anyone having solution for this.
Consider Table name = Country
Column Name = State/SubDiv
Value = Test
eg: [appurl]+?filter=Country/State%2FSubDiv in ('Test')
Thanks
Solved! Go to Solution.
If you refer the document it says:
"When your query contains spaces, dashes, or other non-ASCII characters, prefix those special characters with an escape code starting with an underscore and an X (_x), then the four-digit Unicode, then another underscore"
So you need to have State_x002F_SubDiv instead
Hi @SwayamSinha ,
I have already referred this and based on information provided here , replaced / with %2F while building query in PBI report but its not working.
Let me know if you have solution for this.
Thanks
If you refer the document it says:
"When your query contains spaces, dashes, or other non-ASCII characters, prefix those special characters with an escape code starting with an underscore and an X (_x), then the four-digit Unicode, then another underscore"
So you need to have State_x002F_SubDiv instead
Have a look at this MS document :
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
30 | |
20 | |
19 | |
13 | |
13 |
User | Count |
---|---|
28 | |
18 | |
18 | |
16 | |
14 |