URL Encoding While passing passing parameter thru URL

Question

Hi,&nbsp;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).&nbsp;Is there a way we can encode the URL string in Power BI.&nbsp;Thanks&nbsp;

v-cherch-msft · Answer

Hi&nbsp;dp106&nbsp;You may have a look at below articles.https://docs.microsoft.com/en-us/power-bi/service-url-filtershttps://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/&nbsp;Regards,Cherie

dp106 · Answer

Thanks for your response.&nbsp;I did go thru these documents before but could not get the filter condition working.&nbsp;Here are the values in the filter condition&nbsp;M&amp;M&nbsp; - &amp; is replaced with %20 so the filter string&nbsp;is M%20M. This works fine&nbsp;Mgmt-Int'l - ' is replaced with %27 so the filter string&nbsp;is Mgmt-Int%27l. When i look the URL in the browser, it&nbsp;see only Mgmt-Int rest is cutoff&nbsp;so the filter is broken.&nbsp;Any one facing similar issue ?&nbsp;Thanks

michaelshparber · Answer

Uri.EscapeDataString(part_of_url)&nbsp;double encoding:Uri.EscapeDataString(Uri.EscapeDataString(part_of_url))&nbsp;

powerbiclaroty · Answer

Did you solve it? Same here

Forum Discussion

URL Encoding While passing passing parameter thru URL

4 Replies

Related content

Fabric passing parameter

Pass Parameters to SQL Queries

Passing Parameter to warehouse

Passing Parameters in measures

pass parameters to dataflow