How to deploy a semantic model from DEV to PROD?

Here are the steps how you can update the connection string in your semantic model to point to the lakehouse in workspace_prod:

1. Open the semantic model file (.pbix) for the prod branch in Power BI Desktop.

2. Go to the Manage Connections dialog (usually under the Home tab). This will show you the data connections currently defined in the model.

3. Identify the connection that points to the lakehouse tables. It might have a name related to workspace_dev.

4. Depending on how the connection string is defined, you might be able to directly edit it within the Manage Connections dialog.

5. Alternatively, the connection string might be defined within the Power BI Desktop file itself (usually in XML format). In this case, you'll need to edit the file directly using a text editor.

6. Within the connection string, replace any occurrences of "workspace_dev" with "workspace_prod". Ensure you're editing the values specific to the server or database name used to connect to the lakehouse.

7. Save the changes to your .pbix file.

8. Refresh the data model in Power BI Desktop to test the connection to the workspace_prod lakehouse.

9. Once everything works as expected, you can commit your changes to the prod branch in your Git repository and deploy the updated semantic model to your Power BI service workspace_prod.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!