Edit

Share via

What's new in Microsoft Fabric?

  • Article

This page is continuously updated with a recent review of what's new in Microsoft Fabric.

New to Microsoft Fabric?

Features currently in preview

The following table lists the features of Microsoft Fabric that are currently in preview. Preview features are sorted alphabetically.

Note

Features currently in preview are available under supplemental terms of use. Review for legal terms that apply to Azure features that are in beta, preview, or otherwise not yet released into general availability. Microsoft Fabric provides previews to give you a chance to evaluate and share feedback with the product group on preview features before they become generally available (GA).

Feature Learn more
AI functions (preview) AI functions for data engineering with GenAI are now in preview. With AI functions, you can harness the power of GenAI for summarization, classification, text generation, and so much more—all with a single line of code.
Approximate or fuzzy string matching (preview) In SQL database in Fabric, you can check if two strings are similar, and calculate the difference between two strings. Use this capability to identify strings that might be different because of character corruption. What is fuzzy string matching?
ArcGIS GeoAnalytics for Microsoft Fabric Spark (preview) Microsoft and Esri have partnered to bring spatial analytics into Microsoft Fabric. To learn more about ArcGIS integration within Microsoft Fabric Spark, see ArcGIS GeoAnalytics for Microsoft Fabric (preview) and ArcGIS in Fabric integrations.
AutoML code-first preview In Fabric Data Science, the new AutoML feature enables automation of your machine learning workflow. AutoML, or Automated Machine Learning, is a set of techniques and tools that can automatically train and optimize machine learning models for any given data and task type.
AutoML low code user experience in Fabric (preview) AutoML, or Automated Machine Learning, is a process that automates the time-consuming and complex tasks of developing machine learning models. The new low code AutoML experience supports a variety of tasks, including regression, forecasting, classification, and multi-class classification. To get started, Create models with Automated ML (preview).
Azure Data Factory item You can now bring your existing Azure Data Factory (ADF) to your Fabric workspace. This new preview capability allows you to connect to your existing Azure Data Factory from your Fabric workspace. CI/CD and REST APIs support is now available for the Azure Data Factory items in Microsoft Fabric.
Capacity pools preview Capacity administrators can now create custom pools (preview) based on their workload requirements, providing granular control over compute resources. Custom pools for Data Engineering and Data Science can be set as Spark Pool options within Workspace Spark Settings and environment items.
Centralized data governance in the OneLake catalog (preview) A new centralized data governance experience in the OneLake catalog is in preview. Data owners can view aggregated insights on the items they created, consider improving their governance by taking recommended actions, and access more information along with all available tools in Fabric.
Code-First Hyperparameter Tuning preview In Fabric Data Science, FLAML is now integrated for hyperparameter tuning, currently a preview feature. Fabric's flaml.tune feature streamlines this process, offering a cost-effective and efficient approach to hyperparameter tuning.
Copilot in Fabric is available worldwide Copilot in Fabric is now available to all customers, including Copilot for Power BI, Copilot for Data Factory, Copilot for Data Science & Data Engineering, and Copilot for Real-Time Intelligence. Read more in our Overview of Copilot in Fabric.
Copilot for Data Warehouse Chat (Preview) You will now see a Copilot button in the ribbon which will allow you to chat with Copilot for acceleration with any data warehousing task. For more information, see How to: Use the Copilot chat pane for Fabric Data Warehouse.
DacFx Integration for Warehouse ALM Simplify your warehouse ALM with DacFx integration in Git and deployment pipelines for Fabric Warehouse (preview). For more information, see Simplify your Warehouse ALM with DacFx integration in Git and Deployment Pipelines.
Dataflow Gen2 CI/CD support CI/CD and Git integration are now supported for Dataflow Gen2. For more information, see Dataflow Gen2 CI/CD support.
Data Wrangler for Spark DataFrames preview Data Wrangler on Spark DataFrames in preview. Users can now edit Spark DataFrames in addition to pandas DataFrames with Data Wrangler.
DATEADD number allows bigint (preview) In SQL database in Fabric, with DATEADD (datepart , number , date ) a number can be expressed as a bigint. For more information, see DATEADD (Transact-SQL).
Delta column mapping in the SQL analytics endpoint SQL analytics endpoint now supports Delta tables with column mapping enabled. For more information, see Delta column mapping and Limitations of the SQL analytics endpoint. This feature is currently in preview.
Enhanced conversation with Microsoft Fabric Copilot (Preview) We are introducing improvements to AI functionalities in Microsoft Fabric, including a new way to store chat prompts and history, improved accuracy of responses, and better context knowledge retention.
Environment sharing across workspaces (preview) You can now attach Environments from different workspaces in your Notebooks and Spark job definitions, as a preview feature. For more information, see Create, configure, and use an environment in Microsoft Fabric.
Eventhouse Query Acceleration for OneLake Shortcuts (Preview) Query Acceleration for OneLake Shortcuts in Eventhouse speeds up ad hoc queries over data in OneLake. OneLake shortcuts are references from an Eventhouse that point to internal Fabric or external sources. Previously, queries run over OneLake shortcuts were less performant than on data that is ingested directly to Eventhouses due to various factors.
Eventhouse Monitoring (preview) Eventhouse monitoring, currently in preview, offers multiple events and metrics that are automatically routed and stored in Workspace Monitoring. For more information, see Manage and monitor an eventhouse.
Eventstream processing and routing events to Activator (preview) Now, Eventstream supports processing and transforming events with business requirements before routing the events to the destination: Activator. When these transformed events reach Activator, you can establish rules or conditions for your alerts to monitor the events.
Fabric CLI The Fabric CLI (preview) is a developer-first, file-system-inspired terminal to explore and manage Microsoft Fabric. Get started at https://aka.ms/fabric-cli. Documentation is available at https://microsoft.github.io/fabric-cli/.
Fabric data agent integration with Azure AI Agent Service (Preview) We are excited to launch the integration of data agents in Fabric with Azure AI Agent Service from Azure AI Foundry. To get started, see Consume Fabric data agent (preview). The Fabric data agent SDK is also available in preview.
Fabric gateway enables OneLake shortcuts to on-premises data Connect to on-premises data sources with a Fabric on-premises data gateway on a machine in your environment, with networking visibility of your S3 compatible or Google Cloud Storage data source. Then, you create your shortcut and select that gateway. For more information, see Create shortcuts to on-premises data.
Fabric Spark connector for Fabric Data Warehouse in Spark runtime (preview) The Spark connector for Data Warehouse enables a Spark developer or a data scientist to access and work on data from a warehouse or SQL analytics endpoint of the lakehouse (either from within the same workspace or from across workspaces) with a simplified Spark API. For more information, see Spark Connector for Fabric Data Warehouse - Preview.
Fabric Spark Diagnostic Emitter (preview) The Fabric Apache Spark Diagnostic Emitter (preview) allows Apache Spark users to collect logs, event logs, and metrics from their Spark applications and send them to various destinations, including Azure Event Hubs, Azure storage, and Azure log analytics.
Fabric Spark Monitoring APIs (Preview) Fabric Spark Monitoring APIs, currently in preview, are a robust set of tools designed to enhance observability and streamline the monitoring and management of Spark applications within Microsoft Fabric.
Fabric SQL database (Preview) SQL database in Microsoft Fabric (Preview) is a developer-friendly transactional database, based on Azure SQL Database, that allow you to easily create your operational database in Fabric. SQL database in Fabric uses the SQL Database Engine as Azure SQL Database. Review a Decision guide: choose a SQL database.
Fabric User Data Functions Fabric User Data Functions (preview) let you create functions that contain business logic and connect to Fabric data sources, and/or invoke them from other Fabric items such as Data pipelines, Notebooks and Power BI reports. The Functions Hub provides a single location to view, access, and manage your User Data Functions. For more information, see What is Fabric User data functions (Preview)?.
Folder REST API (Preview) You can now create and manage workspace folders in automation scenarios and integrate with other systems and tools. The Folder Rest API is now in preview. To get started, see Fabric REST API Folders.
Iceberg data in OneLake using Snowflake and shortcuts (preview) You can now consume Iceberg-formatted data across Microsoft Fabric with no data movement or duplication, plus Snowflake has added the ability to write Iceberg tables directly to OneLake. For more information, see Use Iceberg tables with OneLake.
Invoke remote pipeline (preview) in Data pipeline You can now use the Invoke Pipeline (preview) activity to call pipelines from Azure Data Factory or Synapse Analytics pipelines. This feature allows you to utilize your existing ADF or Synapse pipelines inside of a Fabric pipeline by calling it inline through this new Invoke Pipeline activity.
JSON Aggregate support (preview) Fabric warehouses now support JSON aggregate functions in preview, JSON_ARRAYAGG and JSON_OBJECTAGG.
Lakehouse schemas feature (preview) The Lakehouse schemas feature (preview) introduces data pipeline support for reading the schema info from Lakehouse tables and supports writing data into tables under specified schemas. Lakehouse schemas allow you to group your tables together for better data discovery, access control, and more.
Lakehouse support for git integration and deployment pipelines (preview) The Lakehouse now integrates with the lifecycle management capabilities in Microsoft Fabric, providing a standardized collaboration between all development team members throughout the product's life. Lifecycle management facilitates an effective product versioning and release process by continuously delivering features and bug fixes into multiple environments.
Livy REST API (preview) The Fabric Livy endpoint lets users submit and execute their Spark code on the Spark compute within a designated Fabric workspace, eliminating the need to create a Notebook or Spark Job Definition item. The Livy API offers the ability to customize the execution environment through its integration with the Environment.
Load Fabric OneLake Data in Excel Easily load Fabric OneLake data into Excel with integrated OneLake catalog and modern Get Data experience (preview). For more information and steps to get started, see OneLake catalog and Get Data are integrated into Excel for Windows.
Managed virtual networks (preview) Managed virtual networks are virtual networks that are created and managed by Microsoft Fabric for each Fabric workspace.
Microsoft 365 connector now supports ingesting data into Lakehouse (preview) The Microsoft 365 connector now supports ingesting data into Lakehouse tables.
Microsoft Fabric Admin APIs Fabric Admin APIs are designed to streamline administrative tasks. The initial set of Fabric Admin APIs is tailored to simplify the discovery of workspaces, Fabric items, and user access details.
Microsoft Fabric SKU estimator (Preview) The Microsoft Fabric SKU estimator, now available in preview, is an enhanced version of the previously introduced Microsoft Fabric Capacity Calculator. For more information, see Introducing the Microsoft Fabric SKU estimator (Preview) and Mastering SKU Estimations with the Microsoft Fabric SKU Estimator.
Migration Assistant for Fabric Data Warehouse The new Migration Assistant simplifies the process of migrating from Azure Synapse Analytics to Fabric Data Warehouse. For more information, see Public Preview of Migration Assistant for Fabric Data Warehouse.
Mirroring in Microsoft Fabric (preview) With database mirroring in Fabric, you can easily bring your databases into OneLake in Microsoft Fabric, enabling seamless zero-ETL, near real-time insights on your data – and unlocking warehousing, BI, AI, and more. For more information, see What is Mirroring in Fabric?
Mirroring CI/CD (preview) Mirroring now supports CI/CD as a preview feature. You can integrate Git for source control and utilize ALM Deployment Pipelines, streamlining the deployment process and ensuring seamless updates to mirrored databases.
Notebook debug within vscode.dev (preview) You can now place breakpoints and debug your Notebook code with the Synapse VS Code - Remote extension in vscode.dev. This update first starts with the Fabric Runtime 1.3 (GA).
Notebook version history (preview) Fabric notebook version history provides robust built-in version control capabilities, including automatic and manual checkpoints, tracked changes, version comparisons, and previous version restore. For more information, see Notebook version history.
OneLake data access roles (preview) OneLake data access roles for lakehouse are in preview. Role permissions and user/group assignments can be easily updated through a new folder security user interface.
Open mirroring (Preview) Open mirroring enables any application to write change data directly into a mirrored database in Fabric, based on the open mirroring public APIs and approach. Open mirroring is designed to be extensible, customizable, and open. It's a powerful feature that extends mirroring in Fabric based on open Delta Lake table format. To get started, see Tutorial: Configure Microsoft Fabric open mirrored databases.
PostgreSQL Flexible Server mirroring to Fabric Fabric Database Mirroring now supports replication of your Azure Database for PostgreSQL Flexible Server as a preview feature. You can continuously replicate data in near real-time from your Flexible Server instance to Fabric OneLake. For more information, see Mirroring Azure Database for PostgreSQL flexible server.
Prebuilt Azure AI services in Fabric preview The preview of prebuilt AI services in Fabric is an integration with Azure AI services, formerly known as Azure Cognitive Services. Prebuilt Azure AI services allow for easy enhancement of data with prebuilt AI models without any prerequisites. Currently, prebuilt AI services are in preview and include support for the Microsoft Azure OpenAI Service, Azure AI Language, and Azure AI Translator.
Public parameter values to refresh a Dataflow Gen2 (Preview) Learn more about the new public parameters capability for Dataflow Gen2 with CI/CD support, as well as the support for this new mode within the Dataflow refresh activity in Data Pipelines.
Purview Data Loss Prevention policies have been extended to Fabric lakehouses Extending Microsoft Purview's Data Loss Prevention (DLP) policies into Fabric lakehouses is now in preview.
Purview Data Loss Prevention policies now support the restrict access action for semantic models Restricting access based on sensitive content for semantic models, now in preview, helps you to automatically detect sensitive information as it is uploaded into Fabric lakehouses and semantic models.
Python Notebook (preview) Python Notebooks are for BI Developers and Data Scientists working with smaller datasets using Python as their primary language. To get started, see Use Python experience on Notebook.
Real-Time Dashboards and underlying KQL databases access separation (preview) With separate permissions for dashboards and underlying data, administrators now have the flexibility to allow users to view dashboards without giving access to the raw data.
Regular expression functions (preview) In SQL database in Fabric, regular expression (REGEX) functions return text based on values in a search pattern. For more information, see Regular expressions.
Reserve maximum cores for jobs (preview) A new workspace-level setting allows you to reserve maximum cores for your active jobs for Spark workloads. For more information, see High concurrency mode in Apache Spark for Fabric.
REST APIs for connections and gateways (preview) REST APIs for connections and gateways are now in preview. These new APIs allow developers to programmatically manage and interact with connections and gateways within Fabric.
Secure Data Streaming with Managed Private Endpoints in Eventstream (Preview) By creating a Fabric Managed Private Endpoint, you can now securely connect Eventstream to your Azure services, such as Azure Event Hubs or IoT Hub, within a private network or behind a firewall. For more information, see Secure Data Streaming with Managed Private Endpoints in Eventstream (Preview).
Semantic model refresh activity (preview) Use the Semantic model refresh activity to refresh a Power BI Dataset (Preview), the most effective way to refresh your Fabric semantic models. For more information, see New Features for Fabric Data Factory Pipelines Announced at Ignite.
SET SHOWPLAN_XML support The SET SHOWPLAN_XML T-SQL syntax is now supported as a preview feature in Fabric Data Warehouse and SQL analytics endpoint. For more information, see SHOWPLAN_XML in Fabric Data Warehouse (preview).
Session Expiry Control in Workspace Settings for Notebook Interactive Runs (preview) A new session expiry control in Data Engineering/Science workspace settings allows you to set the maximum expiration time limit for notebook interactive sessions. By default, sessions expire after 20 minutes, but you can now customize the maximum expiration duration.
Share the Fabric AI skill (preview) Share capability for the Fabric AI skill (preview) allows you to share the AI Skill with others using a variety of permission models.
Solace PubSub+ Connector Seamlessly connect Fabric Eventstream with Solace PubSub+ (preview). For more information and steps to get started, see New Solace PubSub+ Connector: seamlessly connect Fabric Eventstream with Solace PubSub+ (Preview).
Spark Run Series Analysis preview The Spark Monitoring Run Series Analysis features allow you to analyze the run duration trend and performance comparison for Pipeline Spark activity recurring run instances and repetitive Spark run activities, from the same Notebook or Spark Job Definition.
Splunk add-on preview Microsoft Fabric add-on for Splunk allows users to ingest logs from Splunk platform into a Fabric KQL DB using the Kusto python SDK.
SQL database support for Tenant level private links (preview) You can use tenant level private links to provide secure access for data traffic in Microsoft Fabric, including SQL database (in preview). For more information, see Set up and use private links and Blog: Tenant Level Private Link (Preview).
Support for storage accounts behind a firewall for Mirrored Azure Databricks catalog items (Preview) Storage accounts behind a firewall for Mirrored Azure Databricks catalog items are now supported as a preview feature. You can securely access Unity Catalog data even when in ADLS accounts protected by a firewall.
Synapse Data Explorer to Eventhouse migration tooling (Preview) The next generation of Azure Synapse Data Explorer offering is evolving to become Eventhouse. To get started, see Migrate from Azure Synapse Data Explorer to Fabric Eventhouse (preview).
Task flows in Microsoft Fabric (preview) The preview of task flows in Microsoft Fabric is enabled for all Microsoft Fabric users. With Task flows (preview), when designing a data project, you no longer need to use a whiteboard to sketch out the different parts of the project and their interrelationships. Instead, you can use a task flow to build and bring this key information into the project itself.
varchar(max) and varbinary(max) support in preview Support for the varchar(max) and varbinary(max) data types in Fabric Data Warehouse is now in preview. For more information, see Announcing public preview of VARCHAR(MAX) and VARBINARY(MAX) types in Fabric Data Warehouse.
T-SQL support in Fabric notebooks (preview) The T-SQL notebook feature in Microsoft Fabric (preview) lets you write and run T-SQL code within a notebook. You can use them to manage complex queries and write better markdown documentation. It also allows direct execution of T-SQL on connected warehouse or SQL analytics endpoint. To learn more, see T-SQL support in Microsoft Fabric notebooks.
Variable libraries (preview) The Variable library is a new Fabric item that functions as a bucket of variables that can be consumed by other items in the workspace. It presents a unified approach for customers to efficiently manage item configurations within a workspace, ensuring scalability and consistency across different lifecycle stages. For more information, see Variable library (Preview).
Virtual network (VNet) Data Gateway support for Data Factory Virtual Network (VNet) Data Gateway support for Fabric Pipeline Copy, Fast Copy in Dataflow Gen2, and Copy Job is now in preview. For more information, see What is a virtual network (VNet) data gateway?
Warehouse source control (preview) Using Source control with Warehouse (preview), you can manage development and deployment of versioned warehouse objects. You can use SQL Database Projects extension available inside of Azure Data Studio and Visual Studio Code. For more information on warehouse source control, see CI/CD with Warehouses in Microsoft Fabric.
Workspace monitoring (preview) Workspace monitoring is a Microsoft Fabric database that collects data from a range of Fabric items in your workspace, and lets users access and analyze logs and metrics. For more about this feature, see Announcing preview of workspace monitoring.

Generally available features

The following table lists the features of Microsoft Fabric that have recently transitioned from preview to general availability (GA).

Month Feature Learn more
April 2025 Session-scoped distributed #temp tables Distributed session-scoped temporary tables in Fabric Data Warehouse and Fabric Lakehouse SQL analytics endpoints are now generally available. Now, #temp tables are supported as session scoped or local temp tables.
April 2025 BULK INSERT support The T-SQL BULK INSERT statement in Fabric Data Warehouse is now generally available. For more information, see BULK INSERT statement is generally available.
April 2025 Multi-tenant organization (MTO) Support for multitenant organizations in Fabric is now generally available (GA). Microsoft Entra ID users of type external member are supported across the Fabric platform.
April 2025 Tags Tags help admins categorize and organize data, enhancing the searchability of your data and boosting success rates and efficiency for end users. Tags in Microsoft Fabric are now generally available.
April 2025 OneLake SAS Support for short-lived, user-delegated OneLake SAS is now generally available. This functionality allows applications to request a User Delegation Key backed by Microsoft Entra ID, and then use this key to construct a OneLake SAS token. This token can be handed off to provide delegated access to another tool, node, or user, ensuring secure and controlled access.
April 2025 Data pipeline capabilities in Copilot for Data Factory Data pipeline capabilities in Copilot for Data Factory are now generally available. These features function as an AI expert to help users build, troubleshoot, and maintain data pipelines.
April 2025 Copy job The Copy job item in Data Factory is now generally available. Copy Job has advantages over the Copy activity. To get started, see Learn how to create a Copy job (preview) in Data Factory for Microsoft Fabric.
April 2025 CI/CD for Fabric Data Pipelines Git Integration and integration with built-in Deployment Pipelines to Data Factory data pipelines is now generally available. For more information, see CI/CD for Data pipelines and REST API capabilities for Data pipelines.
April 2025 Data Factory Apache Airflow jobs Apache Airflow job in Data Factory, powered by Apache Airflow, are now generally available. An Apache Airflow Job in Microsoft Fabric offers seamless authoring, scheduling, and monitoring experience for Python-based data processes defined as Directed Acyclic Graphs (DAGs). For more information, see Quickstart: Create an Apache Airflow Job.
April 2025 High concurrency mode for Notebooks in Pipelines High concurrency mode for notebooks in pipelines, now generally available, enables users to share Spark sessions across multiple notebooks within a pipeline. With high concurrency mode, users can trigger pipeline jobs, and these jobs are automatically packed into existing high concurrency sessions.
April 2025 OPENROWSET support The T-SQL OPENROWSET(BULK) function is now generally available in Fabric warehouse. For more examples, see Browse file content using OPENROWSET function. For more information, see OPENROWSET function in Fabric Data Warehouse now generally available.
March 2025 Terraform provider GA The Terraform Provider for Microsoft Fabric is now generally available, enabling seamless infrastructure management and automation. For more information, use cases, and benefits, see Terraform Provider for Microsoft Fabric (Generally Available).
February 2025 REST APIs for Fabric Data Factory pipelines The Fabric data pipeline public REST API enables you to extend the built-in capability in Fabric to create, read, update, delete, and list pipelines.
February 2025 Copy job The Copy job in Data Factory has advantages over the Copy activity. For more information, see What is the Copy Job in Microsoft Fabric. For a tutorial, see Learn how to create a Copy job in Data Factory for Microsoft Fabric.
February 2025 Nested Common Table Expressions (CTEs) (GA) Fabric Data Warehouse and SQL analytics endpoint both support standard, sequential, and nested CTEs as generally available features now. For more information, see nested common table expressions (CTE) in Fabric data warehousing (Transact-SQL).
January 2025 Real-time intelligence ALM and REST API GA Application Lifecycle Management (ALM) and Fabric REST APIs are now generally available for all RTI items: Eventstream, Eventhouse, KQL Database, Realtime dashboard, Query set and Data Activator. ALM includes both deployment pipelines and Git integration. REST APIs allow you to programmatically create / read / update / delete items.
January 2025 Warehouse restore points and restore in place You can now create restore points and perform an in-place restore of a warehouse to a past point in time. Restore in-place is an essential part of data warehouse recovery, which allows to restore the data warehouse to a prior known reliable state by replacing or over-writing the existing data warehouse from which the restore point was created.
December 2024 Folder in Workspace As an organizational unit, the workspace folder addresses this pain point by providing a hierarchical structure for organizing and managing your items. This feature is now generally available, and includes new filter features. For more information, see Create folders in workspaces.

For older general availability (GA) announcements, review the Microsoft Fabric What's New archive.

Community

This section summarizes new Microsoft Fabric community opportunities for prospective and current influencers and MVPs.

Month Feature Learn more
February 2025 Hack Together: The Microsoft Data + AI Kenya Hack To join the Hack Together: The Microsoft Data + AI Kenya Hack from March 12th to April 11th, form a team of 3 members and register at https://aka.ms/data-ai-hack-kenya/register.
December 2024 Announcing the winners of the Microsoft Fabric and AI Learning Hackathon! See the winners of the Microsoft Fabric Focused Hackathon event, where we partnered with DevPost to challenge the world to build the next wave of innovative AI powered data analytics applications with Microsoft Fabric!

For older updates, review the Microsoft Fabric What's New archive.

Power BI

Important

If you're accessing Power BI on a web browser version older than Chrome 94, Microsoft Edge 94, Safari 16.4, Firefox 93, or equivalent, you need upgrade your web browser to a newer version by August 31, 2024. Using an outdated browser version after this date can prevent you from accessing features in Power BI.

Updates to Power BI Desktop and the Power BI service are summarized at What's new in Power BI?

Microsoft Copilot in Microsoft Fabric

With Copilot and other generative AI features in preview, Microsoft Fabric brings a new way to transform and analyze data, generate insights, and create visualizations and reports. For more information, see Overview of Copilot in Fabric.

Month Feature Learn more
March 2025 Copilot and AI capabilities for all paid SKUs Copilot and AI capabilities are now accessible to all paid SKUs in Microsoft Fabric. For more information, see Copilot and AI Capabilities Now Accessible to All Paid SKUs in Microsoft Fabric and Fabric Copilot capacity.
February 2025 Enhanced conversation with Microsoft Fabric Copilot (Preview) We are introducing improvements to AI functionalities in Microsoft Fabric, including a new way to store chat prompts and history, improved accuracy of responses, and better context knowledge retention.

For older updates, review the Microsoft Fabric What's New archive.

Data Factory in Microsoft Fabric

This section summarizes recent new features and capabilities of Data Factory in Microsoft Fabric. Follow issues and feedback through the Data Factory Community Forum.

Month Feature Learn more
April 2025 Passing parameter values to refresh a Dataflow Gen2 (Preview) Learn more about the new public parameters capability for Dataflow Gen2 with CI/CD support, as well as the support for this new mode within the Dataflow refresh activity in Data Pipelines.
April 2025 On-premises data gateway April 2025 release The on-premises data gateway (version 3000.266) now supports the time data type, Teradata support in Fabric Pipeline Copy Activity, and Power BI Desktop Compatibility.
April 2025 Recap of Data Factory Announcements at Fabric Conference US 2025 Read more for a recap of Data Factory in Fabric announcements.
April 2025 Data pipeline capabilities in Copilot for Data Factory Data pipeline capabilities in Copilot for Data Factory are now generally available. These features function as an AI expert to help users build, troubleshoot, and maintain data pipelines.
April 2025 Copy job The Copy job item in Data Factory is now generally available. Copy Job has advantages over the Copy activity. To get started, see Learn how to create a Copy job (preview) in Data Factory for Microsoft Fabric.
April 2025 CI/CD for Fabric Data Pipelines Git Integration and integration with built-in Deployment Pipelines to Data Factory data pipelines is now generally available. For more information, see CI/CD for Data pipelines and REST API capabilities for Data pipelines.
April 2025 Incremental refresh for Dataflow Gen2 (GA) Incremental refresh in Dataflow Gen2 is designed to optimize data ingestion and transformation, particularly as your data continues to expand. For more information, see Incremental Refresh for Dataflow Gen2 is now generally available.
April 2025 Latest innovations in Data Factory in Fabric Read for more information on Lakehouse connector deletion vector, Salesforce and Snowflake connectors, and new certified connectors.
April 2025 Virtual network (VNet) Data Gateway support Virtual Network (VNET) Data Gateway support for Fabric Pipeline Copy, Fast Copy in Dataflow Gen2, and Copy Job is now in preview. For more information, see What is a virtual network (VNet) data gateway?
April 2025 Data Factory Apache Airflow jobs Apache Airflow job in Data Factory, powered by Apache Airflow, are now generally available. An Apache Airflow Job in Microsoft Fabric offers seamless authoring, scheduling, and monitoring experience for Python-based data processes defined as Directed Acyclic Graphs (DAGs). For more information, see Quickstart: Create an Apache Airflow Job.
April 2025 High concurrency mode for Notebooks in Pipelines High concurrency mode for notebooks in pipelines, now generally available, enables users to share Spark sessions across multiple notebooks within a pipeline. With high concurrency mode, users can trigger pipeline jobs, and these jobs are automatically packed into existing high concurrency sessions.
March 2025 Fabric Data Factory and Roadmap Discover the latest updates and future plans for Fabric Data Factory, including new features for data integration and orchestration. For more information, see What's New with Fabric Data Factory and Roadmap.
March 2025 REST APIs for Fabric Data Factory pipelines The Fabric data pipeline public REST API enables you to extend the built-in capability in Fabric to create, read, update, delete, and list pipelines.
March 2025 Copy job (preview) The Copy job in Data Factory has advantages over the Copy activity. For more information, see What is the Copy Job in Microsoft Fabric. For a tutorial, see Learn how to create a Copy job in Data Factory for Microsoft Fabric.
March 2025 Copy Job enhancements Learn more about three new user experience improvements in the Data Factory Copy Job.
January 2025 Dataflow Gen2 CI/CD support (preview) CI/CD and Git integration are now supported for Dataflow Gen2, as a preview feature. For more information, see Dataflow Gen2 CI/CD support.
December 2024 Data Factory Announcements at Ignite 2024 Recap A couple of weeks ago we had such an exciting week for Fabric during the Ignite Conference, filled with several product announcements and sneak previews of upcoming new features for Data Factory in Fabric.

