Forum Discussion

Redfox_delta1's avatar
Redfox_delta1
Icon for Helper I rankHelper I
3 years ago
Solved

Salesforce 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 ...
Need Help
  • Redfox_delta1's avatar
    Redfox_delta1
    3 years ago

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

Redfox_delta1's avatar
Redfox_delta1
Icon for Helper I rankHelper I
3 years ago

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 

  • jennratten's avatar
    jennratten
    Icon for Super User rankSuper User
    3 years ago

    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"