Forum Discussion
Helper ISalesforce ID as a link
jennratten thank you for your help. Your revision to the link function works prefectly well.
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
Hi Anonymous
Thank you for your response.
I have used your solution but this is an example of what my SF view url looks like
https://test.lightning.force.com/lightning/r/Campaign/9014X999002ZfDvQAK/view
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 = "https://test.lightning.force.com/lightning/r/Campaign/" &Campaign[Id]
Thank you
Redfox_delta1Anonymous do you have solution to making my URL work?
This is the final URL that would make my SF link work https://test.lightning.force.com/lightning/r/Campaign/9014X999002ZfDvQAK/view
This is the Power BI function ColumnLink = "https://test.lightning.force.com/lightning/r/Campaign/" &Campaign[Id] but how do I need /view to the function to make the url like this https://test.lightning.force.com/lightning/r/Campaign/9014X999002ZfDvQAK/view
- jennratten
Super User
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 = "https://test.lightning.force.com/lightning/r/Campaign/" & Campaign[Id] & "/view"