For older updates, review the Microsoft Fabric What's New archive.

Data Factory in Microsoft Fabric samples and guidance

Month Feature Learn more
April 2025 Metadata-driven Lakehouse implementation Learn how to design and implement an end-to-end metadata-driven Lakehouse using Microsoft Fabric.
March 2025 Build RAG Data pipeline from Azure Blob Storage to SQL Database in minutes This blog post will provide step-by-step instructions for creating a Retrieval Augmented Generation (RAG) pipeline to prepare your data for AI integration using SQL database in Microsoft Fabric.
January 2025 Enhancing data quality with Copilot for Data Factory Read this blog for a guide on using Copilot for Data Factory to clean and transform data.

Fabric Data Engineering

This section summarizes recent new features and capabilities of the Data Engineering workload in Microsoft Fabric.

Month Feature Learn more
April 2025 Purview DLP Policies with Restrict Access for Fabric Lakehouses (Preview) Microsoft Purview's Data Loss Prevention (DLP) policies can now restrict access in Fabric Lakehouses.
April 2025 OneLake SAS Support for short-lived, user-delegated OneLake SAS is now generally available. This functionality allows applications to request a User Delegation Key backed by Microsoft Entra ID, and then use this key to construct a OneLake SAS token. This token can be handed off to provide delegated access to another tool, node, or user, ensuring secure and controlled access.
April 2025 Row-level and Column-level security in Spark Row and column level security for Spark within Microsoft Fabric are now available. This update significantly enhances data governance by incorporating fine-grained security controls within Spark.
April 2025 Environment sharing across workspaces (preview) You can now attach Environments from different workspaces in your Notebooks and Spark job definitions, as a preview feature. For more information, see Create, configure, and use an environment in Microsoft Fabric.
April 2025 OPTIMIZE FAST and FSCK commands in Fabric Runtime 1.3 for Apache Spark The Spark SQL FSCK REPAIR TABLE command and fast OPTIMIZE for V-Order are now available on Fabric Runtime 1.3 (Spark 3.5 / Delta 3.2). For more information, see Fabric Runtime 1.3 (GA).
April 2025 Fabric Spark Monitoring APIs (Preview) Fabric Spark Monitoring APIs, currently in preview, are a robust set of tools designed to enhance observability and streamline the monitoring and management of Spark applications within Microsoft Fabric.
April 2025 Fabric User Data Functions (preview) Fabric User Data Functions let you create functions that contain business logic and connect to Fabric data sources, and/or invoke them from other Fabric items such as Data pipelines, Notebooks and Power BI reports. The Functions Hub provides a single location to view, access, and manage your User Data Functions. For more information, see What is Fabric User data functions (Preview)?.
April 2025 Azure Key Vault and AWS KMS for S3 support for OneLake shortcuts OneLake shortcuts now support Azure Key Vault and AWS KMS for S3 buckets. OneLake shortcuts now support connecting to Azure Key Vault references for ADLS Gen2 and S3 buckets secured with AWS KMS.
April 2025 OneLake shortcuts Fabric SQL databases OneLake shortcuts now support connections to Fabric SQL databases, allowing users to seamlessly integrate SQL data into their unified data lake environment using the OneLake catalog explorer.
April 2025 CI/CD support OneLake shortcuts OneLake shortcuts now support batch creation via the API and management with CI/CD.
April 2025 High concurrency mode for Notebooks in Pipelines High concurrency mode for notebooks in pipelines, now generally available, enables users to share Spark sessions across multiple notebooks within a pipeline. With high concurrency mode, users can trigger pipeline jobs, and these jobs are automatically packed into existing high concurrency sessions.
April 2025 Supercharge your workloads: write-optimized default Spark configurations in Microsoft Fabric With predefined Spark resource profiles, it's easier than ever for data engineers to optimize their compute configurations based on workload needs. For more information, see Supercharge your workloads: write-optimized default Spark configurations.
March 2025 Enhancing AI productivity in Fabric Notebooks The latest Copilot updates improve productivity with in-cell interactions, better code generation, and seamless integration with Fabric. For more information, see What's New in Copilot updates for Fabric notebooks.
March 2025 Autoscale billing for Spark The new autoscale billing model offer greater flexibility and cost efficiency for Spark workloads. For more information, see Introducing Autoscale Billing for Spark in Microsoft Fabric.
February 2025 T-SQL notebook enhancements The T-SQL notebook now includes more T-SQL code snippets, easy open within Excel, traceability of the warehouse, and CI/CD support. For more information, see T-SQL notebook enhancements.
February 2025 Centralized data governance in the OneLake catalog (preview) A new centralized data governance experience in the OneLake catalog is in preview. Data owners can view aggregated insights on the items they created, consider improving their governance by taking recommended actions, and access more information along with all available tools in Fabric.
February 2025 Managed private endpoint and private link support for Native Execution Engine in Spark Private Links and Managed Private Endpoints are now supported for Native Execution Engine. Learn more about the Native execution engine for Fabric Spark.
February 2025 Capacity settings include option to Disable Starter Pool New controls in Data Engineering/Science Capacity settings include the option to Disable Starter Pool for workspaces, to help capacity admins have better compute restrictions on workspaces attached to their Fabric Capacity.
February 2025 Monitoring for high concurrency in T-SQL notebooks New features like log segmentation and auto-mapping of jobs, stages, and tasks in Notebooks allow for better tracking and troubleshooting of high concurrency Notebook executions.
February 2025 Enhancements to support additional notebook run scenarios Support for notebook runs triggered by NotebookUtils, snapshots for running notebooks, and Enhanced visibility into parallel notebook runs have been introduced.
February 2025 Fabric Spark Resource Analysis The Fabric Spark Resource Utilization Analysis feature provides in-depth insights into your Apache Spark applications within Microsoft Fabric. For more information, see Monitor Apache Spark applications resource utilization.
February 2025 AI functions (preview) AI functions for data engineering with GenAI are now in preview. With AI functions, you can harness the power of GenAI for summarization, classification, text generation, and so much more—all with a single line of code.
February 2025 Fabric Spark connector for Fabric Data Warehouse in Spark runtime (preview) The Spark connector for Data Warehouse enables a Spark developer or a data scientist to access and work on data from a warehouse or SQL analytics endpoint of the lakehouse (either from within the same workspace or from across workspaces) with a simplified Spark API. For more information, see Spark Connector for Fabric Data Warehouse - Preview.
February 2025 ArcGIS GeoAnalytics for Microsoft Fabric Spark (preview) Microsoft and Esri have partnered to bring spatial analytics into Microsoft Fabric. To learn more about ArcGIS integration within Microsoft Fabric Spark, see ArcGIS GeoAnalytics for Microsoft Fabric (preview) and ArcGIS in Fabric integrations.
February 2025 What's new in OneLake catalog: Data governance and more Read more about recent OneLake improvements involving the Catalog, data governance, personalized insights and actions, and more.
January 2025 Simplified enablement and transition to Runtime 1.3 from Runtime 1.2 We recommend upgrading to Runtime 1.3 to maintain support, as native acceleration will soon be unavailable on Runtime 1.2. Now, activating Native Execution Engine on Runtime 1.3 is as easy as a switch. You'll find the new toggle button in the Acceleration tab within your environment settings.
January 2025 Notebook and Spark Job definition execution with service principal You can now run a Notebook/Spark Job Definition execution under the credentials of a service principal. Use the Fabric Job Scheduler API with a service principal's access token, to run the Spark Job within the security context of that service principal.
January 2025 Building Apps with Microsoft Fabric API for GraphQL Microsoft Fabric has an API for GraphQL to build your data applications, enabling you to pull data from sources such as Data Warehouses, Lakehouse, Mirrored Databases, and DataMart in Microsoft Fabric.
January 2025 Efficient log management with Microsoft Fabric For a tutorial and walkthrough of efficient log files collection processing and analysis with Real-Time Intelligence, read this new blog post on Efficient log management with Microsoft Fabric.
January 2025 Folder security within a shortcut in OneLake Now you can define security on any subfolder within the shortcut root. For more information and an example, see Define security on folders within a shortcut using OneLake data access roles.
December 2024 REST API for Livy (preview) The Fabric Livy endpoint lets users submit and execute their Spark code on the Spark compute within a designated Fabric workspace, eliminating the need to create a Notebook or Spark Job Definition items. The Livy API offers the ability to customize the execution environment through its integration with the Environment.
December 2024 Notebook version history (preview) Fabric notebook version history provides robust built-in version control capabilities, including automatic and manual checkpoints, tracked changes, version comparisons, and previous version restore. For more information, see Notebook version history.
December 2024 Python Notebook (preview) Python Notebooks are for BI Developers and Data Scientists working with smaller datasets using Python as their primary language. To get started, see Use Python experience on Notebook.

For older updates, review the Microsoft Fabric What's New archive.

Fabric Data Engineering samples and guidance

Month Feature Learn more
April 2025 Build data-driven agents with curated data from OneLake In this blog post, learn why Fabric and OneLake are the ideal data tools to fuel your AI projects in AI Foundry.
April 2025 Best practices for Microsoft Fabric GraphQL API performance Explore best practices for your Fabric GraphQL API. Whether you're handling complex queries or optimizing response times, these strategies will help you get the best performance out of your GraphQL implementation.
April 2025 Develop, test and deploy a user data functions in Microsoft Fabric using Visual Studio Code Fabric User data functions is a platform that allows you to host and run serverless functions on Fabric. Developers can write custom logic and embed it into their Fabric ecosystem. For a sample walkthrough, see Develop, test and deploy a user data functions in Microsoft Fabric using Visual Studio Code.
April 2025 Common use cases for building solutions with Microsoft Fabric User data functions (UDFs) Learn more about User data functions (UDFs) in Fabric and how they can make your data processes and pipelines super-efficient.
April 2025 Building an analytical web application with Microsoft Fabric In this blog post, dive into the architecture of an analytical application powered by Microsoft Fabric and provide a step-by-step guide on how to build it.
April 2025 Metadata-driven Lakehouse implementation Learn how to design and implement an end-to-end metadata-driven Lakehouse using Microsoft Fabric.
March 2025 Simplify Data Transformation and Management with Copilot for Data Factory Discover how Copilot for Data Factory streamlines data transformation and management, enhancing efficiency and productivity. Learn more about Simplify Data Transformation and Management with Copilot for Data Factory.
March 2025 Virtualize your Cloudera/Hadoop data estate into Fabric OneLake with Apache Ozone Learn more about a sample architecture using Microsoft Fabric OneLake shortcuts to virtualize data from Cloudera/Apache Ozone, using the OneLake S3 Compatible Shortcut.
March 2025 Unlock the power of your Iceberg data in OneLake It's easy to get started with OneLake's Iceberg table format support. Learn how to bring your Iceberg data to Fabric.
February 2025 New lakehouse samples Two familiar Lakehouse samples, WideWorldImporters and NYC Taxi, are designed to support deeper analysis and flexibility for both schema-enabled and non-schema Lakehouses.
February 2025 Build a python app with Fabric API for GraphQL Fabric API for GraphQL brings GraphQL experience within Fabric to securely and efficiently access the data in Fabric items such as databases or warehouses. Learn how to build a Python application using Flask framework to connect to Fabric SQL database and query data.
February 2025 Streamline Data Engineering & Data Science with Copilot in Fabric Contoso Retailers, a fictitious company, wants to learn how they can unlock the full potential of their data science and data engineering efforts with Copilot for Data Science and Data Engineering using Fabric.
February 2025 Private ADLS Gen2 access made easy with OneLake Shortcuts: a step-by-step guide How can you use your existing ADLS Gen2 data lake with private storage accounts? The solution is Trusted Workspace Access, which allows secure shortcuts to data in ADLS Gen2 even when protected by a firewall or when public access is entirely disabled.
January 2025 Create a shortcut to a VPC-protected Google Cloud Storage bucket Follow this guide to create a OneLake shortcut to a VPC-protected Google Cloud Storage (GCS) bucket.
January 2025 Best practices for Fabric API for GraphQL The Microsoft Fabric API for GraphQL is a handy service that quickly allows you to set up a GraphQL API to pull data from places like warehouses, the lakehouse, and mirrored databases. Learn best practices when building applications using Fabric API for GraphQL.
December 2024 Troubleshooting Fabric Spark application without production workspace access You have Fabric Spark Notebooks deployed in a production workspace, but you don't have direct access to it. The production support team reports that a Fabric Spark job has failed in the production workspace, and you need to analyze the logs to troubleshoot the issue. To troubleshoot Spark applications, Spark engineers typically use the Spark UI, which provides details of Jobs, Stages, Storage, Environment, Executors, and SQL.

Fabric Data Science

This section summarizes recent improvements and features for Data Science in Microsoft Fabric.

Month Feature Learn more
April 2025 Fabric data agent integration with Azure AI Agent Service (Preview) We are excited to launch the integration of data agents in Fabric with Azure AI Agent Service from Azure AI Foundry. To get started, see Consume Fabric data agent (preview). The Fabric data agent SDK is also available in preview.
April 2025 High concurrency mode for Notebooks in Pipelines High concurrency mode for notebooks in pipelines, now generally available, enables users to share Spark sessions across multiple notebooks within a pipeline. With high concurrency mode, users can trigger pipeline jobs, and these jobs are automatically packed into existing high concurrency sessions.
March 2025 Enhancing AI productivity in Fabric Notebooks The latest Copilot updates improve productivity with in-cell interactions, better code generation, and seamless integration with Fabric. For more information, see What's New in Copilot updates for Fabric notebooks.
February 2025 Capacity settings include option to Disable Starter Pool New controls in Data Engineering/Science Capacity settings includes the option to Disable Starter Pool for workspaces, to help capacity admins have better compute restrictions on workspaces attached to their Fabric Capacity.
February 2025 AI functions (preview) AI functions for data engineering with GenAI are now in preview. With AI functions, you can harness the power of GenAI for summarization, classification, text generation, and so much more—all with a single line of code.
February 2025 ArcGIS GeoAnalytics for Microsoft Fabric Spark (preview) Microsoft and Esri have partnered to bring spatial analytics into Microsoft Fabric. To learn more about ArcGIS integration within Microsoft Fabric Spark, see ArcGIS GeoAnalytics for Microsoft Fabric (preview) and ArcGIS in Fabric integrations.
February 2025 Fabric Catalyst Portal The Fabric Catalyst Portal is collaborative knowledge hub designed to empower our partners with best practices, technical guidance, and real-world insights to accelerate Microsoft Fabric adoption. Registration for Microsoft partners is open. The first guidance is focused on Real-Time Intelligence.
January 2025 Building Apps with Microsoft Fabric API for GraphQL Microsoft Fabric has an API for GraphQL to build your data applications, enabling you to pull data from sources such as Data Warehouses, Lakehouse, Mirrored Databases, and DataMart in Microsoft Fabric.
December 2024 Notebook version history Fabric notebook version history provides robust built-in version control capabilities, including automatic and manual checkpoints, tracked changes, version comparisons, and previous version restore. For more information, see Notebook version history.
December 2024 Python Notebook (preview) Python Notebooks are for BI Developers and Data Scientists working with smaller datasets using Python as their primary language. To get started, see Use Python experience on Notebook.

For older updates, review the Microsoft Fabric What's New archive.

Fabric Data Science samples and guidance

Month Feature Learn more
February 2025 Streamline Data Engineering & Data Science with Copilot in Fabric Contoso Retailers, a fictitious company, wants to learn how they can unlock the full potential of their data science and data engineering efforts with Copilot for Data Science and Data Engineering using Fabric.

Fabric Databases

This section summarizes recent improvements and features for Microsoft Fabric Databases.

Month Feature Learn more
April 2025 Power BI Desktop connection to SQL database in Fabric You can now use the OneLake catalog or Get Data experiences in Power BI Desktop to create reports on data from your SQL database in Microsoft Fabric. This Power BI Desktop feature is currently in preview. To get started, see Create simple reports on your SQL database in Power BI.
April 2025 OneLake shortcuts Fabric SQL databases OneLake shortcuts now support connections to Fabric SQL databases, allowing users to seamlessly integrate SQL data into their unified data lake environment using the OneLake catalog explorer.
March 2025 Backup storage billing Starting April 1, backup storage billing begins for SQL database in Microsoft Fabric. For more information, see Backup Storage Billing for SQL Database in Microsoft Fabric.
March 2025 SQL database enabled by default on March 28 SQL database in Fabric will be enabled for all users in your tenant on March 28. For more information and potential opt-out, see default checkbox changes on tenant settings for SQL database in Fabric.
February 2025 Approximate or fuzzy string matching (preview) Check if two strings are similar, and calculate the difference between two strings. Use this capability to identify strings that might be different because of character corruption. What is fuzzy string matching?
February 2025 DATEADD number allows bigint (preview) For DATEADD (datepart , number , date ), number can be expressed as a bigint. For more information, see DATEADD (Transact-SQL).
February 2025 Regular expression functions (preview) Regular expression (REGEX) functions return text based on values in a search pattern. For more information, see Regular expressions.
January 2025 SQL database support for tenant level private links (preview) You can use tenant level private links to provide secure access for data traffic in Microsoft Fabric, including SQL database (in preview). For more information, see Set up and use private links and Blog: Tenant Level Private Link (Preview).
January 2025 SQL databases billing begins After February 1, 2025, compute and data storage for SQL database are charged to your Fabric capacity. Additionally, backup billing will start after April 1, 2025. For more information, see Activation of billing for SQL database in Fabric.
January 2025 Ask the Experts – Fabric Databases – Livestream January 29! Join us for a live Q&A session on the new Fabric Databases experience! Our product engineering team will answer your top questions in real time.
December 2024 Copilot for SQL database Learn more about the Copilot integration for Query Editor. Copilot for SQL database in Fabric as an AI-powered assistant designed to support you regardless of your SQL expertise or role.

