{"id":2662,"date":"2026-08-05T10:57:16","date_gmt":"2026-08-05T00:57:16","guid":{"rendered":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?p=2662"},"modified":"2026-08-05T17:19:36","modified_gmt":"2026-08-05T07:19:36","slug":"microsoft-fabric-features-guide","status":"publish","type":"post","link":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide","title":{"rendered":"Microsoft Fabric Features Explained: A 2026 Guide for Data Teams"},"content":{"rendered":"\n<p class=\"has-normal-font-size wp-block-paragraph\">Microsoft Fabric is a unified software as a service (SaaS) analytics platform that brings data engineering, data warehousing, data integration, real-time analytics, data science and Power BI into one governed environment. Every workload writes to OneLake, a single logical data lake in open Delta Lake format, so one copy of data serves every engine instead of each tool keeping its own.<\/p>\n\n\n\n<!--more-->\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-dominant-color=\"27474f\" data-has-transparency=\"false\" style=\"--dominant-color: #27474f;\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"538\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/microsoft-fabric-architecture-overview-1024x538.webp\" alt=\"Microsoft Fabric workflow: data sources feed Data Factory into OneLake, then Lakehouse, Warehouse and Eventhouse engines serve Power BI.\" class=\"wp-image-2663 not-transparent\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/microsoft-fabric-architecture-overview-1024x538.webp 1024w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/microsoft-fabric-architecture-overview-300x158.webp 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/microsoft-fabric-architecture-overview-1536x806.webp 1536w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/microsoft-fabric-architecture-overview-2048x1075.webp 2048w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/microsoft-fabric-architecture-overview-1200x630.webp 1200w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/microsoft-fabric-architecture-overview-1980x1040.webp 1980w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Fabric consolidates capabilities that previously required Azure Data Factory, Azure Synapse Analytics, Azure Data Explorer and Power BI Premium to be bought and wired together separately. You buy one capacity and every workload draws from that pool.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">This guide covers each major feature: what it is, why it matters, and where it falls short. The trade-offs are included because the decision to move onto Fabric is rarely a question of whether the features exist. It is a question of whether the gaps matter for your workloads.<\/p>\n\n\n\n<h2 id=\"h-key-facts-at-a-glance\" class=\"wp-block-heading has-h-4-font-size\">Key facts at a glance<\/h2>\n\n\n\n<figure class=\"wp-block-table has-small-font-size is-style-regular\"><table class=\"has-background has-fixed-layout\" style=\"background-color:#ffffff\"><thead><tr><th>Item<\/th><th>Detail<\/th><\/tr><\/thead><tbody><tr><td><strong>Product<\/strong><\/td><td>Microsoft Fabric<\/td><\/tr><tr><td><strong>Category<\/strong><\/td><td>Unified SaaS data and analytics platform<\/td><\/tr><tr><td><strong>Storage layer<\/strong><\/td><td>OneLake, one logical lake per tenant<\/td><\/tr><tr><td><strong>Native table format<\/strong><\/td><td>Delta Lake, with transparent Apache Iceberg interoperability<\/td><\/tr><tr><td><strong>Core workloads<\/strong><\/td><td>Data Factory, Data Engineering, Data Warehouse, Data Science, Real-Time Intelligence, Databases, Fabric IQ, Power BI<\/td><\/tr><tr><td><strong>Licensing model<\/strong><\/td><td>Capacity based. Capacities are named F plus their capacity units, from F2 to F2048, bought pay as you go or reserved<\/td><\/tr><tr><td><strong>Minimum capacity for Copilot<\/strong><\/td><td>F2, the smallest paid tier. Trial and free SKUs are not supported<\/td><\/tr><tr><td><strong>Identity and governance<\/strong><\/td><td>Microsoft Entra ID, Microsoft Purview Information Protection, OneLake security roles<\/td><\/tr><tr><td><strong>Typical users<\/strong><\/td><td>Data engineers, BI developers, data analysts, data scientists<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 id=\"h-what-is-microsoft-fabric\" class=\"wp-block-heading has-h-4-font-size\">What is Microsoft Fabric?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><a href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-fabric\">Microsoft Fabric<\/a> is Microsoft&#8217;s unified SaaS analytics platform. It removes the need to assemble separate services for ingestion, storage, transformation, warehousing, streaming and reporting by putting all of them behind one portal, one capacity and one storage layer.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">The organising units are workspaces and items. A workspace is assigned to a capacity and holds items: lakehouses, warehouses, notebooks, pipelines, eventhouses, semantic models and reports. Because every item stores its data in OneLake, moving between engines does not mean moving data.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">The commercial model is worth understanding before the technical one. Fabric is billed on capacity rather than per seat. Capacities are named F followed by the number of capacity units they provide, so the range runs F2, F4, F8, F16, F32, F64 and upwards to F2048. You assign workspaces to a capacity, and every workload in those workspaces draws from that same pool. The older P-series Premium capacities (P1, P2 and P3) still function, but Microsoft is retiring them and directing customers to the F-series.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-table has-small-font-size\"><table class=\"has-background has-fixed-layout\" style=\"background-color:#ffffff\"><thead><tr><th>Tier<\/th><th>Capacity units<\/th><th>Why it matters<\/th><\/tr><\/thead><tbody><tr><td>F2<\/td><td>2<\/td><td>Smallest paid tier, and the minimum capacity for Copilot<\/td><\/tr><tr><td>F4 to F32<\/td><td>4 to 32<\/td><td>Typical range for small and mid-sized workloads<\/td><\/tr><tr><td>F64<\/td><td>64<\/td><td>Report viewers holding a free Fabric licence no longer need a Power BI Pro licence. Broadly equivalent to the legacy P1 capacity<\/td><\/tr><tr><td>F128 to F2048<\/td><td>128 to 2048<\/td><td>Large enterprise workloads<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">That F64 threshold is where most costing exercises land. Below it, every person who opens a report needs a Power BI Pro licence. At F64 and above, viewers with the Viewer role and a free Fabric licence do not, although report authors still need Pro either way.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Capacity is shared across every workload in the tenant that is assigned to it, which means a badly written notebook can slow a report refresh. This is a change in operational discipline for teams used to isolated services.<\/p>\n\n\n\n<h2 id=\"h-what-is-onelake-and-why-does-it-matter\" class=\"wp-block-heading has-h-4-font-size\">What is OneLake and why does it matter?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><a href=\"https:\/\/learn.microsoft.com\/en-us\/fabric\/onelake\/onelake-overview\">OneLake<\/a> is Fabric&#8217;s single, tenant-wide logical data lake. Every Fabric workload reads and writes to it in open format, which means one copy of data can serve SQL, Spark, KQL and Power BI without duplication, conversion or a separate copy step.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Data reaches OneLake three ways. You can load it directly through pipelines, notebooks or dataflows. You can create a shortcut, which is a zero-copy reference to data held elsewhere: another OneLake location, Azure Data Lake Storage Gen2, Amazon S3, Google Cloud Storage, or on-premises storage through the data gateway. Or you can mirror an operational database, which keeps a near real-time replica of Azure SQL, PostgreSQL, Cosmos DB or Snowflake in OneLake without you building a pipeline.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><a href=\"https:\/\/delta.io\/\">Delta Lake<\/a>, a Linux Foundation project, is the default table format, and OneLake now serves those same Delta tables transparently as <a href=\"https:\/\/iceberg.apache.org\/docs\/latest\/\">Apache Iceberg<\/a>, with an Iceberg REST Catalog endpoint that external engines such as Snowflake, Trino and Dremio can connect to. Snowflake interoperability is generally available, and Azure Databricks can read OneLake data through Unity Catalog. The practical effect is that choosing Fabric for storage does not force you to choose Fabric for every engine.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Governance is the underrated part. Permissions, sensitivity labels and lineage are held at the storage layer, so a rule written once applies whether the user arrives through a SQL endpoint, a Spark notebook or a Power BI report. In a multi-tool estate, that is usually where governance breaks down.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><strong>Strengths<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li>One source of truth, with no copy sprawl between engineering and BI<\/li>\n\n\n\n<li>Governance applied at the storage layer and enforced across every engine<\/li>\n\n\n\n<li>Open formats, so data is portable if you later move compute elsewhere<\/li>\n\n\n\n<li>Zero-copy access to external cloud storage and on-premises data through shortcuts<\/li>\n<\/ul>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><strong>Watch-outs<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li>Every workload draws on the same capacity, so sizing has to account for all of them at once rather than workload by workload<\/li>\n\n\n\n<li>Tables are expected in Delta or Iceberg. Loose Parquet and CSV need converting or accessing through a shortcut<\/li>\n\n\n\n<li>Some external tools need extra configuration to connect, although OneLake does support the ADLS Gen2 API and SDKs<\/li>\n\n\n\n<li>Tenant-wide storage means tenant-wide blast radius if workspace permissions are set carelessly<\/li>\n<\/ul>\n\n\n\n<h2 id=\"h-what-is-a-fabric-lakehouse\" class=\"wp-block-heading has-h-4-font-size\">What is a Fabric lakehouse?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A lakehouse in Fabric is an item in OneLake that combines data lake storage with warehouse-style querying. It holds structured and unstructured data in one place using Delta Lake, and automatically exposes both a Spark endpoint and a read-only SQL analytics endpoint over the same underlying files.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Data engineers ingest and transform with Spark notebooks, pipelines or Dataflow Gen2. Analysts then query the result with T-SQL through the SQL analytics endpoint, or build a Power BI semantic model on it, without anyone creating a second copy. The Delta format underneath provides atomicity, consistency, isolation and durability (ACID) transactions, schema enforcement and time travel, which is what makes warehouse-style behaviour possible on lake storage.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The lakehouse removes the old trade-off between lakes and warehouses. Instead of one copy for machine learning and another for reporting, a single Delta copy serves both.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The term is not a Microsoft coinage. It was set out in a <a href=\"https:\/\/people.eecs.berkeley.edu\/~matei\/papers\/2021\/cidr_lakehouse.pdf\">2021 CIDR paper<\/a> arguing that open, direct-access formats would eventually replace the two-tier lake-plus-warehouse architecture. Fabric is one of the more complete commercial implementations of that argument, which is worth knowing if you are comparing it against Databricks or Snowflake rather than against your current stack.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><strong>Strengths<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li>One Delta copy serves Spark, SQL and Power BI<\/li>\n\n\n\n<li>Handles structured, semi-structured and unstructured data in the same item<\/li>\n\n\n\n<li>Low storage cost relative to a dedicated warehouse<\/li>\n\n\n\n<li>Direct Lake semantic models can read the tables without an import refresh<\/li>\n<\/ul>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><strong>Watch-outs<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li>The SQL analytics endpoint is read-only. Writes go through Spark, pipelines or dataflows. If you need full T-SQL data manipulation and multi-table transactions, use a Fabric warehouse instead<\/li>\n\n\n\n<li>Heavily transactional workloads still belong in an operational database, not a lakehouse<\/li>\n\n\n\n<li class=\"has-normal-font-size\">Performance depends on capacity sizing and on table maintenance. Small file accumulation degrades query speed until tables are optimised and compacted<\/li>\n\n\n\n<li>Two teams writing to the same table through different engines will eventually produce a conflict that no amount of Delta cleverness prevents<\/li>\n<\/ul>\n\n\n\n<h3 id=\"h-medallion-architecture-in-a-fabric-lakehouse\" class=\"wp-block-heading has-h-5-font-size\"><strong>Medallion architecture in a Fabric lakehouse<\/strong><\/h3>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">A medallion architecture means bronze, silver and gold layers all living within one system. A data engineer lands raw files in the bronze layer with Spark notebooks, cleans and conforms them into silver, then builds business-ready aggregates in gold for analysts to consume in Power BI.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">In Fabric this happens without moving data between platforms. All three layers sit on the same Delta storage in OneLake. Spark and the SQL endpoint read the same files rather than separate copies, so lineage stays intact and reconciliation between layers stops being a weekly argument.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-dominant-color=\"b9d0b9\" data-has-transparency=\"false\" style=\"--dominant-color: #b9d0b9;\" loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"788\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/medallion-architecture-one-lake-1.webp\" alt=\"Diagram of the medallion architecture illustrating bronze, silver, and gold layers sharing a single Delta storage layer in OneLake.\" class=\"wp-image-2665 not-transparent\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/medallion-architecture-one-lake-1.webp 940w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/medallion-architecture-one-lake-1-300x251.webp 300w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><figcaption class=\"wp-element-caption\">Figure 1. Bronze, silver and gold tables all live on one Delta storage layer; Spark and the SQL endpoint read the same files instead of separate copies.<\/figcaption><\/figure>\n\n\n\n<h3 id=\"h-lakehouse-vs-data-lake-vs-data-warehouse\" class=\"wp-block-heading has-h-5-font-size\"><strong>Lakehouse vs data lake vs data warehouse<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table has-small-font-size\"><table class=\"has-background\" style=\"background-color:#ffffff\"><thead><tr><th>Aspect<\/th><th>Data lake<\/th><th>Data warehouse<\/th><th>Data lakehouse<\/th><\/tr><\/thead><tbody><tr><td><strong>Data structure<\/strong><\/td><td>Raw, unstructured or semi-structured<\/td><td>Highly structured, schema on write<\/td><td>All types, unified by an open metadata layer<\/td><\/tr><tr><td><strong>Typical cost<\/strong><\/td><td>Low<\/td><td>High<\/td><td>Medium to low<\/td><\/tr><tr><td><strong>Primary users<\/strong><\/td><td>Data scientists, ML engineers<\/td><td>Business analysts, BI tools<\/td><td>Data scientists, analysts and developers<\/td><\/tr><tr><td><strong>Query performance<\/strong><\/td><td>Slower ad hoc queries<\/td><td>Very fast for SQL<\/td><td>Fast SQL plus direct access to the lake<\/td><\/tr><tr><td><strong>ACID transactions<\/strong><\/td><td>No<\/td><td>Yes<\/td><td>Yes, through Delta Lake, Iceberg or Hudi<\/td><\/tr><tr><td><strong>Fabric equivalent<\/strong><\/td><td>OneLake files, or a shortcut to external storage<\/td><td>Fabric warehouse<\/td><td>Fabric lakehouse<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-dominant-color=\"b7d6d0\" data-has-transparency=\"false\" style=\"--dominant-color: #b7d6d0;\" loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"788\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/onelake-center-of-fabric-copilot.webp\" alt=\"Architectural diagram showing OneLake at the center of Microsoft Fabric with integrated compute engines and Copilot assistance.\" class=\"wp-image-2666 not-transparent\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/onelake-center-of-fabric-copilot.webp 940w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/onelake-center-of-fabric-copilot-300x251.webp 300w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><figcaption class=\"wp-element-caption\">Figure 2. OneLake sits at the centre of Fabric; every engine reads and writes the same copy of data, and Copilot assists across all of them.<\/figcaption><\/figure>\n\n\n\n<h2 id=\"h-what-does-fabric-data-factory-do\" class=\"wp-block-heading has-h-4-font-size\">What does Fabric Data Factory do?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><a href=\"https:\/\/learn.microsoft.com\/en-us\/fabric\/data-factory\/data-factory-overview\">Fabric Data Factory<\/a> is the built-in data integration workload for extract, transform, load (ETL) and extract, load, transform (ELT) pipelines. It provides data pipelines, Copy jobs, Dataflow Gen2 and mirroring, with <a href=\"https:\/\/learn.microsoft.com\/en-us\/fabric\/data-factory\/connector-overview\">more than 145 built-in connectors<\/a> covering on-premises, multicloud and software as a service sources.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">It merges features from Azure Data Factory and Power Query. Pipelines handle orchestration, branching, retries and calls out to notebooks or stored procedures. Dataflow Gen2 gives analysts a low-code Power Query surface for straightforward transformations. Copy jobs simplify bulk and incremental movement. <a href=\"https:\/\/docs.getdbt.com\/\">Data Build Tool (dbt)<\/a> integration is available for teams already working that way, and triggers can be scheduled, event-based through the Real-Time hub, or manual.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">The advantage of having integration inside Fabric is that pipelines, notebooks and dataflows all target OneLake tables directly and write in open Delta format by default. There is no separate integration stack to stand up, secure and monitor.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><strong>Strengths<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li>Integration lives alongside analytics, with no separate service to provision<\/li>\n\n\n\n<li>Large connector library covering on-premises, multicloud and SaaS sources<\/li>\n\n\n\n<li>ETL and ELT patterns can be mixed freely in the same pipeline<\/li>\n\n\n\n<li>Output lands in open Delta format in OneLake without a conversion step<\/li>\n<\/ul>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><strong>Watch-outs<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li>Azure Data Factory remains the more mature option for very large or unusually complex enterprise pipelines. Fabric Data Factory is newer and still evolving<\/li>\n\n\n\n<li>Dataflow Gen2 has a wide transform library but does not cover every case, and complex logic belongs in a notebook<\/li>\n\n\n\n<li>Teams already invested in Databricks or third-party orchestration face real porting work<\/li>\n\n\n\n<li>Cost is tied to capacity unit consumption, which is harder to forecast than a fixed per-pipeline price<\/li>\n<\/ul>\n\n\n\n<h2 id=\"h-what-is-real-time-intelligence-in-microsoft-fabric\" class=\"wp-block-heading has-h-4-font-size\">What is Real-Time Intelligence in Microsoft Fabric?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><a href=\"https:\/\/learn.microsoft.com\/en-us\/fabric\/real-time-intelligence\/overview\">Real-Time Intelligence<\/a> is Fabric&#8217;s streaming workload. It combines eventstreams for ingestion, <a href=\"https:\/\/learn.microsoft.com\/en-us\/fabric\/real-time-intelligence\/eventhouse\">Eventhouse<\/a> for storage and query, and <a href=\"https:\/\/learn.microsoft.com\/en-us\/fabric\/real-time-intelligence\/event-streams\/add-destination-activator\">Activator<\/a> for no-code rules that fire when conditions are met. It is designed for telemetry, logs, Internet of Things (IoT) feeds and any data where the value decays within minutes.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Eventhouses are purpose-built Kusto Query Language (KQL) databases optimised for ingesting and querying event streams at scale, with automatic schema inference and storage optimisation. Activator continuously monitors that stream data for patterns and triggers actions when thresholds are crossed: an alert to Teams or email, a pipeline run, a notebook execution, or a Power Automate flow.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">The Real-Time hub sits above all of it as a single catalogue of streaming sources across the tenant, which is where most teams start when they are trying to work out what is already flowing before they add more.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><strong>Strengths<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Handles high-volume event data that would be expensive to hold in a warehouse<\/li>\n\n\n\n<li>KQL is fast and expressive for time series, logs and telemetry<\/li>\n\n\n\n<li class=\"has-normal-font-size\">Activator lets business rules be defined without code, then trigger real actions<\/li>\n\n\n\n<li>Streaming data lands in the same governed estate as everything else<\/li>\n<\/ul>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><strong>Watch-outs<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>KQL is a separate language from T-SQL and Python, and it is a real learning curve for teams who have not used Azure Data Explorer<\/li>\n\n\n\n<li>Streaming ingestion consumes capacity continuously, not in bursts, which changes how you size<\/li>\n\n\n\n<li class=\"has-normal-font-size\">Activator rules need governance of their own, or you end up with alert fatigue and orphaned triggers<\/li>\n<\/ul>\n\n\n\n<h2 id=\"h-how-do-security-and-governance-work-in-microsoft-fabric\" class=\"wp-block-heading has-h-4-font-size\">How do security and governance work in Microsoft Fabric?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Fabric applies security at two levels. Workspace roles (Admin, Member, Contributor and Viewer) control who can create and manage content. OneLake security roles control which tables, rows and columns a user can read. Both are enforced consistently across SQL, Spark, KQL and Power BI.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Identity comes from Microsoft Entra ID, formerly Azure Active Directory. Fabric integrates with Microsoft Purview Information Protection, so sensitivity labels applied to OneLake items carry encryption and access restrictions that persist even when the data leaves Fabric, for example in an exported Excel file. Lineage views trace a report back through its semantic model, lakehouse tables and source pipelines, which matters when someone asks where a number came from.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Domains give larger organisations a way to group workspaces by business area and delegate administration, so the central data team is not the bottleneck for every access request.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-dominant-color=\"b0c9b9\" data-has-transparency=\"false\" style=\"--dominant-color: #b0c9b9;\" loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"788\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/fabric-security-workspace-onelake-roles.webp\" alt=\"Infographic explaining how workspace roles and OneLake security roles govern user access across Microsoft Fabric.\" class=\"wp-image-2667 not-transparent\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/fabric-security-workspace-onelake-roles.webp 940w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/fabric-security-workspace-onelake-roles-300x251.webp 300w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><figcaption class=\"wp-element-caption\">Figure 3. Workspace roles control who can create content; OneLake security roles control what data they can see, and both are enforced the same way across every engine.<\/figcaption><\/figure>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><strong>Watch-outs<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li class=\"has-normal-font-size\">Two overlapping permission systems means it is easy to grant broad workspace access and assume data-level rules will contain it. Test with a real low-privilege account before go-live<\/li>\n\n\n\n<li>Sensitivity labels only help if your Purview taxonomy is already in reasonable shape<\/li>\n<\/ul>\n\n\n\n<h2 id=\"h-what-can-copilot-do-in-microsoft-fabric\" class=\"wp-block-heading has-h-4-font-size\">What can Copilot do in Microsoft Fabric?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><a href=\"https:\/\/learn.microsoft.com\/en-us\/fabric\/fundamentals\/copilot-fabric-overview\">Copilot in Fabric<\/a> provides generative AI assistance inside each workload: code suggestions and error fixes in notebooks, pipeline generation and transformation explanations in Data Factory, natural language to SQL in warehouses, KQL generation in Real-Time Intelligence, and report building, page summaries and DAX help in Power BI.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Because Copilot runs inside Fabric, it reads your workspace context without manual setup and respects the security context of the user asking. It will not surface data the user could not otherwise see. In notebooks it also surfaces performance guidance, such as flagging operations that will cause an expensive data shuffle, alongside the code it suggests.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><strong>What Copilot in Fabric requires<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li>A paid Fabric capacity at F2 or higher, which is the smallest paid tier, or a legacy Power BI Premium capacity at P1 or higher. The requirement was previously F64, which put Copilot out of reach for smaller teams<\/li>\n\n\n\n<li>Pro and Premium Per User licences alone do not enable it. Copilot needs organisational capacity<\/li>\n\n\n\n<li>Trial and free SKUs are not supported<\/li>\n\n\n\n<li>Tenant settings and capacity settings both have to be switched on. The Copilot button can appear while remaining non-functional if either is missing<\/li>\n\n\n\n<li>A supported region. The Azure OpenAI service behind Fabric Copilot is deployed in US datacentres and within the EU data boundary, so Australian tenants generally need the tenant setting that permits data to be processed outside the tenant&#8217;s geographic region. Confirm this with your security team before you plan a rollout<\/li>\n<\/ul>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">These rules have changed more than once, so check the current position in Microsoft&#8217;s <a href=\"https:\/\/learn.microsoft.com\/en-us\/fabric\/enterprise\/fabric-copilot-capacity\">Fabric Copilot capacity documentation<\/a> before you commit to a capacity size.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><strong>Watch-outs<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li>Copilot usage consumes capacity units, so heavy use competes with refreshes and queries on the same capacity<\/li>\n\n\n\n<li>Generated DAX, SQL and KQL still needs review. It is a drafting accelerator, not a substitute for understanding the model<\/li>\n\n\n\n<li>Output quality depends heavily on how well the semantic model is named and documented. Copilot cannot infer meaning from a table called Table1<\/li>\n<\/ul>\n\n\n\n<h2 id=\"h-what-is-fabric-iq\" class=\"wp-block-heading has-h-4-font-size\">What is Fabric IQ?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><a href=\"https:\/\/learn.microsoft.com\/en-us\/fabric\/iq\/overview\">Fabric IQ<\/a> is Fabric&#8217;s semantic and context layer. Announced at Microsoft Ignite in November 2025 and made generally available at Microsoft Build in June 2026, it sits above OneLake and gives both people and AI agents a shared definition of business entities, metrics and the relationships between them.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">The problem it addresses is semantic drift. Marketing counts a customer as anyone who downloaded a whitepaper, sales counts anyone with an active contract, and finance counts anyone whose first payment has cleared. Same word, three definitions, and every cross-functional dashboard inherits the disagreement. Fabric IQ makes those definitions explicit and shared.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">It is delivered through several items. Semantic models supply trusted measures. Ontology, still in preview, defines the shared business language over those measures. Graph powers relationship and impact analysis. Plan turns insight into coordinated action. Data agents and operations agents provide concept-aware interaction over live and historical data.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">For most teams, Fabric IQ is not a day one concern. It becomes relevant at the point where you start pointing AI agents at your data and need them to reason in business terms rather than table names. <\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Because this is the newest and most heavily marketed part of Fabric, it is worth reading outside the vendor material. Data architect James Serra&#8217;s <a href=\"https:\/\/www.jamesserra.com\/archive\/2026\/06\/microsoft-build-2026-announcements\/\">summary of the Build 2026 announcements<\/a> gives a practitioner view, and <a href=\"https:\/\/www.constellationr.com\/insights\/news\/microsoft-build-2026-windows-rayfin-fabric-iq-and-more\">Constellation Research<\/a> covers how Fabric IQ fits into the wider Microsoft IQ strategy.<\/p>\n\n\n\n<h2 id=\"h-how-does-power-bi-fit-into-microsoft-fabric\" class=\"wp-block-heading has-h-4-font-size\">How does Power BI fit into Microsoft Fabric?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Power BI is a first-class Fabric workload rather than a separate product. Lakehouses, warehouses and OneLake files are native sources, and Direct Lake mode lets a semantic model read Delta files in OneLake directly, without an import refresh and without translating queries back to a source system.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Direct Lake is the reason the Fabric and Power BI story hangs together. It gives close to import-mode performance on data volumes that would previously have forced you into DirectQuery, and it removes the refresh window entirely. When it cannot serve a query, for example because a feature is unsupported or the model exceeds the capacity guardrails, it falls back to DirectQuery rather than failing.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-table has-small-font-size\"><table class=\"has-background has-fixed-layout\" style=\"background-color:#ffffff\"><thead><tr><th>Mode<\/th><th>How data is read<\/th><th>Refresh<\/th><th>Best for<\/th><\/tr><\/thead><tbody><tr><td>Import<\/td><td>Copied into the model in memory<\/td><td>Scheduled refresh required<\/td><td>Smaller models where you need every DAX and Power Query feature<\/td><\/tr><tr><td>DirectQuery<\/td><td>Query sent to the source at report time<\/td><td>No refresh, always live<\/td><td>Very large sources, or where data must not be copied<\/td><\/tr><tr><td>Direct Lake<\/td><td>Delta files in OneLake read directly into memory<\/td><td>No refresh, updates as the table updates<\/td><td>Large Fabric lakehouse or warehouse tables where you want import-like speed<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Data produced anywhere in Fabric, whether by a dataflow, a notebook or a pipeline, feeds into Power BI reports without an export step. For organisations already running Power BI, this is usually the most familiar entry point into Fabric, and the one where the value is easiest to demonstrate.<\/p>\n\n\n\n<h2 id=\"h-which-fabric-workload-should-you-use\" class=\"wp-block-heading has-h-4-font-size\">Which Fabric workload should you use?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">The most common early mistake is putting a workload in the wrong item and then fighting the platform. The table below covers the decisions teams make in their first few months on Fabric.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-table has-small-font-size\"><table class=\"has-background has-fixed-layout\" style=\"background-color:#ffffff\"><thead><tr><th>If you need to<\/th><th>Use<\/th><\/tr><\/thead><tbody><tr><td><strong>Land raw files and transform them with Spark or notebooks<\/strong><\/td><td>Lakehouse<\/td><\/tr><tr><td><strong>Write full T-SQL with multi-table transactions and data manipulation<\/strong><\/td><td>Warehouse<\/td><\/tr><tr><td><strong>Move data from many sources on a schedule<\/strong><\/td><td>Data Factory pipeline or Copy job<\/td><\/tr><tr><td><strong>Give analysts a low-code transformation surface<\/strong><\/td><td>Dataflow Gen2<\/td><\/tr><tr><td><strong>Replicate an operational database with no pipeline<\/strong><\/td><td>Mirroring<\/td><\/tr><tr><td><strong>Reference data held in S3 or ADLS Gen2 without copying it<\/strong><\/td><td>OneLake shortcut<\/td><\/tr><tr><td><strong>Query high-volume event, log or telemetry data<\/strong><\/td><td>Eventhouse and KQL<\/td><\/tr><tr><td><strong>Trigger an action when a threshold is crossed<\/strong><\/td><td>Activator<\/td><\/tr><tr><td><strong>Give AI agents shared business definitions<\/strong><\/td><td>Fabric IQ<\/td><\/tr><tr><td><strong>Report on large tables without an import refresh<\/strong><\/td><td>Power BI Direct Lake<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 id=\"h-what-are-the-main-limitations-of-microsoft-fabric\" class=\"wp-block-heading has-h-4-font-size\">What are the main limitations of Microsoft Fabric?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Fabric is a strong platform with four constraints that catch most teams in the first year.<\/p>\n\n\n\n<ol class=\"wp-block-list has-normal-font-size\">\n<li>Capacity contention. Every workload draws from the same pool. Fabric smooths bursts over time, but sustained overuse leads to throttling that presents as slow reports rather than an obvious error. Monitoring the Capacity Metrics app is not optional.<\/li>\n\n\n\n<li>Feature maturity. Fabric Data Factory does not yet match Azure Data Factory for the most complex enterprise pipelines, and the warehouse does not match a mature dedicated SQL pool on every workload. Check your specific requirements rather than assuming parity.<\/li>\n\n\n\n<li class=\"has-normal-font-size\">Cost forecasting. Capacity unit consumption is harder to predict than per-service pricing, particularly once Copilot and streaming are in the mix. Run a real workload on a trial or an F2 before committing to a reserved capacity.<\/li>\n\n\n\n<li>Skills. Fabric asks one team to work across T-SQL, Python or PySpark, KQL, DAX and Power Query. Very few teams have all five. This is the constraint that most often stalls a rollout, and it is the one least likely to appear in a vendor evaluation.<\/li>\n<\/ol>\n\n\n\n<h2 id=\"h-getting-your-team-ready-for-fabric\" class=\"wp-block-heading has-h-4-font-size\">Getting your team ready for Fabric<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">The organisations that get value from Fabric tend to follow the same pattern: a small group of users first, a short period of structured hands-on training on real workloads, and a checkpoint before the platform is opened up more widely. The ones that struggle move straight from buying capacity to hoping people work it out.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Most teams find the practical entry point is Power BI, because the reporting layer is where the value shows up first and where existing skills transfer. From there, Data Factory and the lakehouse follow naturally.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote has-background is-layout-flow wp-block-quote-is-layout-flow\" style=\"background-color:#eef5f5\">\n<p class=\"has-normal-font-size wp-block-paragraph\"><strong>Where Dynamic Web Training fits in<\/strong><\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">We run instructor-led <a href=\"https:\/\/www.dynamicwebtraining.com.au\/packages\/power-bi-training-package\">Power BI training<\/a> in Sydney, Melbourne and Online Live across Australia, covering data modelling, DAX and report design: the skills that determine whether a Fabric investment produces anything useful. The full package also prepares you for the Microsoft PL-300 Power BI Data Analyst exam. We also run <a href=\"https:\/\/www.dynamicwebtraining.com.au\/microsoft-copilot-training-courses\">Microsoft Copilot training<\/a> for teams whose Microsoft 365 renewal has just added Copilot seats, built around real Word, Excel, PowerPoint and Outlook workflows.<\/p>\n<\/blockquote>\n\n\n\n<h2 id=\"h-conclusion\" class=\"wp-block-heading has-h-4-font-size\">Conclusion<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Microsoft Fabric brings data engineering, data integration, real-time analytics, business intelligence and data science into a single SaaS platform. OneLake, lakehouses, Data Factory, Real-Time Intelligence, Fabric IQ, Direct Lake and Copilot each solve a real problem, and together they remove most of the copying and reconciliation that made previous stacks expensive to run.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><br>The platform is not the hard part. Capacity discipline and skills are. Teams that plan for both get the benefit that the architecture promises. Teams that plan for neither end up with the same silos in a newer interface.<\/p>\n\n\n\n<h2 id=\"h-frequently-asked-questions\" class=\"wp-block-heading has-h-4-font-size\">Frequently asked questions<\/h2>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block has-normal-font-size\"><div class=\"schema-faq-section\" id=\"faq-question-1785890301259\"><strong class=\"schema-faq-question\">What is Microsoft Fabric used for?<\/strong> <p class=\"schema-faq-answer\">Microsoft Fabric is used to run an entire analytics estate in one platform: ingesting data, storing it in OneLake, transforming it with Spark or SQL, analysing streaming events, and reporting on it in Power BI. It replaces the need to buy and integrate separate Azure data services.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1785890381006\"><strong class=\"schema-faq-question\">Is Microsoft Fabric replacing Power BI?<\/strong> <p class=\"schema-faq-answer\">No. Power BI is a workload inside Microsoft Fabric, not a product being retired. Existing Power BI reports, semantic models and workspaces continue to work. Fabric adds data engineering, warehousing and streaming capabilities around Power BI and introduces Direct Lake mode for reading OneLake data directly.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1785890396511\"><strong class=\"schema-faq-question\">What is the difference between a Fabric lakehouse and a Fabric warehouse?<\/strong> <p class=\"schema-faq-answer\">A lakehouse stores Delta files and exposes a read-only SQL analytics endpoint alongside a Spark endpoint. A warehouse offers full T-SQL, including data manipulation and multi-table transactions. Use a lakehouse for engineering and mixed data types, and a warehouse when you need transactional SQL behaviour.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1785890407866\"><strong class=\"schema-faq-question\">Does Microsoft Fabric replace Azure Data Factory or Azure Synapse?<\/strong> <p class=\"schema-faq-answer\">Fabric covers most of what those services do, but not all of it. Azure Data Factory remains stronger for very large or unusually complex enterprise pipelines. Microsoft positions Fabric as the strategic direction, so check your specific requirements against Fabric Data Factory before migrating.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1785890414849\"><strong class=\"schema-faq-question\">What capacity do you need for Copilot in Microsoft Fabric?<\/strong> <p class=\"schema-faq-answer\">Copilot needs a paid Fabric capacity of F2 or higher. Fabric capacities are named F followed by the number of capacity units they provide, so F2 is the smallest paid tier. Power BI Pro and Premium Per User licences alone are not sufficient, trial capacities are excluded, and tenant and capacity settings must both be enabled.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1785890425711\"><strong class=\"schema-faq-question\">What do Fabric capacity names like F2 and F64 mean?<\/strong> <p class=\"schema-faq-answer\">Fabric capacities are named F followed by the number of capacity units they provide, running from F2 up to F2048. F2 is the smallest paid tier and the minimum for Copilot. F64 is the threshold at which report viewers holding a free Fabric licence no longer need a Power BI Pro licence.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1785890440853\"><strong class=\"schema-faq-question\">Is Microsoft Fabric available in Australia?<\/strong> <p class=\"schema-faq-answer\">Yes. Fabric capacities can be provisioned in Australian Azure regions. However, the Azure OpenAI service behind Fabric Copilot runs in US datacentres and the EU data boundary, so Australian tenants usually need to enable the tenant setting permitting processing outside their geographic region for Copilot to work.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1785890450349\"><strong class=\"schema-faq-question\">What is Direct Lake mode in Power BI?<\/strong> <p class=\"schema-faq-answer\">Direct Lake lets a Power BI semantic model read Delta tables in OneLake directly into memory, with no scheduled refresh and no query translation to a source system. It delivers close to import-mode performance on large tables and falls back to DirectQuery when a query cannot be served.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1785890460464\"><strong class=\"schema-faq-question\">How much does Microsoft Fabric cost?<\/strong> <p class=\"schema-faq-answer\">Fabric is priced on capacity rather than per user. Capacities are named F followed by their capacity units, running from F2 upwards, and are bought pay as you go or reserved for a year at a discount. Prices vary by Azure region. Below the F64 tier, report viewers still need Power BI Pro licences.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1785890471788\"><strong class=\"schema-faq-question\">Do you need to know Python or SQL to use Microsoft Fabric?<\/strong> <p class=\"schema-faq-answer\">It depends on the role. Analysts can work entirely in Power BI, Dataflow Gen2 and the SQL analytics endpoint without Python. Data engineers generally need PySpark. Real-Time Intelligence requires KQL. Most teams need T-SQL and DAX as a minimum across the group.<\/p> <\/div> <\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Fabric is a unified software as a service (SaaS) analytics platform that brings data engineering, data warehousing, data integration, real-time analytics, data science and Power BI into one governed environment. Every workload writes to OneLake, a single logical data lake in open Delta Lake format, so one copy of data serves every engine instead&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2178],"tags":[],"class_list":["post-2662","post","type-post","status-publish","format-standard","hentry","category-microsoft-fabric"],"yoast_head":"<title>Microsoft Fabric Features Explained: 2026 Guide<\/title>\n<meta name=\"description\" content=\"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Fabric Features Explained: A 2026 Guide for Data Teams\" \/>\n<meta property=\"og:description\" content=\"Microsoft Fabric explained for data teams: OneLake, lakehouses, Data Factory, Real-Time Intelligence, Fabric IQ and Copilot, with pros and cons.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide\" \/>\n<meta property=\"og:site_name\" content=\"Dynamic Web Training Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-08-05T00:57:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-05T07:19:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/microsoft-fabric-architecture-overview.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"2400\" \/>\n\t<meta property=\"og:image:height\" content=\"1260\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dynamic Web Training\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:site\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dynamic Web Training\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"20 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide\"},\"author\":{\"name\":\"Dynamic Web Training\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/person\\\/c94653aed4a6decc8e357af0a1082233\"},\"headline\":\"Microsoft Fabric Features Explained: A 2026 Guide for Data Teams\",\"datePublished\":\"2026-08-05T00:57:16+00:00\",\"dateModified\":\"2026-08-05T07:19:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide\"},\"wordCount\":4258,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/microsoft-fabric-architecture-overview-1024x538.webp\",\"articleSection\":[\"Microsoft Fabric\"],\"inLanguage\":\"en-AU\"},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide\",\"name\":\"Microsoft Fabric Features Explained: 2026 Guide\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/microsoft-fabric-architecture-overview-1024x538.webp\",\"datePublished\":\"2026-08-05T00:57:16+00:00\",\"dateModified\":\"2026-08-05T07:19:36+00:00\",\"description\":\"Microsoft Fabric explained for data teams: OneLake, lakehouses, Data Factory, Real-Time Intelligence, Fabric IQ and Copilot, with pros and cons.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890301259\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890381006\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890396511\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890407866\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890414849\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890425711\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890440853\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890450349\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890460464\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890471788\"}],\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#primaryimage\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/microsoft-fabric-architecture-overview-1024x538.webp\",\"contentUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/microsoft-fabric-architecture-overview-1024x538.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Training Blog\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Training\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/category\\\/training\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft Fabric\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/category\\\/training\\\/microsoft-fabric\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Microsoft Fabric Features Explained: A 2026 Guide for Data Teams\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\",\"name\":\"Dynamic Web Training Blog\",\"description\":\"The Ultimate Training Experience.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-AU\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\",\"name\":\"Dynamic Web Training\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo.png\",\"width\":361,\"height\":109,\"caption\":\"Dynamic Web Training\",\"name\":\"Dynamic Web Training Logo\",\"description\":\"Dynamic Web Training official site logo asset\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/DynamicWebTraining\\\/\",\"https:\\\/\\\/x.com\\\/dynamicwebtrain\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/person\\\/c94653aed4a6decc8e357af0a1082233\",\"name\":\"Dynamic Web Training\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"caption\":\"Dynamic Web Training\"},\"description\":\"This article is written by a senior writer at Dynamic Web Training. Our specialist writers are either Microsoft Certified Trainers, Adobe Certified Professionals or Certified Xero Advisors.\",\"sameAs\":[\"https:\\\/\\\/www.dynamicwebtraining.com.au\",\"https:\\\/\\\/www.facebook.com\\\/DynamicWebTraining\\\/\",\"https:\\\/\\\/www.instagram.com\\\/dynamicwebtraining\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dynamic-web-training\",\"https:\\\/\\\/x.com\\\/dynamicwebtrain\",\"www.youtube.com\\\/@dynamicwebtraining8740\"],\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890301259\",\"position\":1,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890301259\",\"name\":\"What is Microsoft Fabric used for?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Microsoft Fabric is used to run an entire analytics estate in one platform: ingesting data, storing it in OneLake, transforming it with Spark or SQL, analysing streaming events, and reporting on it in Power BI. It replaces the need to buy and integrate separate Azure data services.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890381006\",\"position\":2,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890381006\",\"name\":\"Is Microsoft Fabric replacing Power BI?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"No. Power BI is a workload inside Microsoft Fabric, not a product being retired. Existing Power BI reports, semantic models and workspaces continue to work. Fabric adds data engineering, warehousing and streaming capabilities around Power BI and introduces Direct Lake mode for reading OneLake data directly.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890396511\",\"position\":3,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890396511\",\"name\":\"What is the difference between a Fabric lakehouse and a Fabric warehouse?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"A lakehouse stores Delta files and exposes a read-only SQL analytics endpoint alongside a Spark endpoint. A warehouse offers full T-SQL, including data manipulation and multi-table transactions. Use a lakehouse for engineering and mixed data types, and a warehouse when you need transactional SQL behaviour.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890407866\",\"position\":4,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890407866\",\"name\":\"Does Microsoft Fabric replace Azure Data Factory or Azure Synapse?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Fabric covers most of what those services do, but not all of it. Azure Data Factory remains stronger for very large or unusually complex enterprise pipelines. Microsoft positions Fabric as the strategic direction, so check your specific requirements against Fabric Data Factory before migrating.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890414849\",\"position\":5,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890414849\",\"name\":\"What capacity do you need for Copilot in Microsoft Fabric?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Copilot needs a paid Fabric capacity of F2 or higher. Fabric capacities are named F followed by the number of capacity units they provide, so F2 is the smallest paid tier. Power BI Pro and Premium Per User licences alone are not sufficient, trial capacities are excluded, and tenant and capacity settings must both be enabled.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890425711\",\"position\":6,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890425711\",\"name\":\"What do Fabric capacity names like F2 and F64 mean?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Fabric capacities are named F followed by the number of capacity units they provide, running from F2 up to F2048. F2 is the smallest paid tier and the minimum for Copilot. F64 is the threshold at which report viewers holding a free Fabric licence no longer need a Power BI Pro licence.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890440853\",\"position\":7,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890440853\",\"name\":\"Is Microsoft Fabric available in Australia?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Yes. Fabric capacities can be provisioned in Australian Azure regions. However, the Azure OpenAI service behind Fabric Copilot runs in US datacentres and the EU data boundary, so Australian tenants usually need to enable the tenant setting permitting processing outside their geographic region for Copilot to work.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890450349\",\"position\":8,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890450349\",\"name\":\"What is Direct Lake mode in Power BI?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Direct Lake lets a Power BI semantic model read Delta tables in OneLake directly into memory, with no scheduled refresh and no query translation to a source system. It delivers close to import-mode performance on large tables and falls back to DirectQuery when a query cannot be served.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890460464\",\"position\":9,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890460464\",\"name\":\"How much does Microsoft Fabric cost?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Fabric is priced on capacity rather than per user. Capacities are named F followed by their capacity units, running from F2 upwards, and are bought pay as you go or reserved for a year at a discount. Prices vary by Azure region. Below the F64 tier, report viewers still need Power BI Pro licences.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890471788\",\"position\":10,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/microsoft-fabric-features-guide#faq-question-1785890471788\",\"name\":\"Do you need to know Python or SQL to use Microsoft Fabric?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"It depends on the role. Analysts can work entirely in Power BI, Dataflow Gen2 and the SQL analytics endpoint without Python. Data engineers generally need PySpark. Real-Time Intelligence requires KQL. Most teams need T-SQL and DAX as a minimum across the group.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"}]}<\/script>","yoast_head_json":{"title":"Microsoft Fabric Features Explained: 2026 Guide","description":"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide","og_locale":"en_US","og_type":"article","og_title":"Microsoft Fabric Features Explained: A 2026 Guide for Data Teams","og_description":"Microsoft Fabric explained for data teams: OneLake, lakehouses, Data Factory, Real-Time Intelligence, Fabric IQ and Copilot, with pros and cons.","og_url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide","og_site_name":"Dynamic Web Training Blog","article_publisher":"https:\/\/www.facebook.com\/DynamicWebTraining\/","article_author":"https:\/\/www.facebook.com\/DynamicWebTraining\/","article_published_time":"2026-08-05T00:57:16+00:00","article_modified_time":"2026-08-05T07:19:36+00:00","og_image":[{"width":2400,"height":1260,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/microsoft-fabric-architecture-overview.webp","type":"image\/png"}],"author":"Dynamic Web Training","twitter_card":"summary_large_image","twitter_creator":"@dynamicwebtrain","twitter_site":"@dynamicwebtrain","twitter_misc":{"Written by":"Dynamic Web Training","Est. reading time":"20 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#article","isPartOf":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide"},"author":{"name":"Dynamic Web Training","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233"},"headline":"Microsoft Fabric Features Explained: A 2026 Guide for Data Teams","datePublished":"2026-08-05T00:57:16+00:00","dateModified":"2026-08-05T07:19:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide"},"wordCount":4258,"publisher":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/microsoft-fabric-architecture-overview-1024x538.webp","articleSection":["Microsoft Fabric"],"inLanguage":"en-AU"},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide","name":"Microsoft Fabric Features Explained: 2026 Guide","isPartOf":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#primaryimage"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/microsoft-fabric-architecture-overview-1024x538.webp","datePublished":"2026-08-05T00:57:16+00:00","dateModified":"2026-08-05T07:19:36+00:00","description":"Microsoft Fabric explained for data teams: OneLake, lakehouses, Data Factory, Real-Time Intelligence, Fabric IQ and Copilot, with pros and cons.","breadcrumb":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#breadcrumb"},"mainEntity":[{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890301259"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890381006"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890396511"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890407866"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890414849"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890425711"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890440853"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890450349"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890460464"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890471788"}],"inLanguage":"en-AU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide"]}]},{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#primaryimage","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/microsoft-fabric-architecture-overview-1024x538.webp","contentUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/microsoft-fabric-architecture-overview-1024x538.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Training Blog","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/"},{"@type":"ListItem","position":2,"name":"Training","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training"},{"@type":"ListItem","position":3,"name":"Microsoft Fabric","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-fabric"},{"@type":"ListItem","position":4,"name":"Microsoft Fabric Features Explained: A 2026 Guide for Data Teams"}]},{"@type":"WebSite","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/","name":"Dynamic Web Training Blog","description":"The Ultimate Training Experience.","publisher":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-AU"},{"@type":"Organization","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization","name":"Dynamic Web Training","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png","contentUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png","width":361,"height":109,"caption":"Dynamic Web Training","name":"Dynamic Web Training Logo","description":"Dynamic Web Training official site logo asset"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DynamicWebTraining\/","https:\/\/x.com\/dynamicwebtrain"]},{"@type":"Person","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233","name":"Dynamic Web Training","image":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","caption":"Dynamic Web Training"},"description":"This article is written by a senior writer at Dynamic Web Training. Our specialist writers are either Microsoft Certified Trainers, Adobe Certified Professionals or Certified Xero Advisors.","sameAs":["https:\/\/www.dynamicwebtraining.com.au","https:\/\/www.facebook.com\/DynamicWebTraining\/","https:\/\/www.instagram.com\/dynamicwebtraining\/","https:\/\/www.linkedin.com\/company\/dynamic-web-training","https:\/\/x.com\/dynamicwebtrain","www.youtube.com\/@dynamicwebtraining8740"],"url":"https:\/\/www.dynamicwebtraining.com.au"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890301259","position":1,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890301259","name":"What is Microsoft Fabric used for?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Microsoft Fabric is used to run an entire analytics estate in one platform: ingesting data, storing it in OneLake, transforming it with Spark or SQL, analysing streaming events, and reporting on it in Power BI. It replaces the need to buy and integrate separate Azure data services.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890381006","position":2,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890381006","name":"Is Microsoft Fabric replacing Power BI?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"No. Power BI is a workload inside Microsoft Fabric, not a product being retired. Existing Power BI reports, semantic models and workspaces continue to work. Fabric adds data engineering, warehousing and streaming capabilities around Power BI and introduces Direct Lake mode for reading OneLake data directly.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890396511","position":3,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890396511","name":"What is the difference between a Fabric lakehouse and a Fabric warehouse?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"A lakehouse stores Delta files and exposes a read-only SQL analytics endpoint alongside a Spark endpoint. A warehouse offers full T-SQL, including data manipulation and multi-table transactions. Use a lakehouse for engineering and mixed data types, and a warehouse when you need transactional SQL behaviour.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890407866","position":4,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890407866","name":"Does Microsoft Fabric replace Azure Data Factory or Azure Synapse?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Fabric covers most of what those services do, but not all of it. Azure Data Factory remains stronger for very large or unusually complex enterprise pipelines. Microsoft positions Fabric as the strategic direction, so check your specific requirements against Fabric Data Factory before migrating.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890414849","position":5,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890414849","name":"What capacity do you need for Copilot in Microsoft Fabric?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Copilot needs a paid Fabric capacity of F2 or higher. Fabric capacities are named F followed by the number of capacity units they provide, so F2 is the smallest paid tier. Power BI Pro and Premium Per User licences alone are not sufficient, trial capacities are excluded, and tenant and capacity settings must both be enabled.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890425711","position":6,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890425711","name":"What do Fabric capacity names like F2 and F64 mean?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Fabric capacities are named F followed by the number of capacity units they provide, running from F2 up to F2048. F2 is the smallest paid tier and the minimum for Copilot. F64 is the threshold at which report viewers holding a free Fabric licence no longer need a Power BI Pro licence.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890440853","position":7,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890440853","name":"Is Microsoft Fabric available in Australia?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Yes. Fabric capacities can be provisioned in Australian Azure regions. However, the Azure OpenAI service behind Fabric Copilot runs in US datacentres and the EU data boundary, so Australian tenants usually need to enable the tenant setting permitting processing outside their geographic region for Copilot to work.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890450349","position":8,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890450349","name":"What is Direct Lake mode in Power BI?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Direct Lake lets a Power BI semantic model read Delta tables in OneLake directly into memory, with no scheduled refresh and no query translation to a source system. It delivers close to import-mode performance on large tables and falls back to DirectQuery when a query cannot be served.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890460464","position":9,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890460464","name":"How much does Microsoft Fabric cost?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Fabric is priced on capacity rather than per user. Capacities are named F followed by their capacity units, running from F2 upwards, and are bought pay as you go or reserved for a year at a discount. Prices vary by Azure region. Below the F64 tier, report viewers still need Power BI Pro licences.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890471788","position":10,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-fabric-features-guide#faq-question-1785890471788","name":"Do you need to know Python or SQL to use Microsoft Fabric?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"It depends on the role. Analysts can work entirely in Power BI, Dataflow Gen2 and the SQL analytics endpoint without Python. Data engineers generally need PySpark. Real-Time Intelligence requires KQL. Most teams need T-SQL and DAX as a minimum across the group.","inLanguage":"en-AU"},"inLanguage":"en-AU"}]}},"_links":{"self":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/2662","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/comments?post=2662"}],"version-history":[{"count":7,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/2662\/revisions"}],"predecessor-version":[{"id":2682,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/2662\/revisions\/2682"}],"wp:attachment":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=2662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=2662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=2662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}