Edit

Share via


What's new in Microsoft Fabric?

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 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. Learn more about recent improvements to AI functions during the current preview.
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 various tasks, including regression, forecasting, classification, and multi-class classification. To get started, Create models with Automated ML (preview).
Azure Blob Storage in OneLake shortcut type (preview) You can now create shortcuts to Azure Blob Storage in OneLake, making it easier to integrate and access blob data in Microsoft Fabric. For more information, see Create an Azure Blob Storage shortcut (preview).
Azure Key Vault references to authenticate to Fabric data connections (preview) You can now authenticate to Fabric data connections using Azure Key Vault stored secrets (preview). Azure Key Vault references enable secure and centralized secret management for your data connections. For more information, see Azure Key Vault references overview (preview) and get started at Configure Azure Key Vault references.
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.
Continuous ingestion from Azure Storage to Eventhouse (preview) You can now use continuous ingestion from Azure Storage to Eventhouse (preview) to automatically and efficiently ingest data from Azure Storage into Eventhouse. For more information, see Get data from Azure Storage.
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 Writing KQL Queries. Read more in our Overview of Copilot in Fabric.
Copilot for Data Warehouse Chat preview You'll now see a Copilot button in the ribbon that starts a 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.
Copilot for SQL analytics endpoint (preview) The Copilot for SQL analytics endpoint introduces Copilot capabilities for the SQL analytics endpoint, enabling users to generate and optimize SQL queries using natural language. For more information, see Copilot for SQL analytics endpoint.
Copy job support for change data capture (CDC) (preview) Change Data Capture (CDC) in Copy Job is a powerful capability in Data Factory Data pipelines that enables efficient and automated replication of changed data including inserted, updated, and deleted records from a source to a destination.
Customer-managed keys for Fabric workspaces (preview) Workspace customer-managed keys allow you to encrypt data in OneLake using your own keys. For more information, see Customer Managed Keys in OneLake: Strengthening Data Protection and Control.
DacFx Integration for Warehouse ALM Simplify your warehouse application lifecycle management (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 Public APIs (preview) Data Factory APIs enable users to automate and manage dataflows, including creation, management, scheduling, and monitoring. For more information, see Use public parameters in Dataflow Gen2 (preview).
Dataflow Gen2 parameterization (preview) Data Factory parameterization makes workflows more efficient and adaptable to varying inputs and scenarios. For more information, see Use public parameters in Dataflow Gen2 (preview).
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.
Digital twin builder (preview) Digital twin builder (preview) is a new item within the Real-Time Intelligence workload. Digital twins create data-driven, real-time representations of entities. It's a data modeling item that creates digital representations of real-world environments, to optimize physical operations using data. For more information, see What is digital twin builder (preview)?.
Encrypt data at rest using customer-managed keys (preview) By default, Fabric encrypts all data at rest using Microsoft-managed keys. You can now encrypt data at rest in your Fabric workspaces using customer-managed keys, as a preview feature, giving you greater control over data security and compliance. For more information, see Customer-managed keys for Fabric workspaces.
Enhanced conversation with Microsoft Fabric Copilot (preview) We're 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.
Evaluate your Fabric data agents with the Python SDK (preview) You can now use the Python SDK to programmatically evaluate Fabric data agents. For more information, see Consume Fabric data agent (preview).
Eventstream processing and routing events to Activator (preview) Now, Fabric 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.
Eventstream Derived Streams in Direct Ingestion mode (preview) You can ingest data from a Fabric Eventstream to Eventhouse seamlessly either from an eventstream or using Eventhouse Get Data Wizard. This capability is now being extended to support eventstream derived streams in direct ingestion mode. For more information, see Fabric Eventhouse now supports Eventstream Derived Streams in Direct Ingestion mode (preview).
Data source instructions in Fabric Data Agent Data Source Instructions in the Fabric Data Agent help you get more precise, relevant answers from your structured data. For more information, see New in Fabric Data Agent: Data source instructions for smarter, more accurate AI responses.
Fabric data agent integration with Azure AI Agent Service (preview) We're 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 data agent integration with Microsoft Copilot Studio (preview) Fabric data agent is available in preview and can be added as an agent to your custom setup in Microsoft Copilot Studio. For more information, see Fabric data agent integration with Microsoft Copilot Studio (preview).
Fabric data factory Upsert table action in the Lakehouse Connector (preview) The Upsert (Preview) table action in the Lakehouse Connector is in 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 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.
Inline code completion in Fabric notebooks (preview) Fabric notebooks with inline code completion helps users write code faster and with fewer errors. For more information, see Copilot for Data Science and Data Engineering (preview).
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.
Lakehouse as an incremental refresh destination in Dataflow Gen2 (preview) For scenarios when you need to refresh only new or updated data, you can now enable incremental data refresh from a Lakehouse in Dataflow Gen2 for Microsoft Fabric Data Factory. For more information, see Incremental refresh in Dataflow Gen2.
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. Lakehouse 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.
Materialized Lake views (preview) Materialized Lake Views were announced at Build 2025. Materialized Lake Views in Microsoft Fabric enable fast and efficient querying of data stored in OneLake.
MCP Support for Real-Time Intelligence (preview) Model Context Protocol (MCP) is now supported for Real-Time Intelligence (RTI)The open-source MCP server enables AI agents or AI applications to interact with Fabric RTI by providing tools through the MCP interface, allowing for seamless data querying and analysis capabilities.
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 (preview) 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. This enables seamless, zero-ETL, near real-time insights on your data. Some mirroring sources are generally available, some are still in preview. For more information, see What is Mirroring in Fabric?
Notebook Copilot inline code completion (preview) Now in preview, Copilot Inline Code Completion (Preview) is an AI feature that assists data scientists and engineers in writing Python code more quickly and easily. For more information, see Notebook Copilot inline code completion (Preview).
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).
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.
OpenAI plugins for Eventhouse (preview) You can now use two powerful AI plugins for Eventhouse: AI Embed Text Plugin and AI Chat Completion Prompt Plugin. Connect Eventhouse data to OpenAI-powered applications for advanced analytics and AI scenarios. For more information, see ai_embed_text (preview) and ai_chat_completion (preview).
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 API capabilities for Dataflows Gen2 in Fabric Data Factory (preview) This preview of the Dataflows Gen 2 public APIs enables users to create, update, and monitor their data workflows programmatically. The APIs support a wide range of operations including dataflows CRUD (Create, Read, Update, and Delete), scheduling, and monitoring, making it easier for users to manage their data integration processes.
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.
Refresh SQL analytics endpoint metadata with REST API (preview) You can now refresh SQL endpoint metadata via REST API. To learn more, see Refresh SQL analytics endpoint Metadata REST API (Preview).
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.
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.
Scalar user-defined functions (UDFs) Scalar user-defined functions (UDFs) are now supported as a preview feature. For more information, see CREATE FUNCTION for Fabric Data Warehouse.
Result set caching (preview) Result set caching works by persisting the final result sets for applicable SELECT T-SQL queries, bypassing complex compilation and data processing of the original query to return queries faster. For more information, see Result Set Caching for Microsoft Fabric Data Warehouse (preview).
Secure mirrored Azure Databricks data with OneLake security (preview) You can secure mirrored Azure Databricks data in Fabric using OneLake security, now a feature in preview. You can now map Unity Catalog (UC) policies to Microsoft OneLake security. For more information, see Automatic identity managed in Azure Databricks.
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).
Share the Fabric AI skill (preview) Share capability for the Fabric AI skill (preview) allows you to share the AI Skill with others using various permission models.
SharePoint files as a destination in Dataflow Gen2 (preview) You can now configure dataflow queries to output data into specific folders within SharePoint. For more information, see Dataflow Gen2 data destinations and managed settings.
Shortcut transformations (preview) Shortcut transformations let you automatically transform data as you bring it into OneLake or move it between OneLake data items.
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.
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).
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).
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.
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, and is integrated with notebooks. For more information, see Variable library (preview) and Notebook integration with variable libraries.
Virtual network Data Gateway support for Data Factory Virtual Network 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 data gateway?
Warehouse snapshots (preview) Warehouse snapshots are a point-in-time, read-only representation of your data warehouse. You can create a snapshot of your warehouse at any point in the past 30 days, connect to it and query it just like a warehouse, and "roll forward" your snapshot regularly. To get started, see Create and manage a warehouse snapshot.
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
July 2025 Mirrored Azure Databricks Mirrored Azure Databricks catalogs to Fabric are now generally available. A mirrored Unity Catalog in Fabric enables customer to read data managed by Unity Catalog from Fabric workloads. Storage accounts behind a firewall are also generally available.
June 2025 Secure Data Streaming with Managed Private Endpoints in Fabric Eventstream GA By creating a Fabric Managed Private Endpoint in Fabric Eventstream (now generally available), 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 Fabric Eventstream (preview).
June 2025 Notebook version history GA 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.
June 2025 T-SQL notebooks GA The T-SQL notebook feature is now generally available. You can use T-SQL notebooks to write and run T-SQL code, manage complex queries, and write better markdown documentation. The new monitoring experience includes a new Recent run panel and a dedicated T-SQL panel to list the query history. To learn more, see T-SQL support in Microsoft Fabric notebooks.
June 2025 Azure database for PostgreSQL connector 2.0 The Azure database for PostgreSQL connector version 2.0 is now generally available. This new version is enhanced to support TLS 1.3, the upset table action, as well as the script activity in data pipeline.
June 2025 Incremental Copy GA, Lakehouse Upserts, and New Connectors Incremental copy is now generally available, you can now choose to merge data directly into more destination stores, and more connectors with Copy job are now available. For more information, see Simplifying Data Ingestion with Copy job.
June 2025 Capacity pools Capacity administrators can now create custom pools 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.
June 2025 Boost performance effortlessly with Automated Table Statistics in Fabric Spark Automated Table Statistics are now generally available, automatically optimizing query performance by maintaining up-to-date statistics in Fabric Spark. For more information, see Configure and manage Automated Table Statistics in Fabric Spark.
May 2025 Azure Data Factory item in Microsoft Fabric Azure Data Factory is now generally available in Microsoft Fabric allows you to seamlessly connect your existing Azure Data Factory (ADF) pipelines to Fabric workspaces, eliminating the need to manually rebuild or migrate them. CI/CD and REST APIs support is also for the Azure Data Factory items in Microsoft Fabric.
May 2025 Fabric CLI The Fabric CLI (fab) is a fast, file‑system‑inspired command‑line interface for Microsoft Fabric. Explore, automate, and script your Fabric environment—right from your terminal. Get started at https://aka.ms/FabCLI.
May 2025 Eventhouse Query Acceleration for OneLake Shortcuts [Query Acceleration for OneLake Shortcuts in Eventhouse]https://blog.fabric.microsoft.com/blog/eventhouse-accelerated-onelake-table-shortcuts-generally-available?ft=All) 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 more information, see Query acceleration for OneLake shortcuts - overview.
May 2025 Task flows in Microsoft Fabric With Task flows, now generally available, 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. For more information, see Task flows in Microsoft Fabric (Generally Available).
May 2025 Microsoft Fabric Spark Native Execution Engine now generally available The Microsoft Fabric Spark Native Execution Engine is now generally available as part of Fabric Runtime 1.3 and provides improved performance and efficiency for Spark workloads in Microsoft Fabric. For more information, see Native execution engine for Fabric Spark.
May 2025 Dataflow Gen2 CI/CD support CI/CD and Git integration are now supported for Dataflow Gen2 as a generally available feature. For more information, see Dataflow Gen2 CI/CD support.
May 2025 OneLake shortcut cache and on-premises gateway support now generally available Shortcut cache and on-premises gateway support is now generally available. Use OneLake shortcut cache to quickly and easily source data from external cloud providers. The on-premises gateway allows you to securely connect to your data through multiple network restricted scenarios. For more information, see Create shortcuts to on-premises data.
May 2025 Open mirroring 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, now generally available, 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.
May 2025 JSON Aggregate support Fabric warehouses now support JSON aggregate functions as generally available features. For more information, see JSON_ARRAYAGG and JSON_OBJECTAGG.
May 2025 Semantic model refresh activity Use the Semantic model refresh activity to refresh a Power BI Dataset, the most effective way to refresh your Fabric semantic models. For more information, see Semantic Model Refresh Activity (Generally Available).
April 2025 Fabric Spark connector for Fabric Data Warehouse in Spark runtime The Spark connector for Data Warehouse, now generally available, 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.
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. For more information, see Tables in Fabric Data Warehouse.
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 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).

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
June 2025 Chart your course as a Microsoft Fabric Data Engineer with curated skilling and certifications Fabric Data Engineers design and manage advanced data solutions, ensuring that businesses can use their data effectively. Learn more about becoming a Fabric Data Engineer, and Elevate your Microsoft Fabric data engineering skills: Prepare for DP-700 Exam.
May 2025 Announcing the winners of Hack Together: The Microsoft Data & AI Kenya Hack Announcing the winners of Hack Together: The Microsoft Data & AI Kenya Hack! Congratulations to all the creative, innovative, and inspiring projects built by the Data & AI community in Kenya!
May 2025 Power Designer Power Designer, now generally available at powerbi.tips/PowerDesigner, is sleek, intuitive, and fun, making designing reports feel less like work and more like unleashing your inner artist.

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.

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
June 2025 On-premises data gateway June 2025 release New features of on-premises data gateway (version 3000.274) include the Azure database for PostgreSQL connector version 2.0, enhanced data type support in the Fabric Data Warehouse connector, and a new Upsert table action in the Lakehouse Connector (preview).
June 2025 Incremental Copy GA, Lakehouse Upserts, and New Connectors Incremental copy is now generally available, you can now choose to merge data directly into more destination stores, and more connectors with Copy job are now available. For more information, see Simplifying Data Ingestion with Copy job.
May 2025 New pipeline activities support for on-premises data gateway and vNet data gateway Fabric Data Factory pipelines now support the on-premises data gateway and Virtual Network Gateway for activity types Web, Webhook, Azure Functions, and User Data Functions.
May 2025 Azure Data Factory item in Microsoft Fabric Azure Data Factory is now generally available in Microsoft Fabric allows you to seamlessly connect your existing Azure Data Factory (ADF) pipelines to Fabric workspaces, eliminating the need to manually rebuild or migrate them.
May 2025 On-premises data gateway May 2025 release The on-premises data gateway (version 3000.270) now supports the Fabric Pipeline Copy Activity, an additional endpoint for on-premises data gateway communication, and connections to the Vertica database with the user-installed ODBC driver.
May 2025 Dataflow Gen2 Public APIs (preview) Data Factory APIs enable users to automate and manage dataflows, including creation, management, scheduling, and monitoring. For more information, see Dataflow APIs.
May 2025 Dataflow Gen2 parameterization (preview) Data Factory parameterization makes workflows more efficient and adaptable to varying inputs and scenarios. For more information, see Use public parameters in Dataflow Gen2 (preview).
May 2025 Lakehouse as an incremental refresh destination in Dataflow Gen2 (preview) For scenarios when you need to refresh only new or updated data, you can now enable incremental data refresh from a Lakehouse in Dataflow Gen2 for Microsoft Fabric Data Factory. For more information, see Incremental refresh in Dataflow Gen2.
May 2025 SharePoint files as a destination in Dataflow Gen2 (preview) You can now configure dataflow queries to output data into specific folders within SharePoint. For more information, see Dataflow Gen2 data destinations and managed settings.
May 2025 Copy job support for change data capture (CDC) (preview) Change Data Capture (CDC) in Copy Job is a powerful capability in Data Factory Data pipelines that enables efficient and automated replication of changed data including inserted, updated, and deleted records from a source to a destination.
May 2025 Dataflow Gen2 CI/CD support CI/CD and Git integration are now supported for Dataflow Gen2 as a generally available feature. For more information, see Dataflow Gen2 CI/CD support.
May 2025 Orchestrate your Databricks jobs with Fabric Data Pipelines You can run and manage Azure Databricks jobs from Fabric Data Pipelines as part of end-to-end workflows in Fabric Data Pipelines. For more information, see Transform data by running an Azure Databricks activity.
April 2025 Passing parameter values to refresh a Dataflow Gen2 (preview) Learn more about public parameters 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 Data Gateway support Virtual Network 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 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.

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

