How to convert these encode url to normal text.

[Anonymous]

Dear PBI Community,

I tried to decode the URI as below, but i got the error

As i know PowerBi dont have this function  UriUnescapeDataString.

Kindly help me.

[v-jingzhang · Accepted solution]

Hi @Anonymous 

You can use Uri.Parts to decode a Uri part. There is an example in the previous link. 

You can convert above code to create a custom function like below and name it as UriUnescapeDataString. Create a blank query and open its Advanced Editor. Paste the following code there. 

(data as text) as text =>
let 
    DecodedText = Uri.Parts("http://contoso?a=" & data)[Query][a]
in
    DecodedText

Then invoke this custom function in other queries just like using built-in functions. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Anonymous]

Yeahh, thank you.

[amitchandak]

@Anonymous , You have a few in power query

https://docs.microsoft.com/en-us/powerquery-m/uri-functions

https://community.powerbi.com/t5/Desktop/URL-Encoding-While-passing-passing-parameter-thru-URL/m-p/512229