Forum Discussion

KJarvis's avatar
KJarvis
Frequent Visitor
8 months ago
Solved

PBI Direct Lake Model - Move from dev workspace to test workspace

Hello,

 

I've created a direct lake model in our DEV workspace pointing to the lakehouse in DEV.  I tried moving the semantic model across a deployment pipeline from our DEV workspace to TEST.  However, the model is still pointing to the lakehouse in DEV, not TEST.

 

I am not able to set a deployment rule in the pipeline or even manually change the lakehouse connection from DEV to TEST.

 

Is there a way to easily repoint the lakehouse connection in a direct lake model?

  • KJarvis's avatar
    KJarvis
    8 months ago

    I was doing some more research and I found another thread that mentioned using a notebook to change connections:

    Point semantic model to a new Lakehouse 

     

    This seems to work, though it points to SQL endpoint of lakehouse instead of to the lakehouse.  I also get an error if I use a composite model - I guess using a field parameter in the model changes it to a composite model.

4 Replies

  • KJarvis 

    As of today there is no supported way to “re-point” a Direct Lake semantic model from one Lakehouse to another (DEV → TEST) after it has been created, either via:

    • Deployment pipeline rules

    • Power BI dataset parameters

    • Manual connection editing in Service

    Recommended Approach 

    Rebuild the semantic model in TEST

    The only fully supported method:

    1. Go to the TEST lakehouse

    2. Create your semantic model directly connected to it

    3. Copy measures or .bim from DEV

    4. Re-publish into TEST

    No pipeline required — you build one model per environment.

    • KJarvis's avatar
      KJarvis
      Frequent Visitor

      I was doing some more research and I found another thread that mentioned using a notebook to change connections:

      Point semantic model to a new Lakehouse 

       

      This seems to work, though it points to SQL endpoint of lakehouse instead of to the lakehouse.  I also get an error if I use a composite model - I guess using a field parameter in the model changes it to a composite model.

      • v-menakakota's avatar
        v-menakakota
        Community Support

        Hi KJarvis ,
        Thanks for reaching out to the Microsoft fabric community forum.
        Can you please confirm whether the issue is sorted or not?

        Best Regards, 
        Community Support Team.