Switching Between Test and Production Databases in Power BI

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