Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Dunner2020
Post Prodigy
Post Prodigy

Finding url of item in Sharepoint

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?

1 ACCEPTED SOLUTION
mahoneypat
Microsoft Employee
Microsoft Employee

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

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

1 REPLY 1
mahoneypat
Microsoft Employee
Microsoft Employee

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

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors