Changing data locations

Hey all, I hope you guys are doing well and staying safe. Thanks for the help before

I was wondering if there is any way to change the data location without changing the data location from the Advanced editor for every single Queries?

For example: All the data for the visuals are connected to a sharepoint folder in one excel file and I've dummy data on some other folder in the sharepoint. The dummy excel file has the same sheet name and rows and columns as that of the real excel file.

I tried doing the Advanced Editor thingy but it cosumes too much time. So if there any simplar way?

Any help would be appreciated.

Thanks,

Abhishek