Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.