Connect Semantic model to QA lakehouse when deploying from DEV environment

[Anonymous]

Hi Team,

I have 2 workspace one for DEV and for QA, now i have created a sematic model in dev workspace connecting to the dev lakehouse data, and on top of it there is a PBI dashboards created, now I have deployed the DEV semantic models and Dashboard to QA workspace but still the semantic model is connected to DEV lakehouse.
How to change the connection of semantic model to connect to QA lakehouse from DEV lakehouse??

Thanks in advance!!

[v-aatheeque]

Hi @Anonymous ,

Thanks for reaching out on Microsoft Fabric Community Forum.

To better assist you in changing the connection of your semantic model from the DEV lakehouse to the QA lakehouse, could you please clarify which storage mode you are using for your model?
 Are you using Import Mode or Direct Query?

This information will help us understand the best approach for updating the data source.

[v-aatheeque · Accepted solution]

Hi @Anonymous 

In addition to above points regardig the connection of semantic model to connect to QA lakehouse from DEV lakehouse :

• Use deployment rules in Power BI to manage data connections when transitioning between environments.
• In the deployment pipeline, create a rule that specifies the connection string for the semantic model.Set the rule to replace the existing connection to the QA lakehouse with the SQL Analytics Endpoint of the production lakehouse.
• Once the rule is set up, deploy the semantic model to the production workspace. The deployment rule will automatically update the connection to point to the production lakehouse.
• After deployment, verify that the semantic model is correctly connected to the production lakehouse and functioning as expected.
  
  

Additonally you can refer this doc :
Get started using deployment pipelines, the Fabric Application lifecycle management (ALM) tool - Microsoft Fabric | Microsoft Learn

Demystifying Fabric Deployment Pipelines

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!