Direct Link to an Item in SharePoint List from within Power BI

[Anonymous]

I have a simple Power BI report which is based on a SharePoint Online List. I am creating a table visual and i would like users to be able to directly access a Link and open that particular List Item (not the whole list). But I do not see any Link/URL column available in Power Query with an actual link to the List Items. 

Can someone please help  if there is any way to achieve the stated funcationality?

[varunvasudeva1]

For future reference to anyone who finds this thread:

I have a very similar use case to the original poster and my data is being sourced from SharePoint via an OData Feed. This gives you access to a host of attributes, namely [Path] and [Name]. [Path] is the folder path to the file without the filename and extension and [File] is only the filename and extension. I made a URL column (by making a new custom column and utilizing Text.Combine()) of the following structure:

https://{organization}.sharepoint.com/{path}/{name}

However, this led to the system opening the files that it could in the browser (PDFs, images) but defaulted to downloading binary files like .xlsx, .docx, and .pptx. I wanted, instead, for it to open in SharePoint Online no matter the file type.

Changing the URL to the following form did the trick:

https://{organization}.sharepoint.com/:w:/r/{path}/{name}?csf=1&web=1

With the above form, the link will automatically conform to SharePoint's standardized link structure with 'sourcedoc' and 'file' query parameters, without you needing to specify them - all you need is the file path and name coupled with the 'csf' and 'web' parameters.

Hope this helps!

[diegovelez]

You are a legend sir. It even works with csv files!

[TomMartens]

Hey @Anonymous ,

unfortunately, it's not possible what you are aiming for.

Maybe this can help:

• Create a table that contains all the items (this is basically the idea of Power Query)
• Create/Use a column that helps the user to identify the item
• Create a column that contains an URL that points to the item as a string
• Load the query to the Power BI dataset
• Mark the column and change the data category of the column Web url
  

Now you can use the column inside a Table visual and use the link as expected.

Hopefully, this helps to tackle your challenge.

Regards,

Tom