Press "Enter" to skip to content

Category: Power BI

Accessing a Former Employee’s Power BI Workspace

Published 2025-11-21 by Kevin Feasel

Gilbert Quevauvilliers says it’s MY workspace now:

One of the common challenges I’ve seen in organizations is when a team member leaves and their Power BI reports are stored in their personal My Workspace. These reports often contain valuable datasets and dashboards that are still in use or need to be maintained. So, how do you access and recover these reports?

In this blog post, I’ll walk you through the steps to access a former employee’s My Workspace, assign it to a supported capacity, and download the reports using Fabric Studio.

Read on for the instructions, and be sure to do the “Look at me. I am the captain now” meme when it works.

Comments closed

Power BI Projects and PBIR Format Admin Settings

Published 2025-11-21 by Kevin Feasel

Koen Verbeeck notes a new default:

The Power BI Enhanced Report Format (PBIR) will soon become the default, and that’s a good thing because it significantly makes git integration easier. You can already enable it in the preview features of Power BI Desktop (also enable PBIP and TMDL to make git integration of the model itself much easier).

Read on to see the administrative setting associated with this, as well as reasons why you should keep it on.

Comments closed

Binding Power BI Thin Reports to a Local Model

Published 2025-11-20 by Kevin Feasel

Ed Hansberry cuts the fat:

You may have an issue though where it isn’t in the service and you need to connect your report to a local model on your desktop. This can be useful if you need to do some testing and don’t want to connect it to a model in the service, or you temporarily don’t have access to the service. Let’s see how this works.

What you need:

  • Your thin PBIX report file. You can download this from the service if necessary.
  • Your local model in Power BI Desktop. It must be up and running.
  • Windows File Explorer

Read on for the process and a demonstration.

Comments closed

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.

Comments closed

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.

Comments closed

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.

Comments closed

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.

Comments closed

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.

Comments closed

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.

Comments closed

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.

Comments closed