Power BI

During FabCon Las Vegas, we introduced the Fabric CLI — a developer-first command-line tool that brings a familiar, file-system-like experience to working with Microsoft Fabric. Since then, thousands of developers have jumped in: exploring, scripting, and embedding the CLI into local workflows. But for many enterprise teams, one question kept coming up: “When will it … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-cli-is-now-generally-available-explore-and-automate-microsoft-fabric-from-your-terminal/" class="more-link">Continue reading<span class="screen-reader-text"> “Fabric CLI: explore and automate Microsoft Fabric from your terminal (Generally Available)”</span></a>

With AI-powered capabilities in Data Wrangler, you can now do even more to accelerate exploratory analysis and data preparation in Fabric.

We’re at a point where the way we work with data is fundamentally shifting. Natural language is becoming the new interface, and tools like Microsoft Fabric are making it possible to ask questions a…

It was only yesterday, that I wrote a blog post on Semantic Models as a source for Fabric Data Agents. Not much time has passed, since I learned that Fabric Data Agents does not (always) respect th…

Discover FUAM—an open-source tool to monitor and govern Power BI & Fabric tenants with detailed reports, long-term data, and easy deployment.

This month, we’re excited to share a major milestone for Power BI modelling tools – Power BI Desktop is now compatible with any semantic model in Fabric. With this update, you’re no longer required to rely on external tools to edit a semantic model running in Fabric. At the same time, it enhances interoperability between external tools and Power BI Desktop, enabling them to do even more.

If you’ve worked with calculation groups, you know how powerful they are for simplifying measure logic and enhancing report functionality. It doesn’t stop there though; selection expressions offer even more fine-tuned control.

Microsoft’s latest Fabric Copilot update replaces the previous large language model used by the DAX Query View Copilot with an advanced Azure Foundry language model, which, according to product man…

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.

Discover the latest updates in Tabular Editor 3, including improved diagram view, a new API property and TMDL script - one-click exports in TOM Explorer.

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…

This article gives an overview of some of the available tools that can help you create semantic models and reports. Creating good data models and reports fo

When using time intelligence functions, the automatic REMOVEFILTERS on Date can make maintaining filters on the Date table challenging. This article shows a

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.

There is an easy way to rebind Power BI reports to another semantic model. using Power BI Studio where it is as simple as a few clicks to rebind the report.

I am always looking for optimizations to facilitate real-world use cases. In this article, we had a requirement to create every possible variation of our time intelligence calculation group for every base measure in a Power BI semantic model. Why explicit measures? Calculation groups are awesome. However, they lack some customizability in ordering, etc. and ... Read more

This article describes how to implement a dynamic Pareto calculation in Power BI based on a measure that can be selected from a slicer and dynamically filte