Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Switch between GCP environments for all tables

I have Power BI desktop linked through DirectQuery to a GCP (Google Cloud Platform) environment with 15 tables. 

There are 3 GCP environments (dev, test and prod), all with the same 15 tables.

 

I'd like to be able to easily switch ALL 15 tables from one environment to another (e.g. from dev to test) quickly. 

At the moment, I need to go into each table and manually change the source one by one. Is there an easier way to do this? 

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    Try to create a Power BI template. You can try to define parameters for different environments. When the user opens the template, switch the data source by selecting the parameters.

    Power BI Templates - Power BI Tutorials & How To

     

    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.

     

2 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    Try to create a Power BI template. You can try to define parameters for different environments. When the user opens the template, switch the data source by selecting the parameters.

    Power BI Templates - Power BI Tutorials & How To

     

    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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks Lionel! I didn't end up using a template, but I did create a parameter for the source, and then used the parameter in the advanced queries for each table.