Data Source with same query editor change

[Anonymous]

Hello,

I used an excel file as my data source and have used the query editor to transform the data. Now the data comes from an excel file in share point however the data is in the same format as the original excel file I've used. So, I want to keep the same query editor edits. What is the right way to change the data source will keeping the same query editor edits?

[v-lili6-msft · Accepted solution]

hi @Anonymous 

You could just replace the datasouce for this pbix file as below:

https://community.powerbi.com/t5/Desktop/How-to-replace-Data-Source-for-existing-report/td-p/58947

https://www.c-sharpcorner.com/article/how-to-change-data-source-of-existing-report-in-power-bi/

https://windowsreport.com/change-data-source-power-bi/

Regards,

Lin

[DataInsights]

Here's the approach I use:

--In the original query, go to Advanced Editor and copy the M code. Paste in Notepad.

--Create a new query that points to the SharePoint spreadsheet.

--In the new query, go to Advanced Editor.

--Copy the transformation steps from the original query in Notepad, and paste below the auto-generated steps in the new query. You'll have to account for the renaming of steps to make it integrate.