Data Factory in Microsoft Fabric samples and guidance

Month Feature Learn more
June 2025 Privacy by Design: PII Detection and Anonymization with PySpark This blog explores how to build scalable, secure, and compliant data workflows using PySpark, Microsoft Presidio, and Faker.
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 provides 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.

Fabric Data Engineering

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

Month Feature Learn more
June 2025 Notebook Copilot inline code completion (preview) Now in preview, Copilot Inline Code Completion (Preview) is an AI feature that assists data scientists and engineers in writing Python code more quickly and easily. For more information, see Notebook Copilot auto-completion (Preview).
June 2025 Python Notebook supports tsql magic commands (preview) Python Notebooks now support the tsql magic command to query Fabric Data Warehouse. To see the full syntax, you can use the %%tsql -? command. For more information, see Run T-SQL code in Fabric Python notebooks.
June 2025 Notebook version history GA 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.
June 2025 T-SQL notebooks GA The T-SQL notebook feature is now generally available. You can use T-SQL notebooks to write and run T-SQL code, manage complex queries, and write better markdown documentation. The new monitoring experience includes a new Recent run panel and a dedicated T-SQL panel to list the query history. To learn more, see T-SQL support in Microsoft Fabric notebooks.
June 2025 AI functions improvements (preview) AI functions for data engineering are now in preview. Learn more about recent improvements to AI functions during the current preview.
June 2025 New features for Microsoft Fabric Extension in VS Code Now in the Fabric extension for VS Code, you can create items and switch tenants to manage your workspaces and items. For more information, see Announcing new features for Microsoft Fabric Extension in VS Code.
June 2025 Customer-managed keys for Fabric workspaces (preview) Workspace customer-managed keys allow you to encrypt data in OneLake using your own keys. For more information, see Customer Managed Keys in OneLake: Strengthening Data Protection and Control.
June 2025 Aggregations in Fabric API for GraphQL Aggregations in Fabric API for GraphQL enable more efficient and powerful data queries using GraphQL in Fabric. For more information, see Aggregations in API for GraphQL.
May 2025 Boost performance effortlessly with Automated Table Statistics in Fabric Spark Automated Table Statistics are now generally available, automatically optimizing query performance by maintaining up-to-date statistics in Fabric Spark. For more information, see Configure and manage Automated Table Statistics in Fabric Spark.
May 2025 Authenticate to Fabric data connections using Azure Key Vault (preview) You can now authenticate to Fabric data connections using Azure Key Vault stored secrets (preview). Azure Key Vault references enable secure and centralized secret management for your data connections. For more information, see Azure Key Vault references overview (preview) and get started at Configure Azure Key Vault references.
May 2025 Shortcut transformations (preview) Shortcut transformations let you automatically transform data as you bring it into OneLake or move it between OneLake data items.
May 2025 Microsoft Fabric Spark Native Execution Engine now generally available The Microsoft Fabric Spark Native Execution Engine is now generally available as part of Fabric Runtime 1.3 and provides improved performance and efficiency for Spark workloads in Microsoft Fabric. For more information, see Native execution engine for Fabric Spark.
May 2025 Azure Blob Storage in OneLake shortcut type (preview) You can now create shortcuts to Azure Blob Storage in OneLake, making it easier to integrate and access blob data in Microsoft Fabric. For more information, see Create an Azure Blob Storage shortcut (preview).
May 2025 Materialized Lake views (preview) Materialized Lake Views were announced at Build 2025. Materialized Lake Views in Microsoft Fabric enable fast and efficient querying of data stored in OneLake.
May 2025 Inline code completion in Fabric notebooks (preview) Fabric notebooks with inline code completion helps users write code faster and with fewer errors. For more information, see Copilot for Data Science and Data Engineering (preview).
May 2025 OneLake shortcut cache and on-premises gateway support now generally available Shortcut cache and on-premises gateway support is now generally available. Use OneLake shortcut cache to quickly and easily source data from external cloud providers. The on-premises gateway allows you to securely connect to your data through multiple network restricted scenarios. For more information, see Create shortcuts to on-premises data.
April 2025 Fabric Spark connector for Fabric Data Warehouse in Spark runtime The Spark connector for Data Warehouse, now generally available, 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.
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 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.

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

Fabric Data Engineering samples and guidance

Month Feature Learn more
June 2025 How to debug user data functions locally in VS Code Learn how to perform local debugging on user data functions with Visual Studio Code.
June 2025 Integrating Azure API Management with Fabric API for GraphQL Learn how to configure Azure API Management (APIM) with Microsoft Fabric's API for GraphQL to significantly enhance your API's capabilities by providing robust scalability and security features such as identity management, rate limiting, and caching.
June 2025 Privacy by Design: PII Detection and Anonymization with PySpark This blog explores how to build scalable, secure, and compliant data workflows using PySpark, Microsoft Presidio, and Faker.
June 2025 Integrate Fabric with Azure Databricks using private network Learn how to securely integrate Azure Databricks with Fabric using a virtual network gateway, enabling end to end private network connectivity.
May 2025 Understanding OneLake Security with Shortcuts Understanding OneLake Security with Shortcuts explains how security is managed when using shortcuts in OneLake. For more information, see OneLake shortcut security.
May 2025 Manage connections for shortcuts Learn how to manage connections for shortcuts and centrally manage connections for OneLake shortcuts in Microsoft Fabric. For more information, see Unify data sources with OneLake shortcuts.
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 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 allow 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 Fabric User data functions 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.

Fabric Data Science

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

Month Feature Learn more
June 2025 AI functions improvements (preview) AI functions for data engineering are now in preview. Learn more about recent improvements to AI functions during the current preview.
June 2025 Data source instructions in Fabric Data Agent Data Source Instructions in the Fabric Data Agent help you get more precise, relevant answers from your structured data. For more information, see New in Fabric Data Agent: Data source instructions for smarter, more accurate AI responses.
May 2025 Fabric data agent integration with Microsoft Copilot Studio (preview) Fabric data agent will be available in preview and can be added as an agent to your custom setup in Microsoft Copilot Studio. For more information, see Fabric data agent integration with Microsoft Copilot Studio (preview).
May 2025 Evaluate your Fabric data agents with the Python SDK (preview) You can now use the Python SDK to programmatically evaluate Fabric data agents. For more information, see Consume Fabric data agent (preview).
April 2025 Fabric data agent integration with Azure AI Agent Service (preview) We're 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.

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

Fabric Data Science samples and guidance

Month Feature Learn more
May 2025 Extracting deeper insights with Fabric data agents in Copilot in Power BI You can use Fabric data agents in Copilot in Power BI to connect to more data sources and extract richer insights in Power BI. For more information, see Create a Fabric data agent.
May 2025 Accelerate AI on Oracle databases with Open Mirroring, Fabric Data Agent, and Azure AI Foundry Accelerate AI on Oracle databases with Open Mirroring, Fabric Data Agent, and Azure AI Foundry shows how to integrate Oracle databases with Microsoft Fabric and Azure AI Foundry for advanced analytics and AI scenarios. For more information, see Open Mirroring in Fabric.

