Forum Discussion
Pull Sharepoint File URL
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.
3 Replies
- amitchandak
Super User
Anonymous , 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
akhaliq7Post Prodigy
thanks for sharing this link
v-xiaotangCommunity Support
Hi Anonymous
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.
