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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
leroy773
Helper II
Helper II

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
Vvelarde
Community Champion
Community Champion

hi @leroy773

 

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

 

Change Data Category to WebURL

 

newcolumnLink.png




Lima - Peru

View solution in original post

5 REPLIES 5
Vvelarde
Community Champion
Community Champion

hi @leroy773

 

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

 

Change Data Category to WebURL

 

newcolumnLink.png




Lima - Peru

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.

Hi @kimzhao ,

 

Did you find a solution to your question ..?

Hi,

 

Does it have a solution?

 

BR

Hi,

 

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors