--- title: Power BI Direct Lake: A Critical Look at Its Semantic Layer Potential --- # Power BI Direct Lake: A Critical Look at Its Semantic Layer Potential Last Reviewed: March 18, 2026 5 min read [No comments](https://www.selecthub.com/business-intelligence/power-bi-direct-lake/#respond) [ ![Ritinder Kaur](https://www.selecthub.com/wp-content/uploads/2021/06/cropped-Ritinder-Kaur-v2-1-96x96.png) ](https://www.selecthub.com/author/ritinder-kaur/) [Written by Ritinder Kaur](https://www.selecthub.com/author/ritinder-kaur/) Sr. Technical Content Writer [ ![Hunter Lowe](https://www.selecthub.com/wp-content/uploads/2023/11/cropped-Hunter-Headshot-96x96.jpg) ](https://www.selecthub.com/author/hunter-lowe/) [Edited by Hunter Lowe](https://www.selecthub.com/author/hunter-lowe/) Content Editor Table of Contents * [Performance Concerns With Power BI/Direct Lake](#Performance%5FConcerns%5FWith%5FPower%5FBIDirect%5FLake "Performance Concerns With Power BI/Direct Lake") * [Query Failures](#Query%5FFailures "Query Failures") * [Lazy Loading + Fallback to Direct Query = Performance Lag](#Lazy%5FLoading%5FFallback%5Fto%5FDirect%5FQuery%5FPerformance%5FLag "Lazy Loading + Fallback to Direct Query = Performance Lag") * [Fabric Lakehouse Limitations](#Fabric%5FLakehouse%5FLimitations "Fabric Lakehouse Limitations") * [Microsoft Support for Semantic Layer Technologies](#Microsoft%5FSupport%5Ffor%5FSemantic%5FLayer%5FTechnologies "Microsoft Support for Semantic Layer Technologies") * [Semantic Model Scale-Out](#Semantic%5FModel%5FScale-Out "Semantic Model Scale-Out") * [Cost Considerations](#Cost%5FConsiderations "Cost Considerations") * [Alternatives](#Alternatives "Alternatives") * [Conclusion](#Conclusion "Conclusion") Direct Lake in Microsoft Fabric is a query technology that lets [Power BI](https://www.selecthub.com/p/business-intelligence-tools/power-bi/) users create semantic data models from OneLake. It’s a step up from Direct Query and Import Mode and intends to remedy their limitations. This article takes a closer look at how it fares in supporting Power BI to be more agile and efficient, especially in light of the [AtScale TPC-DS Benchmark Report](https://www.atscale.com/resource/performance-benchmark-powerbi-directlake-snowflake/). [Compare BI Software Leaders](https://pmo.selecthub.com/bi-software-analyst-report-site-vers/) ## Performance Concerns With Power BI/Direct Lake The Import Mode in Power BI is storage and resource-intensive, requiring frequent data refreshes. Direct Query, though live, is constrained by the source systems’ response time. ![Power BI Direct Lake Architecture]() The Power BI/Direct Lake architecture. [Source](https://learn.microsoft.com/en-us/fabric/get-started/direct-lake-overview) Direct Lake intends to address these issues by bypassing the warehouse/lakehouse tier and querying OneLake directly. Does it deliver? ### Query Failures During the AtScale tests, Power BI/Direct Lake returned queries in around 500 milliseconds for a 100GB data size. That was reasonably fast. However, it encountered performance bottlenecks as volumes increased beyond 1 TB and queries started timing out. Moreover, Power BI fell back to DirectQuery mode to keep queries from failing, bringing back related performance issues. ### Lazy Loading + Fallback to Direct Query = Performance Lag As per the AtScale test results, refreshing Power BI models slowed performance, with a [cold cache](https://www.oreilly.com/library/view/intelligent-caching/9781492049067/ch03.html) effect kicking in. Unlike a warm cache that stores frequently queried data separately, a cold cache treats all data the same, so the system has to work harder to find it. A semantic model refresh on top of this can exacerbate performance issues. Semantic models need space to store information about data structure, dataset associations and their multiple representations. They often double in size when refreshed because Power BI/Direct Lake creates an exact copy, increasing storage and memory pressure that can indirectly impact [effective data presentation](https://slidemodel.com/data-presentation/). When the data exceeded memory in the tests, the solution reverted to Direct Query mode. ### Fabric Lakehouse Limitations Fabric relies on Power BI on the web for data modeling, but this coupling isn’t without its considerations. The web version of Power BI doesn’t do calculated columns since [DAX](https://learn.microsoft.com/en-us/dax/) support is unavailable. Building models in Power BI Desktop isn’t an option as there’s no way to share them with the web version. The AtScale team had to exclude certain tests as they encountered modeling issues with the Semantic Model web editor. Though query results improved somewhat when switching to a higher capacity configuration, the fallback behavior persisted. [Compare BI Software Leaders](https://pmo.selecthub.com/bi-software-analyst-report-site-vers/) ## Microsoft Support for Semantic Layer Technologies Microsoft provides several workarounds to cater to large data sizes — a semantic model scale-out, autoscale and the large semantic model storage format setting. ### Semantic Model Scale-Out As discussed above, Power BI memory gets stretched when a semantic layer refreshes because it creates a replica. Harnessing this technology, the vendor provides one read-write and multiple read-only semantic model replicas. Every time the combined CPU usage of all active read-only replicas exceeds capacity, a new replica is created to share the load. A single read-write replica might circumvent data duplication during write-back, but it can be limiting. When query overload happens, throttling is applied which might cause latency and reduced throughput. **Autoscale** While autoscaling sounds like a viable solution for handling data surges, it comes with its own set of considerations in the context of Power BI and Direct Lake. When data exceeds memory, the solution can add one vCore every 24 hours at $85 per hour. If autoscale triggers frequently, you’re looking at a significant cost center and might have to shell out a tidy sum for a higher SKU. Plus, performance may dip briefly as the system adjusts to the new vCore. And the 24-hour window before adding another core might be too long for highly dynamic workloads. As an alternative, pre-aggregating data might improve query response times, but Power BI doesn’t do that. **Large semantic model storage format** Data compression in Power BI is an effective technique to reduce the semantic model volume. Efficient memory management drives accelerated responses. However, this feature isn’t available with the Pro license. Plus, the model size in Premium is limited to 100 GB and downloading a semantic model to a .pbix file format can be tricky. [Compare BI Software Leaders](https://pmo.selecthub.com/bi-software-analyst-report-site-vers/) ## Cost Considerations Microsoft has priced Fabric at par with the [Power BI Premium](https://www.selecthub.com/business-intelligence/power-bi-pro-vs-premium/) capacity model. You’re charged for the allocated CPU, memory and storage. However, you’ll have to shell out extra for OneLake storage costs, and frequent data-intensive workloads can burn a hole in your pocket. While Fabric offers dashboards for monitoring usage and costs, per-user metrics might not be available, hindering smaller teams looking to save every dime. As the platform is still under development, guesstimates might be your best bet while planning a long-term investment in Microsoft Fabric. ## Alternatives The maturity of the Power BI/Direct Lake-Fabric universe is a consideration for some users. On the other hand, vendors like AtScale and Kyvos offer mature semantic layers that can scale to handle thousands of users while maintaining sub-second query responses. They can process terabytes of data and unlimited model sizes, thanks to disk storage. AtScale creates materialized views in the source system and allocates storage to the aggregate tables while making it available to users. With an advanced [OLAP](https://www.ibm.com/topics/olap) engine, Kyvos handles unbalanced and ragged hierarchies. When entities don’t go down to the required level of detail or skip a level, it transforms them into a consistent format. Plus, it supports MDX functions for calculated measures out of the box. Kyvos offers dedicated connectors for Power BI, [Tableau,](https://www.selecthub.com/p/business-intelligence-tools/tableau/) [MicroStrategy](https://www.selecthub.com/p/business-intelligence-tools/microstrategy/) and many other [BI tools](https://www.selecthub.com/c/business-intelligence-tools/). Incremental refreshes every few minutes keep data up to date, and the platform can accommodate millions of rows in a single request. Intelligent data aggregation supports sub-second queries on billions of rows without performance degradation. [Compare BI Software Leaders](https://pmo.selecthub.com/bi-software-analyst-report-site-vers/) ## Conclusion In its current avatar, Power BI/Direct Lake offers advantages for users within the Microsoft ecosystem and queries on smaller to medium-sized datasets. It will be interesting to see how it evolves in the coming years. However, established semantic layer solutions might be better suited for handling extremely large data volumes or for functionalities not yet available in Power BI/Direct Lake. ### Trending Topics #### [Business Intelligence](https://www.selecthub.com/category/business-intelligence/) [The 5 Best Statistical Software Tools of 2026](https://www.selecthub.com/business-intelligence/statistical-software/) [Wouldn’t you jump at the chance to get things done faster? Using sample data for… ](https://www.selecthub.com/business-intelligence/statistical-software/) [ ![Ritinder Kaur](https://www.selecthub.com/wp-content/uploads/2021/06/cropped-Ritinder-Kaur-v2-1-96x96.png) Ritinder Kaur ](https://www.selecthub.com/author/ritinder-kaur/) Mar 31, 2026 #### [Business Intelligence](https://www.selecthub.com/category/business-intelligence/) [Tableau Competitors: Comparing the Best Business Intelligence Tools](https://www.selecthub.com/business-intelligence/tableau-competitors/) [Tableau is a universal favorite as a BI tool, but it’s expensive. Right now, you’re… ](https://www.selecthub.com/business-intelligence/tableau-competitors/) [ ![Ritinder Kaur](https://www.selecthub.com/wp-content/uploads/2021/06/cropped-Ritinder-Kaur-v2-1-96x96.png) Ritinder Kaur ](https://www.selecthub.com/author/ritinder-kaur/) Mar 27, 2026 #### [Business Intelligence](https://www.selecthub.com/category/business-intelligence/) [Descriptive vs Predictive vs Prescriptive vs Diagnostic Analytics](https://www.selecthub.com/business-intelligence/predictive-descriptive-prescriptive-analytics/) [In 2004, when Hurricane Frances hit Florida’s Atlantic coast, people were ready…with six packs of… ](https://www.selecthub.com/business-intelligence/predictive-descriptive-prescriptive-analytics/) [ ![Ritinder Kaur](https://www.selecthub.com/wp-content/uploads/2021/06/cropped-Ritinder-Kaur-v2-1-96x96.png) Ritinder Kaur ](https://www.selecthub.com/author/ritinder-kaur/) Mar 18, 2026 #### [Business Intelligence](https://www.selecthub.com/category/business-intelligence/) [4 Top Business Intelligence Applications in 2026](https://www.selecthub.com/business-intelligence/4-key-bi-applications/) [Have you ever wished you could get a glimpse into the inner workings of your… ](https://www.selecthub.com/business-intelligence/4-key-bi-applications/) [ ![Bergen Adair](https://secure.gravatar.com/avatar/b9985f5202fbae2efa5a566d409354bbe99c18f8fd579991494c86a2c184dc2b?s=96&d=mm&r=g) Bergen Adair ](https://www.selecthub.com/author/bergen/) Mar 18, 2026 #### [Business Intelligence](https://www.selecthub.com/category/business-intelligence/) [The Top 10 Business Intelligence Requirements Template & Checklist](https://www.selecthub.com/business-intelligence/top-business-intelligence-requirements/) [Sam from accounting wants handy dashboards, while the CFO says, “Just give me the numbers,… ](https://www.selecthub.com/business-intelligence/top-business-intelligence-requirements/) [ ![Ritinder Kaur](https://www.selecthub.com/wp-content/uploads/2021/06/cropped-Ritinder-Kaur-v2-1-96x96.png) Ritinder Kaur ](https://www.selecthub.com/author/ritinder-kaur/) Mar 18, 2026 #### [Business Intelligence](https://www.selecthub.com/category/business-intelligence/) [The Best Business Intelligence Systems and the Different Types](https://www.selecthub.com/business-intelligence/key-types-business-intelligence-tools/) [Data, data, data … that’s all we’re hearing about nowadays. Big Data, data mining, data… ](https://www.selecthub.com/business-intelligence/key-types-business-intelligence-tools/) [ ![Bergen Adair](https://secure.gravatar.com/avatar/b9985f5202fbae2efa5a566d409354bbe99c18f8fd579991494c86a2c184dc2b?s=96&d=mm&r=g) Bergen Adair ](https://www.selecthub.com/author/bergen/) Mar 18, 2026 Originally published in September 2024 and last updated in March 2026\. Contributions from Ritinder Kaur, and Hunter Lowe. ## About the Contributors The following team members helped research, create, and review this content. [ ](https://www.selecthub.com/author/ritinder-kaur/) Written by [Ritinder Kaur](https://www.selecthub.com/author/ritinder-kaur/) Sr. Technical Content Writer Ritinder Kaur is a Senior Technical Content Writer at SelectHub and has ten years of experience writing about B2B software and quality assurance. She has a Masters degree in English language and literature and writes about Business Intelligence and Data Science. Her articles on software testing have been published on Stickyminds. [See Full Bio](https://www.selecthub.com/author/ritinder-kaur/) [ ](https://www.selecthub.com/author/hunter-lowe/) Edited by [Hunter Lowe](https://www.selecthub.com/author/hunter-lowe/) Content Editor Hunter Lowe is a Content Editor, Writer and Market Analyst at SelectHub. His team covers categories that range from ERP and business intelligence to transportation and supply chain management. Hunter is an avid reader and Dungeons and Dragons addict who studied English and Creative Writing through college. In his free time, you'll likely find him devising new dungeons for his players to explore, checking out the latest video games, writing his next horror story or running around with his daughter. [See Full Bio](https://www.selecthub.com/author/hunter-lowe/) Bergen AdairThe Best Business Intelligence Systems and the Different Types * ‹ * › ### Conversation ![Avatar](https://secure.gravatar.com/avatar/281d3616cf761f3582c0d76c23517846?s=32&d=mm&r=g) Write a response [Cancel reply](https://www.selecthub.com/business-intelligence/power-bi-direct-lake/#respond) Your message Your name \* Your email \* Website Save my name, email, and website in this browser for the next time I comment. Δ **Tier 1:** Fully/moderately supported out-of-the-box allowing for quick and easy deployment. Fully or moderately supported out-of-the-box with industry-leading capabilities and is immediately available after installation without needing any add-ons, integrations, or custom development. **Tier 2:** Supported with workarounds or add-ons that may require additional costs. Not directly available in the software, but can be accomplished using other built-in features, workarounds, or add-ons/products from the vendor with or without any additional cost. **Tier 3:** Requires partner integrations or custom development that is often at an additional cost. Requires additional integrations, plugins, marketplace applications from a third-party vendor, or custom development using the APIs, libraries, extensions, and development framework supported by the software, with or without any additional cost. [Close](#) ```json {"@context":"https://schema.org","@graph":[{"@type":"Article","@id":"https://www.selecthub.com/business-intelligence/power-bi-direct-lake/#article","isPartOf":{"@id":"https://www.selecthub.com/business-intelligence/power-bi-direct-lake/"},"author":{"name":"Ritinder Kaur","@id":"https://www.selecthub.com/#/schema/person/5ebc99a78bf29f315438d2b22a16f178"},"headline":"Power BI Direct Lake: A Critical Look at Its Semantic Layer Potential","datePublished":"2024-09-25T10:00:07+00:00","dateModified":"2026-03-18T20:31:19+00:00","mainEntityOfPage":{"@id":"https://www.selecthub.com/business-intelligence/power-bi-direct-lake/"},"wordCount":1074,"commentCount":0,"publisher":{"@id":"https://www.selecthub.com/#organization"},"articleSection":["Business Intelligence"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https://www.selecthub.com/business-intelligence/power-bi-direct-lake/#respond"]}]},{"@type":"WebPage","@id":"https://www.selecthub.com/business-intelligence/power-bi-direct-lake/","url":"https://www.selecthub.com/business-intelligence/power-bi-direct-lake/","name":"Semantic Layers in Power BI Direct Lake - Performance Breakdown","isPartOf":{"@id":"https://www.selecthub.com/#website"},"datePublished":"2024-09-25T10:00:07+00:00","dateModified":"2026-03-18T20:31:19+00:00","breadcrumb":{"@id":"https://www.selecthub.com/business-intelligence/power-bi-direct-lake/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https://www.selecthub.com/business-intelligence/power-bi-direct-lake/"]}]},{"@type":"BreadcrumbList","@id":"https://www.selecthub.com/business-intelligence/power-bi-direct-lake/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://www.selecthub.com/"},{"@type":"ListItem","position":2,"name":"Business Intelligence","item":"https://www.selecthub.com/category/business-intelligence/"},{"@type":"ListItem","position":3,"name":"Power BI Direct Lake: A Critical Look at Its Semantic Layer Potential"}]},{"@type":"WebSite","@id":"https://www.selecthub.com/#website","url":"https://www.selecthub.com/","name":"SelectHub","description":"Confidence in Software","publisher":{"@id":"https://www.selecthub.com/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://www.selecthub.com/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https://www.selecthub.com/#organization","name":"SelectHub","url":"https://www.selecthub.com/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https://www.selecthub.com/#/schema/logo/image/","url":"","contentUrl":"","caption":"SelectHub"},"image":{"@id":"https://www.selecthub.com/#/schema/logo/image/"},"sameAs":["https://www.facebook.com/selecthub/","https://x.com/SelectHub","https://www.linkedin.com/company/selecthub"]},{"@type":"Person","@id":"https://www.selecthub.com/#/schema/person/5ebc99a78bf29f315438d2b22a16f178","name":"Ritinder Kaur","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https://www.selecthub.com/#/schema/person/image/","url":"https://www.selecthub.com/wp-content/uploads/2021/06/cropped-Ritinder-Kaur-v2-1-96x96.png","contentUrl":"https://www.selecthub.com/wp-content/uploads/2021/06/cropped-Ritinder-Kaur-v2-1-96x96.png","caption":"Ritinder Kaur"},"description":"Ritinder Kaur is a Senior Technical Content Writer at SelectHub and has ten years of experience writing about B2B software and quality assurance. She has a Masters degree in English language and literature and writes about Business Intelligence and Data Science. Her articles on software testing have been published on Stickyminds.","sameAs":["https://www.selecthub.com","https://www.linkedin.com/in/ritinder-kaur/"],"url":"https://www.selecthub.com/author/ritinder-kaur/"}]} { "@context": "https://schema.org", "@type": "Article", "headline": "Power BI Direct Lake: A Critical Look at Its Semantic Layer Potential", "author":{ "@type": "Person", "name": "Ritinder Kaur", "url": "https://www.selecthub.com/author/ritinder-kaur/", "jobTitle":"Sr. Technical Content Writer", "image": "https://www.selecthub.com/wp-content/uploads/2021/06/cropped-Ritinder-Kaur-v2-1-96x96.png" }, "publisher":{ "@type": "Organization", "name": "SelectHub", "logo": { "@type":"ImageObject", "url": "https://www.selecthub.com/wp-content/uploads/2019/10/favicon.png" } }, "datePublished": "2024-09-25T04:00:07-06:00", "dateModified": "2026-03-18T14:31:19-06:00", "mainEntityOfPage": "https://www.selecthub.com/business-intelligence/power-bi-direct-lake/" } ```