Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
@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
thanks for sharing this link
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |