The purpose of this example is to demonstrate how to change data source from uskibpw1 to bpw.kemin.com in Power Query.
Open the excel file, then select the Data tab, choose Queries & Connections to open Power Query.
After Power Query opens, select Data source settings.
The report is currently connected to uskibpw1. To change source, select Change Source…
Change the server from uskibpw1 to bpw.kemin.com. Then select OK.
Now, the data is connected to bpw.kemin.om. Then select Close.
Select Close & Load to apply the changes.