Forum Discussion
Data Source Deployment Rules for Semantic Models in Direct Lake Storage Mode
Hi Fabric Community!
This is my first time posting here, thank you in advance for your help!
I’m struggling with a deployment pipeline for a semantic model in Direct Lake storage mode. From Microsoft Documentation, I understand the following:
"When a Direct Lake semantic model is deployed, it doesn't automatically bind to items in the target stage. For example, if a LakeHouse is a source for a DirectLake semantic model and they're both deployed to the next stage, the DirectLake semantic model in the target stage will still be bound to the LakeHouse in the source stage. Use datasource rules to bind it to an item in the target stage. Other types of semantic models are automatically bound to the paired item in the target stage."
Retrieved from https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/understand-the-deployment-process?tabs=new-ui#semantic-model-limitations
The problem I’m facing is that I cannot define data source deployment rules as suggested—the section is greyed out. Since I’m the owner of the model, that shouldn’t be the limitation.
Here’s my setup:
My direct lake semantic model contains multiple tables from different DEV lakehouses across different DEV Fabric workspaces.
My goal is to define a data source deployment rule for my data sources and map them to the respective TEST lakehouse.
I created the semantic model in Direct Lake mode using the new "direct lake mode flavour" OneLake mode, not SQL endpoint mode, because I wanted to combine tables from different source lakehouses in the same model (multi-source support) (https://data-mozart.com/a-tale-of-two-direct-lakes-in-microsoft-fabric/).
Could using the new Direct Lake flavour "OneLake mode" be the reason I cannot define deployment rules / data source rules for my direct lake semantic models? Does anyone have experience with deploying such models?
Looking forward to your insights!
Greetings from Switzerland,
Cleora
Hi Cleora
Yes, as per the Microsoft documentation - data source deploymet rules are currently not suported for semantic models created in Direct Lake OneLake mode. Already you figured it in Microsoft documeentation. This is available only for SQL analytics endpoint mode not for onelake mode.
My suggestion is you can do manula binding or use SQL endpoint mode.
Hope it helps you.
Please let me know if you need any additional help.
Thank you!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
4 Replies
Hi Cleora
Yes, as per the Microsoft documentation - data source deploymet rules are currently not suported for semantic models created in Direct Lake OneLake mode. Already you figured it in Microsoft documeentation. This is available only for SQL analytics endpoint mode not for onelake mode.
My suggestion is you can do manula binding or use SQL endpoint mode.
Hope it helps you.
Please let me know if you need any additional help.
Thank you!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!I have been struggling with changing the Source of my DirectLake Semantic model to another Lakehouse. I found a workaround.
- I created a Deployment Pipeline to move the Model from Dev to Test.
- I edited the Semantic Model in Test in Power BI Desktop
- Opened Tabular Editor 2
- Under Shared Expressions, I changed the Workspce and Lakehouse GUIDs in the url part of the expression
I have also tested running the Deployment Pipeline with chnages and it writes over the url, so you will need to chnage it after each deployment using the process above.
There are other ways using GIT that do it automatically, but I'm not that far yet. Here is an article about it.
https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/Programmatically-deploy-Semantic-Models-and-Reports-via-Semantic/ba-p/4624464
Thanks
JoeHi Joe_Barry Thanks for sharing the workaround. We really appreciate your effort.
I'm dealing with this as well, there is an existing request to add Direct Lake support which can be voted on here: https://community.fabric.microsoft.com/t5/Fabric-Ideas/Deployment-pipeline-Deployment-rules-for-Direct-Lake-on-OneLake/idi-p/4678000
