Deployment 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.
17 Comments
- jhills
Advocate II
Definitely a must have feature to make deployment pipelines usable for Direct Lake on OneLake semantic models. - jkers55
Advocate 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. - rabbynFrequent Visitor
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
- mjc-fabricFrequent Visitorrabbyn 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.
- christianunr
Helper 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
Advocate I
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).
- wardy912
Super User
Hi 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.
Recent ideas
Auto-propagate Lakehouse (Direct Lake) permissions to users assigned to a Power BI App audience
Problem When a Power BI report uses a Live Connection to a Direct Lake Semantic Model, end users must have explicit ReadAll / ReadData permissions on the underlying Lakehouse (or its SQL analytics e...majofv6 minutes agoNew MemberNew1View0likes0CommentsVisual Type Defaults in Visualization Pane
This would change my life with fussy clients and client/public facing apps. In addition, it would allow me to add more value to the clients on retainers who do not have the 'hours' to allocate to...IolaWhiteley25 minutes agoAdvocate IINew75Views7likes1CommentAdd a Close or “Return to previous page” button to Semantic Model Security and Settings pages
When updating RLS group assignments through Semantic model > Security, there is no consistent in-product Close or Done button that returns the user to the previous workspace view. The browser Back b...Kalaiselvan2 hours agoFrequent VisitorNew2Views0likes0Comments