Forum Discussion

manoj_0911's avatar
manoj_0911
Kudo Commander
5 months ago
Solved

Best practice to switch/replace data sources between environments (DEV/PROD) in Power BI?

Hi everyone,   I wanted to check if there is a better or recommended way to switch or replace data sources in Power BI when moving reports between environments.   In our reports, we use a data mo...
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    5 months ago

    Step 1) Use Power Query parameters

    Create parameters for environment-specific parts of the connection.

    Example parameters:

    • ServerName
    • DatabaseName
    • Warehouse (Snowflake)

     

    Step 2) Use Deployment Pipelines 

    If you're using Power BI Service / Fabric workspaces, Deployment Pipelines allow you to define different connection rules per stage. You can configure data source rules so the dataset automatically connects to the correct environment during deployment.

v-tejrama's avatar
v-tejrama
Community Support
5 months ago

Hi manoj_0911 ,

 

Thank you cengizhanarslan  for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you.