Power BI

Power BI

7501 bookmarks
Newest
Translytical task flows (Preview)
Translytical task flows (Preview)
We are thrilled to announce that Power BI report buttons can now run Fabric User data functions for custom, automated action, including data write-back. This marks a major evolution in Power BI reports to support all kinds of translytical task flows, such as updating records, dynamic notifications, adding annotations, or even creating powerful workflows that trigger actions in other systems. Read more to see how translytical task flows can help streamline decision-making and end-user actions through automation.
·powerbi.microsoft.com·
Translytical task flows (Preview)
Updates to database development tools for SQL database in Fabric | Microsoft Fabric Blog | Microsoft Fabric
Updates to database development tools for SQL database in Fabric | Microsoft Fabric Blog | Microsoft 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>
·blog.fabric.microsoft.com·
Updates to database development tools for SQL database in Fabric | Microsoft Fabric Blog | Microsoft Fabric
Creating SQL database workload in Fabric with Terraform: A Step-by-Step Guide (Preview) | Microsoft Fabric Blog | Microsoft Fabric
Creating SQL database workload in Fabric with Terraform: A Step-by-Step Guide (Preview) | Microsoft Fabric Blog | Microsoft Fabric
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>
·blog.fabric.microsoft.com·
Creating SQL database workload in Fabric with Terraform: A Step-by-Step Guide (Preview) | Microsoft Fabric Blog | Microsoft Fabric
Understanding OneLake Security with Shortcuts | Microsoft Fabric Blog | Microsoft Fabric
Understanding OneLake Security with Shortcuts | Microsoft Fabric Blog | Microsoft Fabric
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>
·blog.fabric.microsoft.com·
Understanding OneLake Security with Shortcuts | Microsoft Fabric Blog | Microsoft Fabric
Azure Data Factory Item Mounting (Generally Available) | Microsoft Fabric Blog | Microsoft Fabric
Azure Data Factory Item Mounting (Generally Available) | Microsoft Fabric Blog | Microsoft Fabric
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>
·blog.fabric.microsoft.com·
Azure Data Factory Item Mounting (Generally Available) | Microsoft Fabric Blog | Microsoft Fabric
Integrating Fabric with Databricks using private network | Microsoft Fabric Blog | Microsoft Fabric
Integrating Fabric with Databricks using private network | Microsoft Fabric Blog | Microsoft Fabric
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>
·blog.fabric.microsoft.com·
Integrating Fabric with Databricks using private network | Microsoft Fabric Blog | Microsoft Fabric
What’s new with OneLake shortcuts | Microsoft Fabric Blog | Microsoft Fabric
What’s new with OneLake shortcuts | Microsoft Fabric Blog | Microsoft Fabric
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>
·blog.fabric.microsoft.com·
What’s new with OneLake shortcuts | Microsoft Fabric Blog | Microsoft Fabric
How to create a SQL database in Fabric using Fabric CLI | Microsoft Fabric Blog | Microsoft Fabric
How to create a SQL database in Fabric using Fabric CLI | Microsoft Fabric Blog | Microsoft Fabric
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>
·blog.fabric.microsoft.com·
How to create a SQL database in Fabric using Fabric CLI | Microsoft Fabric Blog | Microsoft Fabric
Boost performance effortlessly with Automated Table Statistics in Microsoft Fabric | Microsoft Fabric Blog | Microsoft Fabric
Boost performance effortlessly with Automated Table Statistics in Microsoft Fabric | Microsoft Fabric Blog | Microsoft Fabric
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>
·blog.fabric.microsoft.com·
Boost performance effortlessly with Automated Table Statistics in Microsoft Fabric | Microsoft Fabric Blog | Microsoft Fabric
Get to insights faster with SaaS databases and “chat with your data” | Microsoft Fabric Blog | Microsoft Fabric
Get to insights faster with SaaS databases and “chat with your data” | Microsoft Fabric Blog | Microsoft Fabric
A recent study from the Social Science Research Network looked at 5,000 developers using generative AI tools in their day-to-day work and found a 26% average increase in completed tasks. The massive opportunity generative AI presents for developers and data professionals was one of the key driving forces behind the initial development of Microsoft Fabric. … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/get-to-insights-faster-with-saas-databases-and-chat-with-your-data-experiences/" class="more-link">Continue reading<span class="screen-reader-text"> “Get to insights faster with SaaS databases and “chat with your data””</span></a>
Accelerate app development: Cosmos DB (NoSQL) in Fabric now in preview
This removes the barriers between users and insights, enabling everyone—from business analysts to data scientists—
engage in natural language conversations with their data across multiple reports and semantic models
This chat with your data experience will allow users to ask broader questions and intelligently retrieve the most relevant data
Coming soon in public preview, Fabric data agents can be added to any custom agent built in Microsoft Copilot Studio
Once connected, the custom agent uses the Fabric data agent to retrieve insights from OneLake, respecting data access permissions
Developers can also define actions (e.g., send an email or trigger workflows) to automate processes
For teams tasked with building new AI and analytics solutions, finding and accessing the necessary data across a sea of disconnected data services
Shortcut transformations
These updates reinforce our commitment to Fabric’s four core pillars: A complete, AI-powered data platform. An open, AI-ready data lake. Empowering AI-enabled business users. A mission-critical foundation.
The general availability of the Native Execution Engine enables Spark queries to run natively on your lakehouse—up to 6x faster with no code changes or vendor lock-in. This release brings built-in optimizations and resource profiles for faster, more cost-effective data engineering at scale.
real-time endpoints for ML models
The preview of Warehouse Snapshots enables users to access a consistent view of data from a specific point in time, even during ETL processes
·blog.fabric.microsoft.com·
Get to insights faster with SaaS databases and “chat with your data” | Microsoft Fabric Blog | Microsoft Fabric
Announcing Copilot for SQL Analytics Endpoint in Microsoft Fabric (Preview) | Microsoft Fabric Blog | Microsoft Fabric
Announcing Copilot for SQL Analytics Endpoint in Microsoft Fabric (Preview) | Microsoft Fabric Blog | Microsoft Fabric
We’re excited to introduce Copilot for SQL Analytics Endpoint, now in preview – a transformative, AI-powered assistant built to change how you query, explore, and analyze data within Microsoft Fabric’s SQL experience. With Copilot integrated directly into the SQL Analytics Endpoint, users can now express intent in natural language and instantly receive ready-to-run T-SQL. Whether … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-copilot-for-sql-analytics-endpoint-in-microsoft-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Announcing Copilot for SQL Analytics Endpoint in Microsoft Fabric (Preview)”</span></a>
Copilot for SQL Analytics Endpoint in the context of your business Picture this: you need to tie customer orders from your mirrored CRM to fulfillment data in the Warehouse – something that normally requires digging through schemas, writing complex joins, and double-checking table relationships. With Copilot, you skip the heavy lifting. A simple prompt – ‘Get customer orders from CRM and join with fulfillment data from the warehouse‘ – returns a ready-to-run query that pulls exactly what you need, no manual schema deep dives required. Or maybe you’re looking to blend product metadata in a Lakehouse with sales numbers stored in a Warehouse. Instead of bouncing between storage formats and trying to reconcile differences yourself, you ask Copilot: ‘Show me top-selling products by category using product metadata from the Lakehouse and sales from the warehouse.‘ Copilot does the heavy lifting, stitching sources together behind the scenes so you can focus on the insight, not the integration. And when you’re under pressure to deliver quick insights – like pulling revenue by region for a quarterly review – Copilot has you covered there, too. Even if you’ve never touched the Finance Lakehouse, you can ask: ‘Show me total revenue by region for the last quarter using the Finance Lakehouse.‘ Copilot identifies the right tables, applies the correct filters, and generates the SQL you need without the typical back-and-forth. Copilot transforms how you work with data: no more searching, stitching, or second-guessing. Complex environments become accessible. Insights flow faster. Data silos disappear. With Copilot in SQL Analytics Endpoint, you don’t just save time, you unlock the full power of Fabric and move from question to impact without missing a beat.
·blog.fabric.microsoft.com·
Announcing Copilot for SQL Analytics Endpoint in Microsoft Fabric (Preview) | Microsoft Fabric Blog | Microsoft Fabric
Shortcut cache and on-prem gateway support (Generally Available) | Microsoft Fabric Blog | Microsoft Fabric
Shortcut cache and on-prem gateway support (Generally Available) | Microsoft Fabric Blog | Microsoft Fabric
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>
·blog.fabric.microsoft.com·
Shortcut cache and on-prem gateway support (Generally Available) | Microsoft Fabric Blog | Microsoft Fabric
Manage connections for shortcuts | Microsoft Fabric Blog | Microsoft Fabric
Manage connections for shortcuts | Microsoft Fabric Blog | Microsoft Fabric
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>
·blog.fabric.microsoft.com·
Manage connections for shortcuts | Microsoft Fabric Blog | Microsoft Fabric
Unify Datamart with Fabric Data Warehouse!
Unify Datamart with Fabric Data Warehouse!
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.
·powerbi.microsoft.com·
Unify Datamart with Fabric Data Warehouse!
Tools in Power BI - SQLBI
Tools in Power BI - SQLBI
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
LLM tools: Likewise, you can use LLM tools to facilitate various aspects of report development, including the creation of custom visuals in DAX (via SVG visuals), R, Python, and Deneb.
Figma and Excalidraw: general-purpose design tools that you can use to facilitate the design for anything. For models, you might use Figma (FigJam, likely) or Excalidraw to create the conceptual or logical model for your semantic model during the design There are many other tools for doing this, including Visio or even the diagram view in Tabular Editor 3.
Tabular Editor: an end-to-end development tool that you can use either together with Power BI Desktop or as an alternative. Tabular Editor is an integrated development environment specialized for working with semantic models. It is designed from the ground up, to empower semantic model developers with everything they need to build good semantic models while being efficient.
Large language models (LLMs) and other generative AI tools
Power BI Desktop tools: New features and tools in Power BI Desktop also support a variety of use cases.
Power Designer
It is important to emphasize that you do not need to use any of these tools. Rather, you typically turn to them when you have specific problems that you want to solve, or scenarios that you aim to address
·sqlbi.com·
Tools in Power BI - SQLBI
All the different ways to authenticate to Azure SQL, Synapse, and Fabric
All the different ways to authenticate to Azure SQL, Synapse, and Fabric
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.
·debruyn.dev·
All the different ways to authenticate to Azure SQL, Synapse, and Fabric
Tabular Editor: Explicit Calculation Group Measures | PowerDAX
Tabular Editor: Explicit Calculation Group Measures | PowerDAX
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
·powerdax.com·
Tabular Editor: Explicit Calculation Group Measures | PowerDAX
A Tale of Two Direct Lakes in Microsoft Fabric - Data Mozart
A Tale of Two Direct Lakes in Microsoft Fabric - Data Mozart
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.
·data-mozart.com·
A Tale of Two Direct Lakes in Microsoft Fabric - Data Mozart
Using TMDL to generate bulk DAX Measures for Formatting
Using TMDL to generate bulk DAX Measures for Formatting
IntroductionIn this blog, I will demonstrate how to use the TMDL view in Power BI, to generate multiple DAX measures simultaneously, intended for use in conditional formatting and to improve visual design.This TMDL script can be executed in any semantic model, as long as the TMDL preview feature is enabled. Instead of manually adding each measure one by one, this allows me to quickly replicate the entire set across multiple semantic models.As shown the screenshot below, I have prepared a TMDL sc
·datalineo.com·
Using TMDL to generate bulk DAX Measures for Formatting