Forum Discussion
dp106
Helper I
Helper IURL Encoding While passing passing parameter thru URL
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 ...
v-cherch-msft
Microsoft Employee
Microsoft EmployeeHi 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
dp106Thanks 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