Learn who the first ever Power BI DataViz World Champion is, and learn more about the competition.

AI is transforming how businesses interact with data, and Microsoft Fabric’s AI Skill are at the forefront of this revolution. Imagine getting instant, data-driven answers without writing complex SQL or DAX queries. AI Skill allow decision-makers and analysts to bypass traditional reporting and receive real-time insights - all through natural language questions.

But how do they work? What are the benefits? And what challenges should you watch out for? In this article, we explore why AI Skill will reshape analytics, how they integrate seamlessly with Power BI, warehouses, lakehouses, and KQL databases, and the key considerations for accuracy and validation.

Copilot in Power BI empowers both developers and non-technical users by assisting with tasks such as generating reports, writing and explaining DAX queries, and creating measure descriptions. However, a common debate revolves around the quality of its results.

In my view, the accuracy and usefulness of Copilot’s output largely depend on the quality of your data model. For example, if your model contains numerous acronyms, abbreviations, or internal definitions, Copilot may struggle to interpret them correctly, leading to less-than-ideal results.

In this blog, we’ll explore how to improve Copilot’s DAX query suggestions by enriching your model with additional metadata such as descriptions, synonyms, and sample values.

Microsoft is sunsetting Power BI Premium—mandatory migration to Fabric begins July 2024.

What you’ll learn:

✅Step-by-step migration guide (with automation scripts!)
⚠️Critical pitfalls to avoid (cross-region data = headache)
💡Pro tips to optimize costs in Fabric

The Numeric Range Parameter in Power BI is a powerful feature that allows users to interact with a variable through a slicer. This helps visualize and quantify different key values dynamically within reports. In this blog, we will explore how to create and use a Numeric Range Parameter to slice and analyze data effectively.

Did you know that Power BI report subscriptions don’t always respect RLS? In some scenarios, users might receive data they shouldn’t see! In my latest blog, I break down a real-world example and show how Dynamic Subscriptions can solve this issue.

Give it a read and let me know your thoughts!

Looking for governance across semantic models and reports? Need a programmatic solution to deploy Direct Lake (and other) semantic models and reports across workspaces and Lakehouses? Semantic Link Labs is the answer. Thanks to Michael Kovalsky and Markus Cozowicz for their efforts in creating this incredible library! In this article, we will review the Power BI architecture and output of a Fabric notebook that leverages Semantic Link Labs to programmatically deploy semantic models and reports across workspaces and schema-enabled Lakehouses, providing central governance.

In this blog, we will explore how to retain slicer selections between different bookmarks using the "Selected Visuals" option in Power BI.

DAX probably has hundreds of functions, however, several of them stand out. In this article, I picked the most useful ones for everyday use and grouped them by functionality. In this section, we will look closely at FILTER functions.

This post features entries to week 4 of the Power BI DataViz World Championships that were called out by judges for their excellence.

This article announces the 4th and final winner of the qualifying rounds of the Power BI DataViz World Championships.

The Problem with Traditional Approval Hierarchies

Many organizations still operate under the illusion that requiring CFO or CEO approval equates to strong financial oversight. However, real-world cases of fraud and inefficiencies tell a different story. These hierarchical approvals:

• Create bottlenecks – Senior leaders are often overwhelmed with approvals, leading to delays and inefficiencies.
• Encourage superficial reviews – Executives rarely have time to deeply analyze each request, turning approvals into a formality.
• Do not effectively mitigate risk – Fraud often happens at executive levels, where transactions are approved under the guise of authority, bypassing real scrutiny.
• Give unchecked power to human bias – Approvals become a tool for reinforcing personal agendas, favoritism, and misallocation of company resources.
• Preserve budget control at the top – Budget allocation is the ultimate power in corporations, and those in senior roles are reluctant to relinquish control, even if AI can distribute resources more fairly and efficiently.

Instead of safeguarding company resources, traditional approval hierarchies often consolidate power among a few individuals who may have their own financial interests in mind.

In this blog, we will walk through the step-by-step process of calculating a cumulative sum by Product ID using a DAX measure in Power BI. This technique is particularly useful for tracking running totals in sales, revenue, or other numerical data over time.

This post recognizes the featured entries from week 3 of the Power BI DataViz World Championships.