Fabric

With SQL database in Fabric, the source control integration in Fabric enables you to keep your active work synced to git while following a branching strategy that best matches your team’s environments and deployment requirements. With the complexity of enterprise deployment scenarios, code-first deployment is also available for Fabric objects through tools like the Fabric-CICD … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/updates-to-database-development-tools-for-sql-database-in-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Updates to database development tools for SQL database in Fabric”</span></a>

Infrastructure as Code (IaC) tools like Terraform have revolutionized the way developers and organizations deploy and manage infrastructure. With its declarative language and ability to automate provisioning, Terraform reduces human error, ensures consistency, and speeds up deployment across cloud and on-premises environments. In this document, we’ll explore how you can create SQL databases workloads in … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/streamline-sql-database-workload-creation-with-terraform/" class="more-link">Continue reading<span class="screen-reader-text"> “Creating SQL database workload in Fabric with Terraform: A Step-by-Step Guide (Preview)”</span></a>

OneLake allows for security to be defined once and enforced consistently across Microsoft Fabric. One of its standout features is its ability to work seamlessly with shortcuts, offering users the flexibility to access and organize data from different locations while maintaining robust security controls. In this blog post, we will look at how OneLake security … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/understanding-onelake-security-with-shortcuts/" class="more-link">Continue reading<span class="screen-reader-text"> “Understanding OneLake Security with Shortcuts”</span></a>

We’re excited to announce the General Availability (GA) of the Azure Data Factory (Mounting) feature in Microsoft Fabric! This powerful capability allows you to seamlessly connect your existing Azure Data Factory (ADF) pipelines to Fabric workspaces, eliminating the need to manually rebuild or migrate them. What’s New with GA? Once your ADF instance is linked to a Fabric workspace, you … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/23604/" class="more-link">Continue reading<span class="screen-reader-text"> “Azure Data Factory Item Mounting (Generally Available)”</span></a>

Microsoft Fabric and Azure Databricks are widely used data platforms. This article aims to address the requirement of customers who have large data estates in Azure databricks and want to unlock additional use cases in Microsoft Fabric arising out of different business teams. When integrating the two platforms, a crucial security requirement is to ensure … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/integrating-fabric-with-databricks-using-private-network/" class="more-link">Continue reading<span class="screen-reader-text"> “Integrating Fabric with Databricks using private network”</span></a>

Microsoft Fabric shortcuts enable organizations to unify their data across various domains and clouds by creating a single virtual data lake. These shortcuts act as symbolic links to data in different storage locations, simplifying access and reducing the need for multiple copies. OneLake serves as the central hub for all analytics data. By using OneLake … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/whats-new-with-onelake-shortcuts/" class="more-link">Continue reading<span class="screen-reader-text"> “What’s new with OneLake shortcuts”</span></a>

Step into the future of simplicity with Fabric CLI. The Fabric Command Line Interface (CLI) has arrived in preview, bringing with it a seamless way to create SQL databases for your projects. This guide will take you through the steps to get started, ensuring you can leverage the power of Fabric CLI with ease. Prerequisites Before … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/how-to-create-a-sql-database-in-fabric-using-fabric-cli/" class="more-link">Continue reading<span class="screen-reader-text"> “How to create a SQL database in Fabric using Fabric CLI”</span></a>

We’re thrilled to introduce Automated Table Statistics in Microsoft Fabric Data Engineering — a major upgrade that helps you get blazing-fast query performance with zero manual effort. Whether you’re running complex joins, large aggregations, or heavy filtering workloads, Fabric’s new automated statistics will help Spark make smarter decisions, saving you time, compute, and money. What … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/boost-performance-effortlessly-with-automated-table-statistics-in-microsoft-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Boost performance effortlessly with Automated Table Statistics in Microsoft Fabric”</span></a>

In this tutorial, learn how to enable and create translytical task flows with Fabric user data functions.

Shortcut cache and on-prem gateway support are now generally available (GA) Shortcut cache Shortcuts in OneLake allow you to quickly and easily source data from external cloud providers and use it across all Fabric workloads such as Power BI reports, SQL, Spark and Kusto.  However, each time these workloads read data from cross-cloud sources, the … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/shortcut-cache-and-on-prem-gateway-support-now-generally-available/" class="more-link">Continue reading<span class="screen-reader-text"> “Shortcut cache and on-prem gateway support (Generally Available)”</span></a>

Shortcuts in OneLake provide a quick and easy way to make your data available in Fabric without having to copy it.  Simply create a new shortcut and your data is instantly available to all Fabric workloads. When you first create a new shortcut, you also set up a shared cloud connection. These are the same connections … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/manage-connections-for-shortcuts/" class="more-link">Continue reading<span class="screen-reader-text"> “Manage connections for shortcuts”</span></a>

This update comes with a marked improvement when generating DAX queries and conversationally editing them. This includes overall correctness of the DAX queries and Copilot shows a deeper understanding of how to utilize DAX.

The unification of Power BI datamarts with Fabric data warehouses offers a significant evolution in Microsoft’s analytics capabilities. By addressing user feedback and enhancing features such as scalability, security, and AI integration, Fabric data warehouses offer a robust solution for modern data needs. We encourage users to migrate their existing datamarts to Fabric data warehouses to take full advantage of these improvements and ensure continuity in their data operations.

Working with sensitive data in Microsoft Fabric requires careful handling of secrets, especially when collaborating externally. In a recent customer engagement, I needed to validate access to Azure…

Spark settings in Fabric aren't just technical fine print - they are your ticket to immortality when it comes to Spark performance!

