Add Http:// to a link address if its missing?

[Matthew77]

Hi everyone,

I have URLs that start with stssyn:// which is not compatible with power bi to show this as a hyperlink. Example:

Is there a way to force these links that don't have https to add the http:// in at the start so power bi recognises them as valid links? 

Regards,

Matthew 

[Tahreem24 · Accepted solution]

@Matthew77 ,
Your URLs must start with all the below prefix in order to work in PBI. This is the screen shot from Microsoft doc and I am attaching SS and link for your reference.

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables

OR Try to deploy your URL's or it's contents to this mentioned Prefix websites. (if possible)

[v-eqin-msft]

Hi @Matthew77 ,

You may try to use "Replace values" in Power Query:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

SUBSTITUTE function (DAX) - DAX | Microsoft Docs