Community ChampionDeployment pipeline: Deployment rules for Direct Lake on OneLake semantic models
Currently, it is not possible to use deployment rules with Direct Lake on OneLake semantic models.
The option is greyed out.
Please enable this, so we can automatically change the data sources when deploying from dev to prod.
19 Comments
jhillsAdvocate II
Definitely a must have feature to make deployment pipelines usable for Direct Lake on OneLake semantic models.
jkers55Advocate I
Very annoying that this does not exist for Direct Lake models ... Would make me use Direct Lake models a lot more instantly...- wardy912
Super User
Please fix this soon! Current workaround: Push to github, then edit model/definition/tables/expressions.tmdl. Replace the connection string. I found an other workaround than the one from wardy912 ; I managed to change my Semantic Model from Direct Lake over OneLake to Direct Lake over SQL endpoint by using sempy_labs.directlake.update_direct_lake_model_connection ; from this semantic link labs method you have to set the parameter "use_sql_endpoint=True" . When done, "Data Source rule" in your deployment pipeline stage will show up for edit
- rabbyn and wardy912, you are a lifesaver! See https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.directlake.html for more details on using using sempy_labs.directlake.update_direct_lake_model_connection.
christianunrHelper I
mjc-fabric You could at least link to the direct section: https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.directlake.html#sempy_labs.directlake.update_direct_lake_model_connection- mrozzano
Microsoft touts the benefits of creating Direct Lake on OneLake semantic models, but what's the point if we can't easily use deployment rules ?
This isn't a request for a new feature. This is a request to fix a broken feature.
Unfortunately, in my organization, using sempy labs isn't an option (unless Microsoft makes sempy labs available in the defeault workspace notebook environment).
- wardy912Hi mrozzano This video should help for now, until this is fixed by Microsoft. https://youtu.be/u-cVqWlVgUc?si=aUoMTu_-PDkFXGet
- dom99
Advocate V
Not sure how Microsoft expect anyone to use this with it being almost impossible to change the data source. Please provide a way to do it, ideally deployment rules or variable libraries, or even manually! Problem is its almost impossible to use at the moment.
