cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shubhamc_002
Frequent Visitor

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

1 ACCEPTED 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"

SwayamSinha_0-1667820797062.png

So you need to have State_x002F_SubDiv instead

View solution in original post

3 REPLIES 3
shubhamc_002
Frequent Visitor

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"

SwayamSinha_0-1667820797062.png

So you need to have State_x002F_SubDiv instead

SwayamSinha
Microsoft
Microsoft

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.