Fabric Databases

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

Month Feature Learn more
July 2025 Deploy SQL database with Fabric CLI You can now create a SQL database with the Fabric CLI.
June 2025 Updates to Database Development Tools for SQL database in Fabric Updates to Database Development Tools for SQL database in Fabric introduce new capabilities for developing, deploying, and managing SQL databases in Fabric.
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.

Fabric Database samples and guidance

Month Feature Learn more
May 2025 Smart Mutations in Microsoft Fabric API for GraphQL with stored procedures Learn how to use Smart Mutations in Microsoft Fabric API for GraphQL with Stored Procedures to create, update, and delete data in your SQL database.
May 2025 Understand Query vs Mutation in API for GraphQL Understand the differences between Query vs Mutation in API for GraphQL and how to use them effectively. For more information, see Create an API for GraphQL in Fabric and add data and Fabric API for GraphQL frequently asked questions.
March 2025 Build RAG Data pipeline from Azure Blob Storage to SQL Database in minutes This blog post provides 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.

Fabric Data Warehouse

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

Month Feature Learn more
June 2025 Python Notebook supports tsql magic commands (preview) Python Notebooks now support the tsql magic command to query Fabric Data Warehouse. To see the full syntax, you can use the %%tsql -? command. For more information, see Run T-SQL code in Fabric Python notebooks.
June 2025 T-SQL notebooks GA The T-SQL notebook feature is now generally available. You can use T-SQL notebooks to write and run T-SQL code, manage complex queries, and write better markdown documentation. The new monitoring experience includes a new Recent run panel and a dedicated T-SQL panel to list the query history. To learn more, see T-SQL support in Microsoft Fabric notebooks.
June 2025 Refresh SQL analytics endpoint metadata with REST API (preview) You can now refresh SQL endpoint metadata via REST API. To learn more, see Refresh SQL analytics endpoint Metadata REST API (Preview).
June 2025 Scalar user-defined functions (UDFs) Scalar user-defined functions (UDFs) are now supported as a preview feature. For more information, see CREATE FUNCTION for Fabric Data Warehouse.
June 2025 Result set caching (preview) Result set caching works by persisting the final result sets for applicable SELECT T-SQL queries, bypassing complex compilation and data processing of the original query to return queries faster. For more information, see Result Set Caching for Microsoft Fabric Data Warehouse (preview).
May 2025 ALTER TABLE DROP COLUMN and sp_rename COLUMN support Fabric Data Warehouse now supports sp_rename COLUMN and ALTER TABLE DROP COLUMN.
May 2025 JSON Aggregate support Fabric warehouses now support JSON aggregate functions as generally available features. For more information, see JSON_ARRAYAGG and JSON_OBJECTAGG.
May 2025 Copilot for SQL analytics endpoint (preview) The Copilot for SQL analytics endpoint introduces Copilot capabilities for the SQL analytics endpoint, enabling users to generate and optimize SQL queries using natural language. For more information, see Copilot for SQL analytics endpoint.
May 2025 Datamarts upgrade to warehouse Beginning June 1, 2025, creating a new Power BI datamart will redirect to creating a new Fabric Warehouse. For existing Power BI datamarts, Upgrade a Power BI Datamart to a Warehouse. For more information, see Unify Datamart with Fabric Data Warehouse!.
May 2025 Warehouse snapshots (preview) Warehouse snapshots are a point-in-time, read-only representation of your data warehouse. You can create a snapshot of your warehouse at any point in the past 30 days, connect to it and query it just like a warehouse, and "roll forward" your snapshot regularly. To get started, see Create and manage a warehouse snapshot.
April 2025 Fabric Spark connector for Fabric Data Warehouse in Spark runtime The Spark connector for Data Warehouse, now generally available, 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.
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. For more information, see Tables in Fabric Data Warehouse.
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 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 The T-SQL OPENROWSET(BULK) function is now generally available in Fabric Data 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 Migration Assistant for Fabric Data Warehouse (preview) 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?

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

