cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shubhamc_002
Helper I
Helper I

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
Helper I
Helper I

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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors