sharepoint online list item url in Power BI

[Ryanc2258]

I am using a Sharepoint list as my datasource and I am using PowerBI to help users sort and view items from the Sharepoint List, and create report base on sharepoint list data. I want the ability for a user to click the list item URL from PowerBI, which would redirect them from PowerBI into Sharepoint. I cannot find the colume to show item url to be used as filed. Is there a way to create this direct URL to the Sharepoint list item using power query?

[Anonymous]

Hi @Ryanc2258 ,

You could format a URL as a hyperlink in Power BI Desktop

Add hyperlinks (URLs) to a table or matrix - Power BI | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ryanc2258]

Hello Stephen

Thank you very much. 

My question is not about the formating URL. My question is how to get the url for each sharepoint list item and then import to Power BI

Thank you very much

Ryan

[mahoneypat]

You can generate a url with this pattern to link to a specific link item. You will need to update the parts in red (see the url when you are on the list page to get them).

https://yourtenant/sites/SiteName/Lists/ListName/DispForm.aspx?ID=1 

(dynamically concatenate the ID # to the rest of the url).

Pat