Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
28 | |
26 | |
22 | |
22 | |
18 |
User | Count |
---|---|
51 | |
34 | |
28 | |
24 | |
21 |