Fabric Data Warehouse samples and guidance

Month Feature Learn more
June 2025 Make your scalar user-defined functions (UDFs) inlineable Scalar user-defined functions (UDFs) are now supported and inlining is an importance concept to understand. For more information, see How to make your SQL scalar user-defined function (UDF) inlineable in Microsoft Fabric Warehouse .
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.

Fabric Mirroring

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

Month Feature Learn more
July 2025 Mirrored Azure Databricks Mirrored Azure Databricks catalogs to Fabric are now generally available. A mirrored Unity Catalog in Fabric enables customer to read data managed by Unity Catalog from Fabric workloads. Storage accounts behind a firewall are also generally available.
June 2025 Secure mirrored Azure Databricks data with OneLake security (preview) You can secure mirrored Azure Databricks data in Fabric using OneLake security, now a feature in preview. You can now map Unity Catalog (UC) policies to Microsoft OneLake security. For more information, see Automatic identity managed in Azure Databricks.
May 2025 Private Endpoint support and more features in Mirrored Azure SQL Managed Instance Mirroring for Azure SQL Managed Instance: Private Endpoint support and other enhancements for mirroring Azure SQL Managed Instance to Microsoft Fabric. For more information, see Mirrored Azure SQL Managed Instance.
May 2025 Mirroring in Fabric: Innovations at Microsoft Build 2025 Build 2025 announced Innovations in Fabric Mirroring, including new mirroring capabilities and enhancements for integrating external databases with Microsoft Fabric.
May 2025 Mirroring for Snowflake behind firewall (preview) You can now mirror Snowflake protected by a firewall to Microsoft Fabric. For more information, see Mirroring for Snowflake behind firewall (preview) and Mirrored Snowflake.
May 2025 Open mirroring 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, now generally available, 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.
May 2025 Mirroring for SQL Server instances (preview) Mirroring of databases from SQL Server instances is now in preview. For more information, see Mirroring for SQL Server (preview).
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 are able to define policies which scan data uploaded to KQL DBs or Mirrored DBs (including Snowflake, Azure, and more).
March 2025 Mirroring CI/CD CI/CD for Mirroring is now generally available. You can integrate Git for source control and utilize ALM Deployment Pipelines, streamlining the deployment process and ensuring seamless updates to mirrored databases.
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.

Fabric Mirroring samples and guidance

Month Feature Learn more
May 2025 Mirroring in Microsoft Fabric explained Learn more about Fabric Mirroring, when should you use it, and what value does it bring to you and your organization?
May 2025 Mirroring for Azure Database for PostgreSQL in Fabric for effortless analytics on transactional data You can use Mirroring for Azure Database for PostgreSQL in Microsoft Fabric to replicate PostgreSQL data for analytics in Fabric.
May 2025 Accelerate AI on Oracle databases with Open Mirroring, Fabric Data Agent, and Azure AI Foundry Accelerate AI on Oracle databases with Open Mirroring, Fabric Data Agent, and Azure AI Foundry shows how to integrate Oracle databases with Microsoft Fabric and Azure AI Foundry for advanced analytics and AI scenarios. For more information, see Open Mirroring in Fabric.

Real-Time Intelligence in Microsoft Fabric

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

Month Feature Learn more
June 2025 Secure Data Streaming with Managed Private Endpoints in Fabric Eventstream GA By creating a Fabric Managed Private Endpoint in Fabric Eventstream (now generally available), 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 Fabric Eventstream (preview).
June 2025 MCP Support for Real-Time Intelligence (preview) Model Context Protocol (MCP) is now supported for Real-Time IntelligenceThe open-source MCP server enables AI agents or AI applications to interact with Fabric Real-Time Intelligence by providing tools through the MCP interface, allowing for seamless data querying and analysis capabilities.
June 2025 Eventhouse no-code table creation and editing Eventhouse no-code table creation and editing allows you to define a table's structure by specifying the columns and data types – no sample data, no complex KQL queries, and no technical expertise required. For more information, see Edit a table schema.
May 2025 Introducing FinOps Toolkit The new FinOps Toolkit in Fabric provides tools for financial operations and cost management in Fabric. For more information, see FinOps Toolkit in Fabric on GitHub.
May 2025 Fabric Eventstream derived streams in Direct Ingestion mode (preview) You can ingest data from Fabric Eventstream to Eventhouse seamlessly either from an eventstream or using Eventhouse Get Data Wizard. This capability is now being extended to support Eventstream Derived streams in direct ingestion mode. For more information, see Fabric Eventhouse now supports Eventstream Derived Streams in Direct Ingestion mode (preview).
May 2025 Semantic model refresh activity Use the Semantic model refresh activity to refresh a Power BI Dataset, the most effective way to refresh your Fabric semantic models. For more information, see Semantic Model Refresh Activity (Generally Available).
May 2025 Eventhouse Query Acceleration for OneLake Shortcuts 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 more information, see Query acceleration for OneLake shortcuts - overview.
May 2025 New OpenAI plugins for Eventhouse (preview) You can now use two powerful AI plugins for Eventhouse: AI Embed Text Plugin and AI Chat Completion Prompt Plugin. Connect Eventhouse data to OpenAI-powered applications for advanced analytics and AI scenarios. For more information, see ai_embed_text (preview) and ai_chat_completion (preview).
May 2025 Continuous ingestion from Azure Storage to Eventhouse (preview) You can now use continuous ingestion from Azure Storage to Eventhouse (preview) to automatically and efficiently ingest data from Azure Storage into Eventhouse. For more information, see Get data from Azure Storage.
May 2025 Activator as an Orchestrator of the Fabric Event Driven flows Activator as an Orchestrator of the Fabric Event Driven flows allows users to automate actions based on real-time events in Microsoft Fabric. For more information, see Tutorial: Create and activate an Activator rule.
May 2025 Digital twin builder (preview) Digital twin builder (preview) is a new item within the Real-Time Intelligence workload. Digital twins create data-driven, real-time representations of entities. It's a data modeling item that creates digital representations of real-world environments, to optimize physical operations using data. For more information, see What is digital twin builder (preview)?.
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 are able to define policies which 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 Users with the new SubscribeOneLakeEvents permission are now 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.

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
May 2025 Efficient JSON loading to Eventhouse In this blog, review options to design efficient JSON loading to Eventhouse.
April 2025 Medallion Architecture in Fabric Real-Time Intelligence Blog: Medallion Architecture in Fabric Real-Time Intelligence introduces how to implement the Medallion architecture pattern for real-time data processing in Microsoft Fabric.
April 2025 Understanding Real-Time Intelligence CDC connector for PostgreSQL database Understand important points to keep in mind when using PostgreSQL database CDC in Fabric 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 Compare Microsoft Entra ID and SAS Keys auth in Fabric Eventstream, explore use cases, and walk through how to connect Azure Logic Apps to Eventstream using managed identity authentication.

