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...
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.

     

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.