Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
48 | |
28 | |
21 | |
19 | |
13 |