Fabric Database samples and guidance

Month Feature Learn more
March 2025 Build RAG Data pipeline from Azure Blob Storage to SQL Database in minutes This blog post will provide step-by-step instructions for creating a Retrieval Augmented Generation (RAG) pipeline to prepare your data for AI integration using SQL database in Microsoft Fabric.
February 2025 Build a python app with Fabric API for GraphQL Fabric API for GraphQL brings GraphQL experience within Fabric to securely and efficiently access the data in Fabric items like databases or warehouses. Learn how to build a Python application using Flask framework to connect to Fabric SQL database and query data.
February 2025 Why SQL database in Fabric is the best choice for low-code/no-code Developers In this blog post, we will explore why SQL database in Fabric is uniquely suited for low-code/no-code developers.
February 2025 Govern your data in SQL database in Microsoft Fabric with protection policies in Microsoft Purview Microsoft Purview's protection policies help you safeguard sensitive data in Microsoft Fabric items, including SQL databases. Learn how Purview policies override Microsoft Fabric item permissions for users, apps, and groups, limiting their actions within the database.
February 2025 ICYMI: Ask the Expert – Fabric Databases Here's a few great questions and answers about SQL database in Fabric from a recent Ask the Expert session on Microsoft Reactor.
January 2025 Manage access in SQL database with SQL native authorization controls A follow-up to Learn how to manage Microsoft Fabric access controls in SQL database, learn how to manage access for your SQL database with SQL native access controls. SQL database in Microsoft Fabric supports two different sets of authorization controls, Microsoft Fabric access controls and SQL native access controls.
January 2025 Monitor SQL Database usage and consumption by using capacity metrics app Learn how the capacity metrics app can be used for monitoring usage and consumption of SQL databases in Fabric.
January 2025 Performance Dashboard tutorial For a complete walkthrough of performance troubleshooting in SQL database in Microsoft Fabric with the Performance Dashboard, see Speed up your SQL databases with the Performance Dashboard.
January 2025 Manage access for SQL databases in Microsoft Fabric with workspace roles and item permissions SQL database (preview) supports two different sets of controls that allow you to manage access for your databases: Microsoft Fabric access controls and SQL native access controls. Learn how to manage Microsoft Fabric access controls in SQL database.
December 2024 Source control integration for SQL database SQL database in Fabric has a tightly integrated and fully extensible DevOps feature set, including a source control integration for GitHub and Azure DevOps. Learn how to use the Fabric web-based development environment with the git repository directly through a streamlined source control panel.
December 2024 Tour the Query Editor in SQL database in Microsoft Fabric Whether you're a seasoned data professional or a developer new to SQL, the query editor offers features that cater to all skill levels. For more information, see Query with the SQL query editor.

Fabric Data Warehouse

This section summarizes recent improvements and features for Fabric Data Warehouse.

Month Feature Learn more
April 2025 Session-scoped distributed #temp tables Distributed session-scoped temporary tables in Fabric Data Warehouse and Fabric Lakehouse SQL analytics endpoints are now generally available. Now, #temp tables are supported as session scoped or local temp tables.
April 2025 BULK INSERT The T-SQL BULK INSERT statement in Fabric Data Warehouse is now generally available. For more information, see BULK INSERT statement is generally available.
April 2025 Microsoft Purview Data Loss Prevention policies for Fabric Microsoft Purview's Data Loss Prevention (DLP) policies now support Fabric KQL and mirrored databases. Using DLP policies, security admins will be able to define policies which will scan data uploaded to KQL DBs or Mirrored DBs (including Snowflake, Azure and more).
April 2025 SQL Audit Logs SQL Audit Logs provide a comprehensive and immutable record of all database activities, capturing critical details such as the event timestamp, the user or process that triggered the action, and the executed T-SQL statements. For more information, see Introducing SQL Audit Logs for Fabric Data Warehouse.
April 2025 OPENROWSET support (preview) The T-SQL OPENROWSET(BULK) function is now generally available in Fabric warehouse. For more examples, see Browse file content using OPENROWSET function (Preview). For more information, see OPENROWSET function in Fabric Data Warehouse now generally available.
March 2025 Open Mirroring UI enhancements and CSV support The release of support for CSV formats for Open Mirroring allows you to upload CSV files in addition to parquet files when using the API or user experience. For more information, see Open Mirroring UI enhancements and CSV support.
March 2025 Mirroring updates to support firewalls, CI/CD, and more Discover the many enhancements recently introduced to Fabric Mirroring. Database Mirroring now supports firewall connectivity for Azure SQL Database with On-Premises Data Gateway.
March 2025 Mirrored PostgreSQL Flexible Server (preview) Fabric Database Mirroring now supports replication of your Azure Database for PostgreSQL Flexible Server as a preview feature. You can continuously replicate data in near real-time from your Flexible Server instance to Fabric OneLake. For more information, see Mirroring Azure Database for PostgreSQL flexible server.
March 2025 Migration Assistant for Fabric Data Warehouse The new Migration Assistant simplifies the process of migrating from Azure Synapse Analytics to Fabric Data Warehouse. For more information, see Public Preview of Migration Assistant for Fabric Data Warehouse.
March 2025 Hints support Fabric Data Warehouse now supports some T-SQL Query and Join hints. For more information, see What are hints?
February 2025 Support for storage accounts behind a firewall for Mirrored Azure Databricks catalog items (Preview) Storage accounts behind a firewall for Mirrored Azure Databricks catalog items are now supported as a preview feature. You can securely access Unity Catalog data even when it is stored in ADLS accounts protected by a firewall.
February 2025 T-SQL notebook enhancements The T-SQL notebook now includes more T-SQL code snippets, easy open within Excel, traceability of the warehouse, and CI/CD support. For more information, see T-SQL notebook enhancements.
February 2025 COLLATE support The T-SQL COLLATE clause is now supported. For more information, see COLLATE (Transact-SQL).
February 2025 Copilot for Data Warehouse Chat (Preview) You will now see a Copilot button in the ribbon which will allow you to chat with Copilot for acceleration with any data warehousing task. For more information, see How to: Use the Copilot chat pane for Fabric Data Warehouse.
February 2025 Nested Common Table Expressions (CTEs) (GA) Fabric Warehouse and SQL analytics endpoint both support standard, sequential, and nested CTEs as generally available features now. For more information, see nested common table expressions (CTE) in Fabric data warehousing (Transact-SQL).
February 2025 Fabric Spark connector for Fabric Data Warehouse in Spark runtime (preview) The Spark connector for Data Warehouse enables a Spark developer or a data scientist to access and work on data from a warehouse or SQL analytics endpoint of the lakehouse (either from within the same workspace or from across workspaces) with a simplified Spark API. For more information, see Spark Connector for Fabric Data Warehouse - Preview.
February 2025 OPENROWSET and BULK INSERT support (preview) The T-SQL OPENROWSET(BULK) function is now available in Fabric warehouse as a preview feature. For more information and examples, see Browse file content using OPENROWSET function (Preview). For more information, see BULK INSERT statement in Fabric Data Warehouse and Fabric OPENROWSET preview.
February 2025 Open Mirroring for SAP sources – dab and Simplement With open mirroring, data replication is an extensible platform that partners and customers can use to plug in their own data integration capabilities. Once data is brought in through open mirroring, it can be used in all Fabric workloads. Two partners have now taken the next step in integrating with open mirroring, and are ready to onboard customers.
January 2025 Source schema support in Mirroring in Fabric Mirroring in Fabric now supports replicating the source schema hierarchy. For more information, see Mirroring now supports replicating source schemas.
January 2025 Delta column mapping support for Mirroring Mirroring in Fabric now supports Delta column mapping. Column mapping is a feature of Delta tables that allows users to include spaces and special characters such as '``,``;``{``}``(``)``\n``\t``=``.``' in column names. For more information, see Delta column mapping support.
January 2025 Mirroring CI/CD (preview) Mirroring now supports CI/CD as a preview feature. You can integrate Git for source control and utilize ALM Deployment Pipelines, streamlining the deployment process and ensuring seamless updates to mirrored databases.
January 2025 COPY INTO operations with row count check The COPY INTO now allows you to control the behavior of your data ingestion jobs by checking if the count of columns in the source data matches the count of columns on your target table, with the MATCH_COLUMN_COUNT argument.
January 2025 Default schema in a warehouse You can now change the default schema for users in Fabric Data Warehouse, using the ALTER USER statement, ensuring that every user has a predefined schema context when they connect to the database.
January 2025 Data Insights now includes Data Scanned and CPU time analytics New columns are available in the queryinsights.exec_requests_history system view to determine if large data scans are contributing to slower query execution. For more information, see Query insights in Fabric data warehousing.
January 2025 JSON Aggregate support (preview) Fabric warehouses now support JSON aggregate functions in preview, JSON_ARRAYAGG and JSON_OBJECTAGG.
January 2025 SET SHOWPLAN_XML support The SET SHOWPLAN_XML T-SQL syntax is now supported as a preview feature in Fabric Data Warehouse and SQL analytics endpoint. For more information, see SHOWPLAN_XML in Fabric Data Warehouse (preview).
January 2025 Service principal support Service principal (SPN) support Fabric warehouse items allows developers and administrators to automate processes, streamline operations, and increase security for their data workflows. For more information, see Service principal support for Fabric Data Warehouse.
January 2025 Warehouse restore points and restore in place You can now create restore points and perform an in-place restore of a warehouse to a past point in time. Restore in-place is an essential part of data warehouse recovery, which allows to restore the data warehouse to a prior known reliable state by replacing or over-writing the existing data warehouse from which the restore point was created.
January 2025 COPY INTO operations with granular permissions Enhancements to the COPY INTO T-SQL command in Fabric Data Warehouse introduce granular SQL controls. For more information, see Enhancing COPY INTO operations with Granular Permissions.
December 2024 What's new in the Fabric SQL analytics endpoint? There are several updates to improve both functionality and user experience with the SQL analytics endpoint, including metadata sync, last successful update, improved error propagation, and more.

