Switch Snowflake Environments (UAT → PROD) Using Parameters & Deployment Pipelines

[mnkumar249]

I have a Power BI report connected to Snowflake with multiple environments:

• UAT
• PROD

Currently, I manually change Snowflake connection details (warehouse, role, database) in Power BI Desktop when moving from UAT to PROD. This is time-consuming.

I tried using parameters to switch environments. It works in Desktop (sometimes needs applying changes twice), but in Power BI Service, I get this error:

This means my approach is treated as a dynamic data source, so refresh is blocked.

Goal:

• Publish report in UAT workspace with UAT Snowflake details.
• After approval, use Deployment Pipelines to push to PROD workspace.
• Automatically switch Snowflake details without manual edits or republishing.
• Ensure scheduled refresh works in Service.
• Prevent direct changes in PROD workspace.

What is the best way to switch Snowflake environments (UAT → PROD) using parameters or other methods ?

@Mxd24 @Ritaf1983 @danextian @Shubham_rai955  @grazitti_sapna @MasonMA  

[v-hjannapu]

Hi @mnkumar249,

I would also take a moment to thank @GilbertQ  , @Mauro89  for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
Community Support Team.

[mnkumar249]

Thank you All, Issue is resolved.

Created three parameters (Warehouse, Role, Name) and assigned it. Configured deployment rules at power bi service to switch between UAT to PROD.

Now it's working successfully.

[GilbertQ · Accepted solution]

Hi @mnkumar249 

There are some details on how to use the deployment pipeline Rules. Create deployment rules for Fabric's ALM - Microsoft Fabric | Microsoft Learn

[Mauro89]

Hi @mnkumar249,

what you basically can do to switch environment details is by using the Fabric deployment pipelines and their deployment rules. There you can change values for several Fabric items. 

Best regards!