Forum Discussion
Transferring data source but cannot add more than one data source
I would like to get the data from other path as i changed the file place, but after clicking data source setting, it seems that only one data source can be changed. However, in the Power Query, i ha...
Do not connect to individual files. Connect to folders (ideally Sharepoint Folders) and then handle the file addressing as part of your Power Query code.