Pull Sharepoint File URL

[Mat42]

I'm going around and around with this and I'm slowly losing my mind.

I'm pulling data from a bunch of files in Sharepoint. Is there any way to pull the URL for each file into Power BI along with the data? It pulls the file name across as standard, but not the entire file url. Is it possible? It would be helpful purely for reference.

I've searched, but using search terms like 'Sharepoint', 'URL', and File path' just brings up a bunch of links about linking to Sharepoint files.

[v-xiaotang]

Hi @Mat42 

if you just want to pull the URL along with the data, why don't you create a URL table in the file? and this is also a easy way to pull the URL along with the data.

Best Regards,

Community Support Team _ Tang

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

[amitchandak]

@Mat42 , if try to get data from a file that has the same type of data you should try for SharePoint folder option.

If these are individual file, then you might have load as each file

like https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links

[akhaliq7]

thanks for sharing this link