Press "Enter" to skip to content

Category: Power BI

Multiple Record Writeback for Translytical Task Flows

Published 2025-11-18 by Kevin Feasel

Jon Vöge wants to write multiple records at a time:

Having presented a few sessions on Translytical Task Flows at conferences in the past moths, there is one major recurring question:

How do you write-back multiple records at once?

If you ask me, the questions of bulk write-back/writing back multiple records at once can be understood as two separate user stories, which sound similar, but are technically different:

Click through for those two questions as well as the answer to the first.

Leave a Comment

Tying DAX Studio Queries to Workspace Monitoring

Published 2025-11-18 by Kevin Feasel

Chris Webb correlates some data:

A few weeks ago I wrote a blog post about how you can now link event data from Workspace Monitoring to data in the Fabric Capacity Metrics App using OperationId values. In the latest (3.4.0) release of DAX Studio there’s a new feature that you might have missed that link queries run from there to Workspace Monitoring and the Capacity Metrics App in the same way.

Read on to see how it works.

Leave a Comment

Using the OKVIZ Synoptic Panel for Ticket Sales Data

Published 2025-11-17 by Kevin Feasel

Victor Rivas visualizes some sales data:

This use case demonstrates the powerful capability of Synoptic Panel to analyze and visualize spatial data at large venues like The Sphere in Las Vegas, which seats 9,205 people. The study addresses the challenge of visualizing over 1 million ticket sales records from 200 events, including concerts and conferences, to gain insights into revenue and average occupancy percentage across different seating categories, sectors, and individual seats.

The objective is to demonstrate how spatial data visualization helps stakeholders understand revenue distribution and audience behavior related to seating arrangements, enabling more informed decision-making.

Click through for the case study. H/T Marco Russo.

Leave a Comment

Primary Keys and DAX Query Performance

Published 2025-11-14 by Kevin Feasel

Phil Seamark explains why including primary keys in summarize statements can be a bad thing:

When writing DAX queries, performance tuning often comes down to small design decisions that have big consequences. One such decision is whether to include Primary Key columns from Dimension tables in your SUMMARIZECOLUMNS statements. This is particularly important when those Dimension tables use DUAL or IMPORT storage modes.

This article explains why doing so can lead to inefficient query plans. It describes what happens under the hood. It also shows how to avoid this common pitfall.

Read on to learn more.

Leave a Comment

Exporting Non-Downloadable Power BI Reports

Published 2025-11-07 by Kevin Feasel

Koen Verbeeck downloads a report:

Yes, you’re reading that right, we’re going to download a report that cannot be downloaded. Well, it cannot be downloaded from the user interface, that is. Suppose you have a report in a Power BI workspace (Pro, PPU, Fabric, it shouldn’t matter), and they’ve lost the original Power BI Desktop file. You try to download the report, but for some reason the GUI doesn’t let you:

Read on for reasons you might not be able to download the report, as well as what you can do if you do have access to the report but the download option is unavailable.

Leave a Comment

Deleting Default Semantic Models in Microsoft Fabric

Published 2025-11-06 by Kevin Feasel

Pradeep Srikakolapu says good riddance:

In our earlier announcement, we shared that newly created data warehouses, lakehouses and other items in Microsoft Fabric would no longer automatically generate default semantic models. This change allows customers to have more control over their modeling experience and to explicitly choose when and how to create semantic models.

Starting November 20, 2025, Power BI *default* semantic models are disconnected from their item and become independent semantic models.

Click through for an overview of those changes and how you can get rid of the default models you may still have hanging around.

Leave a Comment

Finding the Top 10 Products each Year with DAX

Published 2025-11-04 by Kevin Feasel

Marco Russo and Alberto Ferrari build a top ten list:

We have written and updated a few pieces in the past about how to find the top products, such as Filtering the top products alongside the other products in Power BI and Filtering the Top 3 products for each category in Power BI.

Generally speaking, finding the top products requires using GENERATE and TOPN. However, there is an interesting variation of this scenario that solves a specific business problem. Once we have determined the top 10 products by year, we want to filter only those that appear in the top 10 in most years. Obtaining that list of products helps identify evergreen products, that is, the products that remain in the best-seller list consistently.

Click through for the demonstration.

Leave a Comment

Reviewing Power BI Report Interactions via Semantic Link Labs

Published 2025-11-03 by Kevin Feasel

Meagan Longoria wants to know about visual interactions:

It can be tedious to check what visual interactions have been configured in a Power BI report. If you have a lot of bookmarks, this becomes even more important. If you do this manually, you have to turn on Edit Interactions and select each visual to see what interactions it is emitting to the other visuals on the page.

But there is a better way!

Click through for that better way.

Leave a Comment

Merging the Measures of Two Power BI Semantic Models

Published 2025-10-28 by Kevin Feasel

Jon Vöge declares a hostile takeover:

Now, how you best maintain multiple copies/variants of the same Semantic Model is a whole other discussion but as a one-off, I was asked to merge the Measures of the two models.

Initially, the question actually stumped me as my usual tool of choice for external manipulation of semantic models Tabular Editor does not have a great native way to solve this. 

Jon lists a variety of options and then gets the job done with ALM Toolkit.

Comments closed

Custom Calendars in Power BI

Published 2025-10-24 by Kevin Feasel

Kenneth Omorodion needs a calendar dimension:

Before September 2025, there was a complex workaround to create time intelligence calculations in DAX catered to different calendar types apart from the standard Gregorian calendar. With the Power BI September 2025 feature updates (still in preview at the time of writing), it is now readily possible to define custom Power BI custom calendars based time intelligence, like Shifted Gregorian, ISO, and retail calendars, in the data model and then use the new extended DAX functions against these calendars.

The new feature eliminates the need for complex workarounds and ensures cleaner and more accurate reporting for organizations. This tip will explain the different calendars used in time intelligence reporting and how to define them based on the new calendar-based time intelligence capability in Power BI.

Read on for several examples of how this works.

Comments closed