Finding url of item in Sharepoint

[Dunner2020]

Hi there,

I am reading a list from SharePoint online. Now I want to get the URL of each record or item of the list and present it in the dashboard so that when the user clicks on the URL the record appears on the browser. I tried to find the  URL of an individual item of the list on share point when I import SharePoint data in the Power BI but could not find it. I found the URL of the attachment but it's not very helpful. Could anyone help me how can I find the URL of the item on the list from Sharepoint?

[mahoneypat · Accepted solution]

You can get the ID value for each item and then concatenate it in a custom column with the expression below.  Replace the stuff inside the < > s (delete the < >).

= "https://<tenant url>/sites/<site name>/Lists/<List Name>/dispform.aspx?ID=" & [ID]

Pat