Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dp106
Helper I
Helper I

URL 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 way we can encode the URL string in Power BI.

 

Thanks

 

4 REPLIES 4
powerbiclaroty
New Member

Did you solve it? Same here

michaelshparber
Advocate V
Advocate V

Uri.EscapeDataString(part_of_url)

 

double encoding:

Uri.EscapeDataString(Uri.EscapeDataString(part_of_url))

 

v-cherch-msft
Microsoft Employee
Microsoft Employee

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.