Forum Discussion
Salesforce ID as a link
- 3 years ago
jennratten thank you for your help. Your revision to the link function works prefectly well.
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
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"