cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leroy773 Regular Visitor
Regular Visitor

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Vvelarde Super Contributor
Super Contributor

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

hi @leroy773

 

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

 

Change Data Category to WebURL

 

newcolumnLink.png




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

5 REPLIES 5
Vvelarde Super Contributor
Super Contributor

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

hi @leroy773

 

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

 

Change Data Category to WebURL

 

newcolumnLink.png




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

kimzhao Visitor
Visitor

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

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.

Highlighted
alonb Regular Visitor
Regular Visitor

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

Hi,

 

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

elads Regular Visitor
Regular Visitor

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

Hi,

 

Does it have a solution?

 

BR

elads Regular Visitor
Regular Visitor

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

Hi @kimzhao ,

 

Did you find a solution to your question ..?

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 228 members 2,461 guests
Please welcome our newest community members: