Forum Discussion

mnkumar249's avatar
mnkumar249
New Member
10 months ago
Solved

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

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  

Need Help
Tutorial Requests

4 Replies

  • Mauro89's avatar
    Mauro89
    Icon for Super User rankSuper User
    10 months ago

    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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 months ago

    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's avatar
      mnkumar249
      New Member
      10 months ago

      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.