In this post I’ll go over all the details on acquiring access tokens to authenticate to any Microsoft SQL engine, including Azure SQL, Azure Synapse and Microsoft Fabric. We’ll explore users, service principals, managed identities, and Fabric Workspace Identity. Why would you want to do this? Well, if you’re looking to get programmatic access to your database / data warehouse, you’ll need to authenticate. In 2025, more often than not, you’ll be using Microsoft Entra ID to do so and this is where the fun begins.

This blog post explains the advantages of using a Python notebook instead of a Spark notebook in Microsoft Fabric

If you were confused or felt lost with the Direct Lake mode in Microsoft Fabric, I have "great" news for you - things just got even worse! We now have TWO different Direct Lake mode "flavors" - Direct Lake on OneLake and Direct Lake on SQL. In this article, I'm sharing my initial thoughts about the new "on OneLake" enhancement.

This article shows how AI can easily transform images directly to pipelines for Data Factory for Microsoft Fabric.

Using Service Principal and Managed Identity, along with private libraries for Fabric user data functions, makes working with data much easier and more secure. These features let developers customize workflows and use their own code to solve problems, boosting productivity and creativity in teams. As businesses grow and rely more on unique analytics and automation, these tools help simplify data management and improve operations. Check this blog post to learn more

Introducing Seamless Connectivity for Enhanced Data Analytics and Reporting. We are thrilled to announce a new SQL database integration with Power BI Desktop! This innovative feature is designed to empower users with streamlined access to their SQL databases, providing greater flexibility and precision for building insightful reports and dashboards. With this integration, users can now … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-sql-database-integration-unlocking-new-possibilities-with-power-bi-desktop/" class="more-link">Continue reading<span class="screen-reader-text"> “Fabric SQL Database Integration: Unlocking New Possibilities with Power BI desktop”</span></a>

We are excited to announce the release of two powerful AI plugins for Eventhouse: AI Embed Text Plugin and AI Chat Completion Prompt Plugin. These plugins are designed to enhance your data analysis capabilities and augment your workflows with OpenAI models, providing more granular control to power users who seek precision over model output or wish to fine-tune … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/introducing-new-openai-plugins-for-eventhouse-preview/" class="more-link">Continue reading<span class="screen-reader-text"> “Introducing new OpenAI Plugins for Eventhouse (Preview)”</span></a>

Data engineering often presents challenges with data quality or complex data analytics processing that requires custom logic. This is where Fabric User data functions can be used to implement custom logic into your data processes or pipelines. Here are the most common cases where Fabric User Data Functions

We’re excited to unveil the Microsoft Fabric SKU estimator, now available in preview—an enhanced version of the previously introduced Microsoft Fabric Capacity Calculator. This advanced tool has been refined based on extensive user feedback to provide tailored capacity estimations for businesses. Designed to optimize data infrastructure planning, the Microsoft Fabric SKU Estimator helps customers and … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/empowering-businesses-with-smart-capacity-planning-introducing-the-microsoft-fabric-sku-estimator/" class="more-link">Continue reading<span class="screen-reader-text"> “Empowering businesses with smart capacity planning: Introducing the Microsoft Fabric SKU estimator (Preview)”</span></a>

We had such an exciting week for Fabric during the Fabric Conference US, filled with several product announcements and sneak previews of upcoming new features. Thanks to all of you who participated in the conference, either in person or by being part of the many virtual conversations through blogs, Community forums, social media and other … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/recap-of-data-factory-announcements-at-fabric-conference-us-2025/" class="more-link">Continue reading<span class="screen-reader-text"> “Recap of Data Factory Announcements at Fabric Conference US 2025”</span></a>

Microsoft Fabric is changing how we handle data engineering and data science. To make things easier, Microsoft added some cool extensions for Visual Studio Code (VS Code) that help you manage Fabric artifacts and build analytical applications. By adding these Microsoft Fabric extensions to VS Code, developers can quickly create Fabric solutions and manage their … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/boost-your-development-with-microsoft-fabric-extensions-for-visual-studio-code/" class="more-link">Continue reading<span class="screen-reader-text"> “Boost your development with Microsoft Fabric extensions for Visual Studio Code”</span></a>

Imagine a retail company that wants to gain insights into customer sentiment for each of its products. They also want to find their top-selling and least-selling products. Using Microsoft Fabric, they can build a powerful analytical application to transform their raw data into actionable insights. The process starts with ingesting raw data, such as customer reviews and sales figures, and ends with providing refined data through an API for internal use. This helps the company efficiently process customer feedback and make informed decisions to improve their products.<br /> In this blog post, we’ll dive into the architecture of an analytical application powered by Microsoft Fabric, as shown in the image, and provide a step-by-step guide on how to build it.

For nearly three years, Microsoft’s internal Azure Data team has been developing data engineering solutions using Microsoft Fabric. Throughout this journey, we’ve refined our Continuous Integration and Continuous Deployment (CI/CD) approach by experimenting with various branching models, workspace structures, and parameterization techniques. This article walks you through why we chose our strategy and how to implement it in … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/optimizing-for-ci-cd-in-microsoft-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Optimizing for CI/CD in Microsoft Fabric”</span></a>

Overview of the Admin monitoring workspace The admin monitoring workspace is an out-of-the-box solution that installs automatically when a Fabric admin accesses it. You can share the entire workspace or individual reports/semantic models with any user or group. Use the reports for insights on user activity, content sharing, capacity performance, and more in your Fabric … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-public-preview-of-content-sharing-report/" class="more-link">Continue reading<span class="screen-reader-text"> “Content Sharing Report (Preview)”</span></a>