Changing Data Source

[KMichael99]

Hi,

I currently have 19 Google Sheets workbooks connected to Power Bi, but am looking to transfer these across to Microsoft Excel without changing any visualisations. 

I thought it would be as easy as changing the data source settings, but this option isn't available. I've read online that I will have to connect each new Excel workbook and can copy across the whole Advanced Editor script to apply the same steps. However, as this is a new data source, this will break the visualisations and DAX measures I have... which there are far too many for me to want to do this!

Can anyone think of a work around for this? 

Thanks

[olgad · Accepted solution]

Hi, you connect to excel and copy from excel Advanced Editor to your existing query, this way you dont break anything. 

Step 1 connect to excel, copy the part till in

Step 2, go to your existing table connected to google sheet, replace, dont forget comma before your other steps

if you copy the steps from your query to new excel query, you will break everything, but the other way around, copying the datasource of excel to your existing query will not break anything.