Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
Solved! Go to 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"
So you need to have State_x002F_SubDiv instead
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
Have a look at this MS document :
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
User | Count |
---|---|
34 | |
21 | |
21 | |
14 | |
12 |
User | Count |
---|---|
26 | |
19 | |
18 | |
18 | |
16 |