The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
Solved! Go to 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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.