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 dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I am filtering a report using Query String Parametrs in URL. The reports breaks when it encounters special charaters like Ampersand, Quote etc in the filter condition (value).
Is there a way we can encode the URL string in Power BI.
Thanks
Did you solve it? Same here
Uri.EscapeDataString(part_of_url)
double encoding:
Uri.EscapeDataString(Uri.EscapeDataString(part_of_url))
Hi @dp106
You may have a look at below articles.
https://docs.microsoft.com/en-us/power-bi/service-url-filters
https://powerbi.microsoft.com/en-us/blog/filter-a-report-with-a-url-query-string-parameter/
http://www.dutchdatadude.com/passing-filters-to-power-bi-reports-using-the-url-query-string/
Regards,
Cherie
Thanks for your response.
I did go thru these documents before but could not get the filter condition working.
Here are the values in the filter condition
M&M - & is replaced with %20 so the filter string is M%20M. This works fine
Mgmt-Int'l - ' is replaced with %27 so the filter string is Mgmt-Int%27l. When i look the URL in the browser, it see only Mgmt-Int rest is cutoff so the filter is broken.
Any one facing similar issue ?
Thanks
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
38 | |
31 | |
26 |