Forum Discussion
Excel SharePoint PowerQuery
I have placed some excel workbooks in Teams. One of the workbooks contains queries that extract and re-combine data from the other(s). I can make the data source links function when referring t...
Article you mentioned gives explains correct and these days more or less standard way to connect single file on SharePoint site.
Error you have most probably is due to wrong Data Source settings. Please check Data table update issue using Power Query - Microsoft Community for more details.