For older updates, review the Microsoft Fabric What's New archive.

Fabric Data Warehouse samples and guidance

Month Feature Learn more
April 2025 Build a Data Warehouse schema with Copilot for Data Warehouse Learn how Contoso Retailers uses Copilot for Data Warehouse to gain insights into their data, identify key drivers of sales fluctuations, and make more informed, data-driven decisions.
April 2025 Be a performance detective with Query Insights Query Insights in Microsoft Fabric serves as a centralized repository, storing 30 days of historical query data. Learn how to use the system views and practical applications of Query Insights.
April 2025 Understand item permissions in Fabric Data Warehouse Learn more about the need for item permissions, what permissions can be assigned to users, and how to implement them effectively.
March 2025 DacFx Integration for Warehouse ALM Simplify your warehouse ALM with DacFx integration in Git and deployment pipelines for Fabric Warehouse (preview). For more information, see Simplify your Warehouse ALM with DacFx integration in Git and Deployment Pipelines.
March 2025 Spatial queries samples in a warehouse Fabric Data Warehouse supports two primary spatial data types, geometry and geography. Learn more about the spatial capabilities in Fabric Data Warehouse.
February 2025 Build a python app with Fabric API for GraphQL Fabric API for GraphQL brings GraphQL experience within Fabric to securely and efficiently access the data in Fabric items like databases or warehouses. Learn how to build a Python application using Flask framework to connect to Fabric SQL database and query data.
January 2025 Best practices for Fabric API for GraphQL The Microsoft Fabric API for GraphQL is a handy service that quickly allows you to set up a GraphQL API to pull data from places like warehouses, the lakehouse, and mirrored databases. Learn best practices when building applications using Fabric API for GraphQL.
December 2024 Microsoft Fabric API for GraphQL™ for Azure Cosmos DB Mirroring Learn how to integrate Azure Cosmos DB and the Microsoft Fabric API for GraphQL™ to build near real-time analytical applications. For more information on how to leverage Fabric API for GraphQL in your applications, see Connect applications to Fabric API for GraphQL.

Real-Time Intelligence in Microsoft Fabric

This section summarizes recent improvements and features for Real-Time Intelligence in Microsoft Fabric.

Month Feature Learn more
April 2025 Microsoft Purview Data Loss Prevention policies for Fabric Microsoft Purview's Data Loss Prevention (DLP) policies now support Fabric KQL and mirrored databases. Using DLP policies, security admins will be able to define policies which will scan data uploaded to KQL DBs or Mirrored DBs (including Snowflake, Azure and more).
April 2025 Permission model changes for OneLake events in Fabric Real-Time Hub Going forward, users with the new SubscribeOneLakeEvents permission will be able to subscribe to OneLake events. For more information, see Announcing permission model changes for OneLake events in Fabric Real-Time Hub.
April 2025 New Eventstream sources Read more about the new Eventstream sources now available, including MQTT, Solace PubSub+, Azure Data Explorer, Weather, and Azure Event Grid.
April 2025 CI/CD and REST APIs for Fabric Eventstream Eventstream CI/CD and REST APIs are now generally available. You can programmatically create, manage, and update Eventstream items. For more information, see Eventstream CI/CD and Fabric REST APIs for Eventstream.
April 2025 Azure and Fabric Events With Azure and Fabric Events, you can integrate event-driven solutions into workflows. Azure and Fabric Events allow you to ingest system events like OneLake events and Azure blob storage events, and deliver those events to consumers in Microsoft Fabric like Activator.
April 2025 Synapse Data Explorer to Eventhouse migration tooling (Preview) The next generation of Azure Synapse Data Explorer offering is evolving to become Eventhouse. To get started, see Migrate from Azure Synapse Data Explorer to Fabric Eventhouse (preview).
March 2025 Solace PubSub+ Connector Seamlessly connect Fabric Eventstream with Solace PubSub+ (preview). For more information and steps to get started, see New Solace PubSub+ Connector: seamlessly connect Fabric Eventstream with Solace PubSub+ (Preview).
March 2025 Unlock the power of Real-time Intelligence in the Era of AI Read more about why Fabric Real-Time Intelligence is a game-changer.
March 2025 New sources for Fabric event streams The following new event sources are supported for Fabric event streams: MQTT, Real-time weather, Azure Data Explorer, Solace PubSub+, Azure Event Grid namespace. The following event sets are added as sample data sources: Buses, S&P 500 companies stocks.
February 2025 Configure latency of Eventhouse OneLake Eventhouse's adaptive mechanism can delay writing operations if there isn't enough data to create optimal Parquet files. This delay is now configurable. For more information, see Eventhouse OneLake Availability.
February 2025 Real-Time Dashboard & Power BI templates for Eventhouse Monitoring Real-Time Dashboard and Power BI Templates designed to provide an out-of-the-box graphical management experience. With these templates you can easily monitor your query performance and data ingestions. You can enable workspace monitoring, download the templates, and view a demo in the fabric-toolbox GitHub repository.
February 2025 New Real-Time Dashboard customization features New customization features give real-time dashboard authors and viewers more control over visuals, layout, and performance, including more control, better usability, and improved performance.
February 2025 New and improved Data Source Tree in KQL Queryset The enhanced Data Source Tree now shows all other data sources previously connected in your Queryset, including Fabric (Eventhouse/KQL database) and Azure sources (Azure Data Explorer, Application Insights, Log Analytics clusters).
February 2025 Data exploration is now available for raw KQL table data We've made it even easier to explore your data – no code required – with the Explore Data feature, now available in additional places across the user interface.
February 2025 Eventhouse OneLake availability migration A system migration for OneLake Availability is occurring starting April 9, 2025. This will not have any effect on accessing the data within your Eventhouse, it will only affect the delta parquet files made available via the OneLake Availability feature.
January 2025 Real-time intelligence ALM and REST API GA Application Lifecycle Management (ALM) and Fabric REST APIs are now generally available for all RTI items: Eventstream, Eventhouse, KQL Database, Realtime dashboard, Query set and Data Activator. ALM includes both deployment pipelines and Git integration. REST APIs allow you to programmatically create / read / update / delete items.
December 2024 Eventhouse Monitoring (preview) Eventhouse monitoring in preview offers multiple events and metrics that are automatically routed and stored in Workspace Monitoring. For more information, see Manage and monitor an eventhouse.
December 2024 All Real-Time Intelligence items supported for ALM and REST API Fabric Real-Time Intelligence items (Eventstream, Eventhouse, KQL Database, Realtime Dashboard, Query set & Activator) support Application Lifecycle Management (ALM) and REST API capabilities.
December 2024 Eventhouse Query Acceleration for OneLake Shortcuts (Preview) Query Acceleration for OneLake Shortcuts in Eventhouse speeds up ad hoc queries over data in OneLake. OneLake shortcuts are references from an Eventhouse that point to internal Fabric or external sources. Previously, queries run over OneLake shortcuts were less performant than on data that is ingested directly to Eventhouses due to various factors.

For older updates, review the Microsoft Fabric What's New archive.

Real-Time Intelligence samples and guidance

Tip

Use the Real-Time Intelligence end-to-end sample solution to automatically create a collection of sample components.

Month Feature Learn more
April 2025 Understanding Real-Time Intelligence CDC connector for PostgreSQL database Understand important points to keep in mind when using PostgreSQL database CDC in Eventstream.
April 2025 Implementing proactive monitoring with KQL query alerts with Activator Within an Eventhouse and Eventstream, stream real-time data into your KQL database and set alerts on KQL queries. For an example of the fictional Constoso Retailers company, see Implementing proactive monitoring with KQL query alerts with Activator.
April 2025 Seamlessly connect Azure Logic Apps to Fabric Eventstream using Managed Identity In this blog, we'll compare Microsoft Entra ID and SAS Keys auth in Eventstream, explore use cases, and walk through how to connect Azure Logic Apps to Eventstream using managed identity authentication.
February 2025 Operational Reporting with Microsoft Fabric Real-Time Intelligence This architecture blog details how you can report faster than a typical modern data warehouse with Fabric Real-Time Intelligence.
February 2025 Real-Time Intelligence End-to-End Sample As a demonstration of an RTI end-to-end scenario, we've created Fabric Notebook that can deploy this in a matter of minutes. For more information, see RTI End-to-End Sample.
February 2025 Template dashboards for Workspace Monitoring Ready-to-use Power BI and real-time dashboard template reports are available for workspace monitoring in Microsoft Fabric.
January 2025 Efficient log management with Microsoft Fabric For a tutorial and walkthrough of efficient log files collection processing and analysis with Real-Time Intelligence, read this new blog post on Efficient log management with Microsoft Fabric.
December 2024 Automate Real-Time Intelligence Eventstream deployment using PowerShell Learn how to build a PowerShell script to automate the deployment of Eventstream with the definition of source, processing, and destination into a workspace in Microsoft Fabric.
December 2024 Monitor Fabric Spark applications using Fabric Real-Time Intelligence Learn how to build a centralized Spark monitoring solution, leveraging Fabric Real-Time Intelligence. To do this, integrate a Fabric Spark data emitter directly with Fabric Eventstream and Eventhouse to build a centralized Spark monitoring solution.
December 2024 Easily recreate your ADX dashboards as Real-Time Dashboards You can bring ADX dashboards into Microsoft Fabric without relocating your data. Learn how to create Real-Time Dashboards as copies of your ADX dashboards in Fabric.
December 2024 Enhance fraud detection with Activator Activator allows you to monitor events, detect certain conditions on your data and act on them by sending alerts. Learn how to implement a system that sends teams or email alerts when a transaction is flagged as potentially fraudulent.
December 2024 Manual Migration needed for Activator preview items If you created an item while Activator was in preview, you'll need to manually migrate these items to GA to get access to all the new features.
December 2024 Understanding Real-Time Intelligence usage reporting and billing Learn about Real-Time Intelligence Eventstream, Eventhouse, storage, Fabric Events and Activator consumption utilization, capacity meters, and costs.

