Changing data locations

[N-Noisy-boey10_]

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

[V-lianl-msft]

Hi @N-Noisy-boey10_ ,

Click Transform data -> Data source setting ->Change data source -> Choose new file in other location

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@N-Noisy-boey10_ , One option is deployment pipeline with premium

Other is these two ways

https://www.youtube.com/watch?v=XIq5vN5oPf8

https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters