Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

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 Employee
Microsoft Employee

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors