Need to create hyperlink in power bi, i have a unique record id but need to add the URL

[leroy773]

All,

I would like to add hyperlink to a report and dashboard.  Unfortunately my data set only has the record id and not the complete url.  How should I go about adding the starting portion of the URL to the record id in the data set? 

ex

xx00u9663ids

URL

https://salesforce.com/ + SFDC record ID

[Vvelarde · Accepted solution]

hi @leroy773

Create a calculated column to concatenate "Sales force URL" and your ID column

Change Data Category to WebURL

[kimzhao]

Hi @Vvelarde, I have another question. If I only want to show ID in that field but it actually includes the url, for example when I click ID 001 it will go to http://salesforce.com/001. Thank you.

[elads]

Hi @kimzhao ,

Did you find a solution to your question ..?

[elads]

Hi,

Does it have a solution?

BR

[alonb]

Hi,

That's exactly what I need
Have you got a solution for this?