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.
20 Comments
The docs now show an alternative to data source rules by updating the semantic model with M Parameters and using Parameter Rules:
This should be helpful for most of the cases.
- PeterDaniels
Advocate III
Would love to see this get fixed. Really would be helpful to have an autobinding solution, but i would be happy with a deployment rule or variable library solution. When can we expect resolution?
- ruiafonsecaNew Member
The lack of native deployment rules for Direct Lake on OneLake semantic models significantly impacts CI/CD processes and currently requires custom post-deployment workarounds.
Is there any update on when Microsoft plans to address this issue? - FernandoRotertNew Member
I'm amazed at how long it's been since the launch of Direct Lake connections and the identification of this bug, yet Microsoft still hasn't been able to fix it. This isn't a new feature; it's a fix for something that works for various sources but no longer works for Direct Lake connections (this one encouraged by Microsoft!). I hope to see this bug fixed soon. Most of the available workarounds aren't ideal yet.
- sswAERNew MemberAbsolutely wild that this is still not possible! Please get us a fix so that we can enable more business user led scenarios. Have resorted to using Azure DevOps and fabric-cicd, which isn't that difficult, but forces ownership upstream and limits broader adoption.
- lis12345New MemberI also achieved that using terraform https://registry.terraform.io/providers/microsoft/fabric/latest/docs/resources/semantic_model natively without any issues.
- dom99
Advocate V
We had to implement a deployment pipeline from azure devops, using the python cicd library (now fully supported by microsoft). To change the data sources on release we used a powershell script to do a string replace on the expressions.tmdl file and any other sources in the tables folder. This actually works and doesnt come with any limitations (unlike the parameters method). I believe this is the only way to deploy direct lake on onelake models.
I had about 5 phone calls and an email chain about 30 messages back and forth with microsoft support. It took a number of attempts them to to understand what I was even talking about. In the end the conclusion was they didnt have any solution, and anythign suggested by them was just pointing to blog posts already linked to here, so I wouldnt recommend trying to get support for this.Feel free to ask questions on how we managed to achieve a working pipeline. When I first began it seemed like a minefield and lots of unclear information on what to do.
- tsunloan
Helper I
This is a Bug pure and simple, not a feature gap. It's noting short of complete and utter incompetence that MS continue to release these features in completely unusable states and announce them as wins. Product and engineering both need to do better. - rabbynFrequent Visitora colleague of mine shared this link with me as an other type of workaround to implement : https://www.datazoe.blog/post/deployment-pipelines-and-power-bi-semantic-models-with-direct-lake-on-onelake-tables The blog describes a limitation/bug in Power BI semantic models using Direct Lake on OneLake when combined with Deployment Pipelines. The core problem When using Direct Lake on OneLake tables in a semantic model, you can use Deployment Pipeline rules… …but the connector does NOT support data source bindings (unlike Direct Lake on SQL). The workaround is to use parameter rules, but this introduces a bug: ❗ Bug in Power BI Desktop Parameters cannot be configured in the TMDL view of Power BI Desktop After setting a parameter: Live Edit in Power BI Desktop breaks Edit Table in web modeling is disabled You get an error when trying to edit the semantic model So once a parameter is used to externalize the OneLake URI, Power BI Desktop becomes unusable for editing that model. 🔧 Solution Proposed in the Blog Since Power BI Desktop cannot handle parameterized Direct Lake connections (due to the bug), the workaround is to edit the semantic model using external tools. ✔ Recommended workaround Use VS Code + Fabric Studio extension to manually modify the model's TMDL expression file (expressions.tmdl). Result: You regain the ability to change the data source per stage in a Deployment Pipeline — even though Power BI Desktop cannot handle this scenario.
- 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 without using horrible hacky workarounds with source control.
Recent ideas
Dynamic Batch Count in Data Factory Pipelines (FOREACH ACTIVITY)
Currently, in Data Factory, the ForEach activity requires a static batch count when executing in parallel mode. However, this fixed value does not always align with dynamic workloads, leading to inef...raym851 hour agoAdvocate INew1.4KViews10likes2CommentsDeployment Pipelines: preserve/override schedules per environment (no overwrite on deploy)
When deploying from Dev/Non-Prod to Prod, the target’s pipeline schedule is overwritten. Please add deployment rules (or an opt-out) so schedules can be environment-specific without showing as drift ...JP89914 hours agoKudo CommanderUnder Review4KViews66likes22CommentsSupport Power BI connection with Salesforce community URL
Before Salesforce changed customer links to my.site.com our customers were able to connect salesforce with power bi and use their own logins in Power BI and maintain the security from Salesforce. No...gilmore_staci9 hours agoHelper IIINew4Views0likes0CommentsShow all email recipients when sending subscription
When a subscription is sent out, the recipients can only see themselves and not everyone who received that subscription. We would like the subscription to show everyone who received that subscription...jhawkfan9 hours agoNew MemberNew4Views0likes0CommentsMake workspace and item session persistence optional
Description The new persistent session behavior in Microsoft Fabric should be optional rather than forced. Currently, Fabric remembers the workspaces and items that were open in my previous session...TeemuMultanen9 hours agoAdvocate IVNew429Views72likes4Comments