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 to extract data from a folder on SharePoint. I am getting stuck linking the source file to the query.
Aravind
2 Replies
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?
You also need to make sure that your licence entitles you to use From SharePoint folder, you need Microsoft 365 Apps for Business or E3 or higher, it does not work with Business Standard
