Forum Discussion
reuse query steps
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.
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.
Is there a way that this repeated steps can run automatically? For example, the new file comes into a folder every week and run a schedule job to pick up the file and run the "applied steps", etc... Thanks!
Thank you so much ankipatira. This works perfectly for what I need :smileyvery-happy:
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.
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.
In my case it's not poor data, just formatted in the Excel sheet to look like a report, made for readability, not usability. Thanks for the advice though, that worked for me too!
