Re-using the applied steps for multiple databases

[Anonymous]

Hi, I'm working on building dashboards for the data that is coming from different zones. The data for each zone resides in differents servers. I'm using sql server to connect with power bi. Now, because of some issues, we are only working on 5 out of 7 zones. I've applied some transformations on the current data like reordering the columns, appending and splitting the columns by delimiter. I want the option of automating the process of applying steps on the databases that aren't connected yet. Is there a way to re-use the same applied steps for the new databases as and when they get imported into power bi. 

Please help me on this 

Thank you!

[v-lionel-msft]

Hi @Anonymous ,

Please refer to the case.

Re: reuse query steps 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Edit data source connection details. Same steps should work on new Database

[vanessafvg]

you can copy code from the advanced editor and change the names to suit the different connections you require