Chnage Data Source

[SkorpionAAM]

I am trying to chnage the data source(sql connection) to Google Sheet (Web) power BI reports i am using gateways also.

[PaulDBrown · Accepted solution]

@SkorpionAAM 

I Just did this this afternoon. The premise to ensure all is well is to make sure that all the column names remain unaffected.
Here are the steps I followed:

1) save your original Desktop file ("Original File") with a new name to test the new source: let's call this "Test File".

2) Save a backup copy of your original PBIX file with a different name just in case...Let's call this "Backup File"

3) open a new PBI file and carry out the import from the new source in Power Query. Make sure the column headers are excactly the same as the original table. Let's call this file "New Import File".

4) Copy the whole M code from your new PBI file import query (from "New Import File"). Select the query in the newly saved copy of original ("Test File"), and replace the M code in the query.

5) Apply changes and check that there are no errors in the tables/measures.

6)) If all is well, save this file to replace (same file name) the original ("Original File").

7) If there is a problem, you have the "Backup File" to fall back on

[amitchandak]

@SkorpionAAM , I think a difficult one.

Make sure all column names are the same and in the same case.

Create a new connection and add the tables from other sources.

Open transform data/edit query, right on the table and open advance editor, take the code from a new source and replace it in the old source. Carefully replace the connection and column list only.

Keep a backup of the original file. This might not work.