URL Encoding While passing passing parameter thru URL

[dp106]

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

[powerbiclaroty]

Did you solve it? Same here

[michaelshparber]

Uri.EscapeDataString(part_of_url)

double encoding:

Uri.EscapeDataString(Uri.EscapeDataString(part_of_url))

[v-cherch-msft]

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

[dp106]

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