Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Re-using the applied steps for multiple databases

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!

Need Help

3 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    6 years ago

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

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

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

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    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.