Excel Query connecting to a SharePoint file error

Question

I have multiple Excel spreadsheets connected to a Main spreadsheet via Query. All of the files are saved in SharePoint but we use the native app to edit them given they have Macros and VBA functions.

My problem is , after 2 months of normal use, I suddenly cannot refresh the Main spreadsheet to pull all the data from the individual spreadsheets connected to it. It is now showing "[DataSource.Error] SharePoint: Request failed: url..."

I already tried recreating a query the way I set them up initially and still having the same issue. Any help is greatly appreciated.

Thanks,

Neil

nikolinode · Answer

NeilEsparrago&nbsp;My knowledge of PQ is limited, but maybe this link will help you to solve your problem.Connect to a SharePoint folder from Power Query&nbsp;&nbsp;Thank you for your understanding and patience&nbsp;NikolinoDEI know I don't know anything (Socrates)

patrick2788 · Answer

I'd start with the source. Are you able to open the workbook directly through SharePoint?

neilesparrago · Answer

Thanks&nbsp;NikolinoDE&nbsp;, will check this out

neilesparrago · Answer

Yes, all of the connected files are working on their own That's why I'm confused why the query can't pull up the data within them which was working previously.

Forum Discussion

Excel Query connecting to a SharePoint file error

4 Replies

Resources