CONTENT: We’ve started building our core lakehouse and semantic models directly within the Microsoft Fabric web interface to leverage Direct Lake performance. However, my team is finding the web modeling experience a bit restrictive for complex DAX and advanced properties. Is there a way to "check out" or open a Fabric-hosted semantic model in Power BI Desktop to continue development locally, or are we locked into the web editor once we start there?
DATE: 14-10-2024
Meta title: Edit Microsoft Fabric Semantic Models in Power BI Desktop
Meta Description: Learn how to use Power BI Desktop to live edit Microsoft Fabric semantic models, enabling advanced DAX and Direct Lake management for your data team.
Meta keywords: Microsoft Fabric, Power BI Desktop, Direct Lake Mode, Semantic Model, Web Modeling
TYPE: Cloud Technology
VISIT: 12104
POSTED BY: Jessica Martinez
3 answers
Yes, you can absolutely do this using the "Live Edit" feature. In Power BI Desktop, instead of "Getting Data," you use the OneLake Data Hub to find your Fabric semantic model. When you connect, you should see an option to "Edit" the model if you have the proper workspace permissions. This doesn't download a local copy of the data; instead, Power BI Desktop acts as a professional UI for the model sitting in Fabric. This allows you to write complex DAX, manage perspectives, and set advanced properties that aren't yet available in the web-based "Open Data Model" experience. Any changes you save in Desktop are pushed back to the Fabric service immediately.
This works for most things, but what happens if I need to add a local Excel file or a different SQL source to that Fabric model while I'm in Desktop? Does it let me transform it into a composite model, or does it stay strictly tied to the OneLake sources
The best part is using External Tools like Tabular Editor while the model is open in Desktop. It gives you enterprise-grade control over a Fabric model that you just can't get in a browser.
I couldn't agree more, Jessica. Using Tabular Editor 3 via Power BI Desktop to edit a Fabric Direct Lake model is the "gold standard" workflow right now. Just make sure your XMLA Read/Write settings are enabled in the Fabric Capacity admin portal, or you'll get a permissions error when trying to save those metadata changes back to the cloud.
That's where it gets a bit tricky, Mark. If your Fabric model is in Direct Lake mode, it's designed to be a "pure" lakehouse model. If you try to add a local file in Desktop, it will prompt you to switch to a DirectQuery connection to the semantic model, creating a Composite Model (Live Connection + Local Import). This is powerful, but be careful: adding local data might cause certain visuals to "fall back" from the lightning-fast Direct Lake speed to standard DirectQuery if the relationships aren't optimized. I usually recommend keeping the "Core" model in Fabric and only using Desktop for the heavy DAX lifting.