Transferring data source but cannot add more than one data source

[Anonymous]

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 have several data source need to changed. how could i deal with this issue?

[v-yalanwu-msft]

Hi, @Anonymous ;

Is your problem solved?  If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @Anonymous ;

You could set the data source.

or connect the folder.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

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.