Press "Enter" to skip to content

Category: Power BI

Automating Power BI Load Testing via Fabric Notebook

Published 2025-10-22 by Kevin Feasel

Gilbert Quevauvilliers grabs a query:

Load testing is essential when working with Microsoft Fabric capacity. With limited resources, deploying a Power BI report without testing can lead to performance issues, downtime, and frustrated users. In this series, I’ll show you how to automate load testing using Fabric Notebooks, making the process faster, easier, and repeatable.

Inspired by Phil Seamark’s approach, this method eliminates manual complexity and allows you to capture real user queries for accurate testing.

Read on for the first part, in which Gilbert uses the Performance Analyzer to capture query details.

Comments closed

Toggling Light and Dark Modes in Power BI

Published 2025-10-21 by Kevin Feasel

Elena Drakulevska builds a switch:

We learned in the last post that while dark UI feels sleek, it’s not automatically accessible and it shouldn’t be your default strategy (hello, contrast + glare). In most cases, light mode is the more accessible baseline (just imagine trying to work on a sunny beach or on your balcony with dark mode… nightmare).

But UX is also about choice. Some users love light, some swear by dark. So let’s give them control.

Read on to see how, without sacrificing much accessibility.

Comments closed

Regular Expressions in Power BI TMDL View Find and Replace

Published 2025-10-21 by Kevin Feasel

Jon Vöge performs a search:

For this weeks blog, a quick tip about a feature in Power BI desktop which had flow entirely over my head: You can use RegEx for Find & Replace operations in Power BI Desktop TMDL View!

Yes! You heard that right!

I had no idea, until I caught it in a live demo by Power BI partner director Mohammad Ali at his Power BI Next Step keynote.

Read on to see what you can do with this. The same is possible in other tools like Visual Studio Code and even SQL Server Management Studio, though what specific regular expression capabilities are available and the exact syntax for them will differ based on the product.

Comments closed

Automating Semantic Model Security via Semantic Link

Published 2025-10-15 by Kevin Feasel

Marc Lelijveld writes a script:

You may be using standardized solutions like Fabric Unified Admin Monitoring (FUAM) or any other templated solution that comes with a semantic model. As part of transparency within your organization, you decided to share the insights gathered with others in the organization by adjusting the solution to apply your own security setup on top.

However, after running an update of the template, you’ve overwritten your custom security configuration and reapplying costs a lot of time, again and again after each update. Why don’t we just script this security? In this blog I will share how you can deploy security configurations to semantic models and assign users to these roles.

Click through for an example script and details on how it works.

Comments closed

Dealing with Many-to-Many Relationships in Power BI

Published 2025-10-14 by Kevin Feasel

Boniface Muchendu handles a many-to-many relationship:

Many-to-many relationships in Power BI are one of the most frequent challenges faced by new and intermediate users. These relationships can cause incorrect totals in visuals, confusing results, and slower report performance. In this guide, we’ll explore what many-to-many relationships in Power BI are, why they’re problematic, and how to fix them using the most effective methods available.

Click through for an enumeration of the problem as well as a couple of ways to resolve it.

Comments closed

Explaining Totals in Power BI

Published 2025-10-10 by Kevin Feasel

Sheil Bakhshi performs a comparison:

The long-running debate around how Power BI calculates totals in tables and matrices has been part of the community conversation for years. Greg Deckler has kept the topic alive through his ongoing “broken totals” posts on social media, often suggesting that Power BI should include a simple toggle to make totals behave more like Excel. His continued campaign prompted a detailed reply from Daniel Otykier in his article “No More Measure Totals Shenanigans“, and earlier, Diego Scalioni explored how DAX evaluates totals internally in his post “Cache me if you can: DAX Totals behind the scenes“.

This blog brings all those perspectives together from a scientific and comparative angle. It looks at how totals are calculated in Power BI and compares that behaviour with Tableau, Excel, Paginated Reports, and even T-SQL. The goal is not to take sides, but to clear up the confusion around what is happening under the hood.

This is a very detailed and dispassionate explanation that helps make sense of the debate.

Comments closed

Using Field Parameters in Power BI for Dynamic Views

Published 2025-10-08 by Kevin Feasel

Annamarie Van Wyk demonstrates how to use field parameters to slice data in Power BI:

If you’ve ever built a Power BI report and found yourself duplicating charts for daily, weekly, monthly, or yearly views — you’re not alone. It’s one of the most common (and frustrating) dashboard challenges: “Can we see this by day? Actually, make it by week. No wait — what about monthly?”

Instead of building five versions of the same visual, you can do it all with one — thanks to Field Parameters.

Read on to see how it all works.

Comments closed

Adding a Drillthrough Button in Power BI

Published 2025-10-01 by Kevin Feasel

Elena Drakulevska adds a button:

If you’ve been building Power BI reports, you probably know about drillthrough.

In short: drillthrough lets users move from a summary view to a detail page focused on one data point. For example, you can right-click on Austria in a sales chart and jump straight to a page showing visuals and metrics only about Austria.

Sounds powerful, right?

The catch: most users don’t even know it’s been implemented.

The other catch: those of us sad souls using Power BI Report Server don’t get drillthrough at all.

Comments closed

Finding Rows with Errors in Power Query

Published 2025-10-01 by Kevin Feasel

Gilbert Quevauvilliers goes around looking for trouble:

In the past when there has been an error when loading data into the semantic model, there can be times when clicking on the View errors can either take a very long time to show those errors. Or in some cases it never shows you the error.

In this blog post I am going to show you an alternative way to quickly find the errors.

The column quality data preview option is absolutely worth keeping on at all times.

Comments closed