Forum Discussion
Extract data from a folder with excel files saved on sharepoint
Hello all. I need help to know how I can extract data from Excel files saved in a folder on SharePoint. I have been able to link files on OneDrive with no issues. Now I need to rewrite the query ...
Are you using the SharePoint folder connector? See: https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder
Alternatively if you're trying to connect directly to an Excel file stored within a SharePoint folder refer to https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
You mentioned you've been able to link files on OneDrive already, but not sure if you have used the web connector method in the link above, which should work for Onedrive or SharePoint?