Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Salesforce ID as a link



I would like to have a table in power bi which shows a list of salesforce record client record ID which are clickable and link back to the full  salesforce record.


I am trying to do this using salesforce lighting.


Does any one have any one know if this can be done.





Helper I
Helper I

@jennratten thank you for your help. Your revision to the link function works prefectly well.

View solution in original post

Helper I
Helper I

@jennratten thank you for your help. Your revision to the link function works prefectly well.

Wonderful!  So glad to help.

Community Support
Community Support

Hi @Redfox_delta1 ,

If I understand correctly, you would like to click the salesforce record client record ID and it will open the related salesforce record. If so, please check if the method in the following thread is suitable for you.

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

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

Change Data Category to WebURL


Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yiruan-msft 

Thank you for your response.

I have used your solution but this is an example of what my SF view url looks like 

Please note the /view at the end of the ColumnLink function.

How can I add the /view after the [Id] as I need it for my URL to work so I can see the SF record.

ColumnLink = "" &Campaign[Id]


Thank you

@v-yiruan-msft do you have solution to making my URL work?


This is the final URL that would make my SF link work 

This is the Power BI function ColumnLink = "" &Campaign[Id]   but how do I need /view to the function to make the url like this 

Hello - I have shown the revision below that is needed to include /view at the end of the url.  After you have this created, change the data category for the column to web url.  If you'd like to display a link icon instead of the entire URL, in your table/matrix visual, you go to the visual formatting > Cell Elements > select the field > turn on Web URL and URL Icon.


ColumnLink = "" & Campaign[Id] & "/view"

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors