Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
Hello,
We are passing in query string parameters in URLs to filter Power BI reports. It is working properly.
https://app.powerbi.com/groups/ABC/ReportSection?filter=TableName/FilterName eq 'Haagen Dazs' - This works
But, we have a value which we are trying to filter on which contains an ampersand - i.e. 'Ben & Jerry'.
This does not work. I tried converting the ampersand to unicode and it did not work. i.e. 'Ben _x0026_ Jerry'
Does anyone know how to fix this?
https://app.powerbi.com/groups/ABC/ReportSection?filter=TableName/FilterName eq 'Ben & Jerry' - This does not work
Appreciate any assistance you can provide.
Thanks,
Dan
Solved! Go to Solution.
Thanks @Greg_Deckler
Your answer helped me look in the right direction - used %26. That worked.
So, all set. Thanks again!
@dancarr22 Perhaps & or &
Thanks @Greg_Deckler
Your answer helped me look in the right direction - used %26. That worked.
So, all set. Thanks again!
User | Count |
---|---|
34 | |
21 | |
21 | |
14 | |
12 |
User | Count |
---|---|
26 | |
19 | |
18 | |
18 | |
14 |