Forum Discussion

Dragon1's avatar
Dragon1
New Member
10 years ago
Solved

reuse query steps

Very new to Power BI, so please forgive me if this is something simple I'm missing.   Each week I get a spreadsheet sent to me that I want to add into Power BI as a new table/data source. The sprea...
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    Dragon1 If spreadsheet is going to have same number of columns and names just with poor data each time then in power bi desktop you can go to query editor, right click your original query and make duplicate of it. Then simply click on setting icon next to Source (first step in query) and point it to your new spreadsheet and click Refresh. This will repeat all those steps you applied previously. As said earlier if metadata of your spreadsheet hasn't changed but only data needs cleaning.

tc5pt's avatar
tc5pt
Regular Visitor
7 years ago

ankitpatira Is it possible to do this if I want to apply the steps to a different sheet in the same workbook? When I go to change the source it only allows me to change the primary file and does not redirect me to choose the sheet like it does when I first Get Data. Thank you.

jithu0's avatar
jithu0
Frequent Visitor
7 years ago

tc5pt 

In the edit queries mode,

go to the advanced editor of the table where you have done the changes and copy the steps that involves the changes.

Go to the advanced editor of the table to which you want to replicate the changes and append the codes that you copied.

The changes will be effected.

Ensure the references are correct and there are no errors after you paste the format/cleanup codes.