Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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!