Switching Between Test and Production Databases in Power BI

[raaan12]

Hi everyone,

I have a question regarding environment management in Power BI. I’m working with two different MongoDB databases that have the exact same structure but different data—one for testing and one for production. I’ve done all the data modeling, transformations, and report creation using the test database.

Now, when it’s time to move to production, do I have to redo everything using the production database, or is there a way in Power BI to simply switch the data source while keeping all the transformations and visuals intact, given that the structure is identical? I’m looking for the most efficient way to handle this kind of environment switch.

Thanks in advance for your help!

[mh2587 · Accepted solution]

You don't need to redo everything just create two parameters one for test and one for prod, just follow the below steps

Steps to Switch MongoDB Environments in Power BI

Step 1: Create a Parameter

1. Go to Home in Power BI Desktop.

2. Select Manage Parameters, then choose New Parameter.

3. Name it something like MongoDB_URI.

4. Set the Type to Text.

5. Enter your test MongoDB connection string (e.g., mongodb://test-server:27017) as the Current Value.

6. Click OK.

   ---

   Step 2: Use the Parameter in Power Query

   1. Go to Transform Data to open Power Query Editor.

   2. Find your existing MongoDB source step in the query (usually called Source).

   3. Replace the hardcoded URI with the parameter: MongoDB.Contents(MongoDB_URI)

   4. Click Close & Apply.

      ---

      Step 3: Switch to Production

      1. Go back to Manage Parameters.

      2. Change the MongoDB_URI value to your production MongoDB URI (e.g., mongodb://prod-server:27017).

      3. Apply the changes.

      4. Refresh your data.
         
         For better understanding follow the below video:
         https://www.youtube.com/watch?v=OnaDJkGOmIE

[raaan12]

thank you for this response, I'll try that thank you again!