Forum Discussion
Helper ISalesforce ID as a link
Hi,
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.
Thanks
Redfox_delta1
jennratten thank you for your help. Your revision to the link function works prefectly well.
6 Replies
Redfox_delta1jennratten thank you for your help. Your revision to the link function works prefectly well.
- jennratten
Super User
Wonderful! So glad to help.
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_delta1
Anonymous 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