Microsoft Fabric platform features

News and feature announcements about the Microsoft Fabric platform experience.

Month Feature Learn more
June 2025 Best Practices for Success with Purview Data Loss Prevention (DLP) Policies Learn more about proven best practices to maximize your security, compliance, and productivity with Purview Data Loss Prevention (DLP) policies.
June 2025 New features for Microsoft Fabric Extension in VS Code Now in the Fabric extension for VS Code, you can create items and switch tenants to manage your workspaces and items. For more information, see Announcing new features for Microsoft Fabric Extension in VS Code.
June 2025 Surge Protection for Background Operation Surge Protection for background operations is now generally available (GA). Using surge protection, capacity admins can limit overuse by background operations in their capacities.
June 2025 New item creation experience in Fabric The enhanced item creation experience in Fabric is all about consistency, efficiency, and control. Now, no matter what type of item you're adding, the process feels familiar and smooth every time. For more information, see Introducing new item creation experience in Fabric.
May 2025 Fabric CLI (GA) The Fabric CLI is now generally available—fully supported for production use, backed by Microsoft's SLA, and built to meet the security, compliance, and reliability standards our customers expect. From CI/CD pipelines to deployment automation and governance scenarios, the CLI is ready for real-world environments, and you can confidently adopt it in production! Get started at https://aka.ms/FabCLI.
May 2025 Encrypt data at rest using customer-managed keys (preview) By default, Fabric encrypts all data at rest using Microsoft-managed keys. You can now encrypt data at rest in your Fabric workspaces using customer-managed keys, as a preview feature, giving you greater control over data security and compliance. For more information, see Customer-managed keys for Fabric workspaces.
May 2025 Connect to your most sensitive data with end-to-end network security in Fabric Azure Private Link support for workspaces, outbound access protection for Spark, and Fabric encryption with customer managed keys have been announced in preview to enable secure access to sensitive data in Microsoft Fabric using comprehensive network security features.
May 2025 Fabric Copilot capacity for F2 and higher Fabric Copilot capacity can now be created in F2 capacity or higher. Fabric Copilot capacity allows capacity admins to grant direct Copilot access, and to manage Copilot costs by assigning Copilot costs in other capacities to Fabric Copilot.
May 2025 Enabling broader adoption of XMLA-based tools and scenarios Enabling broader adoption of XMLA-based tools and scenarios introduces new capabilities that make it easier to use XMLA-based tools and scenarios with Microsoft Fabric. For more information, see Semantic model connectivity.
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, and is integrated with notebooks. For more information, see Variable library (preview) and Notebook integration with variable libraries.
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 (preview) The Fabric CLI (fab) is a fast, file‑system‑inspired command‑line interface for Microsoft Fabric. Explore, automate, and script your Fabric environment—right from your terminal. Get started at https://aka.ms/FabCLI.
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.

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.

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.