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.

Dynamic per recipient subscriptions is similar as dynamic subscriptions for paginated reports, we can now send a personalized version of a Power BI report to each individual recipient of an email subscription.These functionality allows the dissemination of unique views of the same report by applying specific filters based on individual user preferences, all seamlessly managed within a single subscription

This post announces the winner of the 3rd qualifying round of the Power BI DataViz World Championships.

This post introduces the final challenge of the qualifying rounds for the Power BI DataViz World Championships.

Editing the json content in PBIP files seems to allow the setting of dynamic expressions in place of static property values - even if the Power BI UI does not provide an fx button. It seems any property can be set dynamically!