Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Connect Semantic model to QA lakehouse when deploying from DEV environment

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!!

data engineering
lakehouse
  • v-aatheeque's avatar
    v-aatheeque
    1 year ago

    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!




     

2 Replies

  • v-aatheeque's avatar
    v-aatheeque
    Icon for Community Support rankCommunity Support
    1 year ago

    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's avatar
      v-aatheeque
      Icon for Community Support rankCommunity Support
      1 year ago

      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!