Microsoft Fabric platform features

News and feature announcements about the Microsoft Fabric platform experience.

Month Feature Learn more
April 2025 Item limits in a Fabric workspace As of April 10, 2025, Microsoft Fabric has implemented updates to the total number of items permissible in a workspace. This change introduces a combined limit of 1,000 Fabric items (including Power BI items) per workspace.
April 2025 Microsoft Fabric SKU estimator (Preview) The Microsoft Fabric SKU estimator, now available in preview, is an enhanced version of the previously introduced Microsoft Fabric Capacity Calculator. For more information, see Introducing the Microsoft Fabric SKU estimator (Preview) and Mastering SKU Estimations with the Microsoft Fabric SKU Estimator.
April 2025 Microsoft Fabric Extensions Read for a summary of extensions for Visual Studio Code (VS Code) that help you manage Fabric artifacts and build analytical applications, including extensions, user data functions, and an upcoming feature roadmap.
April 2025 Content Sharing Report (Preview) The new Content Sharing report provides a comprehensive view of item access within the Fabric tenant. For more information, see Blog: Content Sharing Report (Preview).
April 2025 Variable libraries (preview) The Variable library is a new Fabric item that functions as a bucket of variables that can be consumed by other items in the workspace. It presents a unified approach for customers to efficiently manage item configurations within a workspace, ensuring scalability and consistency across different lifecycle stages. For more information, see Variable library (Preview).
April 2025 Multi-tenant organization (MTO) Support for multitenant organizations in Fabric is now generally available (GA). Microsoft Entra ID users of type external member are supported across the Fabric platform.
April 2025 Tags Tags help admins categorize and organize data, enhancing the searchability of your data and boosting success rates and efficiency for end users. Tags in Microsoft Fabric are now generally available.
April 2025 Folder REST API (Preview) You can now create and manage workspace folders in automation scenarios and integrate with other systems and tools. The Folder Rest API is now in preview. To get started, see Fabric REST API Folders.
April 2025 Workload Development Kit OneLake support In the Workload Development Kit, all items now support storing data in OneLake. For more information, see Microsoft Fabric Workload Development Kit.
April 2025 Fabric CLI The Fabric CLI (preview) is a developer-first, file-system-inspired terminal to explore and manage Microsoft Fabric. Get started at https://aka.ms/fabric-cli. Documentation is available at https://microsoft.github.io/fabric-cli/.
March 2025 Terraform provider GA The Terraform Provider for Microsoft Fabric is now generally available, enabling seamless infrastructure management and automation. For more information, use cases, and benefits, see Terraform Provider for Microsoft Fabric (Generally Available).
March 2025 Load Fabric OneLake Data in Excel Easily load Fabric OneLake data into Excel with integrated OneLake catalog and modern Get Data experience (preview). For more information and steps to get started, see OneLake catalog and Get Data are integrated into Excel for Windows.
March 2025 Empowering agentic AI Integrating Fabric with Azure AI Foundry enables businesses to create custom conversational AI agents leveraging domain expertise. For more information, see Empowering Agentic AI by Integrating Fabric with Azure AI Foundry.
March 2025 External data sharing enhancements External data sharing enables Fabric users to seamlessly share data across tenant boundaries while maintaining a single logical copy. Learn about service principal support for the external data sharing API and upcoming improvements.
February 2025 Capacities Management APIs Learn more about a new set of ARM APIs for comprehensive management of Fabric capacities.
February 2025 Cross-region deployments Fabric Deployment pipelines APIs now include a new feature for managing cross-region deployments.
February 2025 Admin API updates and upcoming definition changes SPN/MI support for Admin APIs and new GET/POST Admin APIs have been announced, among other changes and performance updates to Fabric Admin APIs.
February 2025 TLS deprecation for Fabric Fabric Platform support for Transport Layer Security (TLS) 1.1 and earlier versions will end on July 31, 2025. For more information, see Deprecating TLS 1.0 and 1.1 in Power BI.
February 2025 Microsoft Fabric Quotas Microsoft Fabric Quotas are a new feature designed to control resource governance for the acquisition of your Microsoft Fabric capacities. Fabric quotas aimed at helping customers ensure that Fabric resources are used efficiently and help manage the overall performance and reliability of the Azure platform while preventing misuse.
February 2025 Fabric Catalyst Portal The Fabric Catalyst Portal is collaborative knowledge hub designed to empower our partners with best practices, technical guidance, and real-world insights to accelerate Microsoft Fabric adoption. Registration for Microsoft partners is open. The first guidance is focused on Real-Time Intelligence.
February 2025 How can I decide which protection method to use to protect my sensitive data in Fabric? Learn more about when to use Purview DLP restrict access vs. Purview Protection Policies? Learn more about different protection options in Fabric.
February 2025 Understanding GraphQL API error handling Learn more about error handling in GraphQL and some best practices for managing errors effectively.
February 2025 Billing for Workspace monitoring Workspace Monitoring (preview) is an observability feature within Fabric that enables monitoring capabilities. For more information, see Announcing preview of workspace monitoring. Billing for this feature starts March 10, 2025.
January 2025 Building Apps with Microsoft Fabric API for GraphQL Microsoft Fabric has an API for GraphQL to build your data applications, enabling you to pull data from sources such as Data Warehouses, Lakehouse, Mirrored Databases, and DataMart in Microsoft Fabric.
January 2025 Power BI Embedded with Direct Lake Mode (Preview) Power BI Embedded with Direct Lake Mode is designed to enhance how developers and Independent Software Vendors (ISVs) provide embedded analytics in their applications. For more information, see Introducing Power BI Embedded with Direct Lake Mode (Preview).
January 2025 Fabric Copilot capacity: Democratizing AI usage in Microsoft Fabric Fabric Copilot capacity us a new billing feature designed to enhance your experience with Microsoft Fabric. With Fabric Copilot capacities, capacity admins can give Copilot access to end users directly, rather than requiring creators to move their content into a specific workspace or link a specific capacity.
January 2025 Efficient log management with Microsoft Fabric For a tutorial and walkthrough of efficient log files collection processing and analysis with Real-Time Intelligence, read this new blog post on Efficient log management with Microsoft Fabric.
January 2025 Surge protection (preview) With surge protection (preview), capacity admins can set limits on background usage within a capacity. Learn more about surge protection to help protect capacities from excess usage by background workloads.
December 2024 Microsoft Fabric approved as a Service within the FedRAMP High Authorization for Azure Commercial Microsoft Fabric is now included within the US Federal Risk and Authorization Management Program (FedRAMP) High Authorization for Azure Commercial. This Provisional Authorization to Operate (P-ATO) within the existing FedRAMP High Azure Commercial environment was approved by the FedRAMP Joint Authorization Board (JAB).
December 2024 Folder in Workspace As an organizational unit, the workspace folder addresses this pain point by providing a hierarchical structure for organizing and managing your items. This feature is now generally available, and includes new filter features. For more information, see Create folders in workspaces.

For older updates, review the Microsoft Fabric What's New archive.

Continuous Integration/Continuous Delivery (CI/CD) in Microsoft Fabric

This section includes guidance and documentation updates on development process, tools, source control, and versioning in the Microsoft Fabric workspace.

Month Feature Learn more
April 2025 CI/CD support OneLake shortcuts OneLake shortcuts now support batch creation via the API and management with CI/CD.
April 2025 CI/CD and REST APIs for Fabric Eventstream Eventstream CI/CD and REST APIs are now generally available. You can programmatically create, manage, and update Eventstream items. For more information, see Eventstream CI/CD and Fabric REST APIs for Eventstream.
February 2025 Fabric CI/CD Python library Deployment Tool The Fabric CI/CD Python library fabric-cicd is an open-source solution based on our experience using Fabric as the backbone of our platform.

For older updates, review the Microsoft Fabric What's New archive.

Continuous Integration/Continuous Delivery (CI/CD) samples

Month Feature Learn more
April 2025 Optimizing for CI/CD in Microsoft Fabric Learn about Fabric CI/CD strategy, how to implement it, how to scale it, and more item-specific tips in this blog post, Optimizing for CI/CD in Microsoft Fabric.

Related content