Forum Discussion

shubhamc_002's avatar
shubhamc_002
Helper I
3 years ago
Solved

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 fo...
Need Help
  • SwayamSinha's avatar
    SwayamSinha
    3 years ago

    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

shubhamc_002's avatar
shubhamc_002
Helper I
3 years ago

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

SwayamSinha's avatar
SwayamSinha
Microsoft Employee
3 years ago

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