Forum Discussion
Query string Paramater in URL not working if column name contains " / " in it
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
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
3 Replies
Have a look at this MS document :
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
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
