Forum Discussion
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...
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.
Thank you!