Switch between GCP environments for all tables

[Anonymous]

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? 

[v-lionel-msft · Accepted solution]

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]

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.