Press "Enter" to skip to content

Category: Power BI

GUID Hunting for Power BI Performance Load Testing

Published 2025-07-17 by Kevin Feasel

Gilbert Quevauvilliers finds some UUIDs:

When completing the Power BI performance load testing, you will need to get details from your Power BI report and App Workspace, which will later be used in the PBIReport.JSON file.

In this blog post I will show you how to find those details, so that when it comes time to add it to the PBIReport.JSON file, it will be easy to plug the values in.

The reason for a separate blog post is because you will have to find the GUIDs that are used, which takes a bit of time and knowledge to find the correct GUID for the right value.

Click through for the most unsatisfying Easter egg hunt you could imagine. Gilbert then continues to pull out slider and filter data values.

Leave a Comment

Building a Pareto Chart in Power BI

Published 2025-07-10 by Kevin Feasel

Boniface Muchendu creates a Pareto chart:

Creating a Pareto chart in Power BI is a powerful way to visualize the 80/20 rule in action. This type of chart helps you quickly identify the top contributors to your business metrics—whether you’re analyzing sales, categories, or customer segments. In this guide, you’ll learn how to build a dynamic Pareto chart using DAX, customize it, and apply it across different data dimensions.

Read on for the instructions.

Leave a Comment

The Importance of Power BI Performance Load Testing

Published 2025-07-09 by Kevin Feasel

Gilbert Quevauvilliers runs some tests:

It is becoming increasingly important to understand how the Power BI reports/Semantic Model that are being used in your organization are performing.

When using Fabric Capacities this can potentially be of critical importance, because a single report that is not well designed could cripple or bring down your capacity.

By completing Power BI Performance load testing before it goes into a production environment allows for scalable, dependable, repeatable testing to take place in lower environments.

Read on to see what this entails and the tool Gilbert will use throughout this series.

Leave a Comment

Drop Shadows and Power BI

Published 2025-07-07 by Kevin Feasel

Elena Drakulevska has some thoughts on drop shadows:

I get why people add them. Shadows might feel like a design upgrade. A quick way to make your visuals pop or feel more “finished.”

But here’s the thing: just like rounded corners, drop shadows are easy to overdo—and they’re not actually helping. Not with clarity. Not with accessibility. Definitely not with UX.

Click through for Elena’s full thoughts. I’m generally against drop shadows. They draw visual attention without providing the report viewer any value. That’s chartjunk.

Leave a Comment

Thirteen Power Query Tips

Published 2025-07-03 by Kevin Feasel

John Kerski has a baker’s dozen:

When I first started with Power Query, it was in Excel, through the Power Pivot feature. I was amazed at how I could transform data with just a few clicks and quickly create PivotTables. Then, when Power Query appeared in Power BI, I began working with larger data sources and more complex projects.

Through many trials and tribulations, I learned the capabilities of Power Query and the M language (the functional language that actually transforms our data), as well as its idiosyncrasies. Unsurprisingly, with Power BI adoption and rapid growth, many newcomers are learning the same lessons I did.

Read on for some of John’s early pain points. By the way, regarding John’s banker’s rounding note, that’s the norm for .NET, though not for Excel or SQL. It’s also more accurate in the aggregate than “to the 5’s” rounding, though it can be confusing to people who aren’t expecting it.

Leave a Comment

Month-over-Month and Year-over-Year Calculations in Power BI

Published 2025-07-03 by Kevin Feasel

Boniface Muchendu does a bit of comparison:

Power BI variance measures are essential for delivering actionable insights through dynamic comparisons like month-over-month (MoM) and year-over-year (YoY) performance. This guide shows how to build flexible, filter-aware DAX measures and apply them within clean, user-friendly visuals to enhance your reports.

Click through to see them in action.

Leave a Comment

Enumerating Template Types in Power BI

Published 2025-07-01 by Kevin Feasel

Oscar Martinez lays out the list:

A Power BI Template can mean very different things depending on who you ask. Are we talking about a .PBIT shell, a JSON theme, a turnkey Template App, or merely a thin report wired to a central model?

In this post, we cut through the ambiguity and lay each option side‑by‑side. You’ll learn what’s inside every “template” type and the trade‑offs that matter in real‑world projects—so the next time someone says “just use a template” you’ll know exactly which one fits the bill.

Click through for the post. Also, note that each section is in a drill-through div, so you might accidentally miss some information if you haven’t expanded each topic.

Leave a Comment

Changes to Power BI’s Publish to Web

Published 2025-06-30 by Kevin Feasel

Boniface Muchendu looks at some changes:

Power BI includes a powerful feature called Publish to Web, which allows users to share interactive reports publicly without requiring viewers to sign in. While this tool simplifies access, it can also create security risks if misused. In this guide, you’ll learn what “Publish to Web” does, how Microsoft updated it for better governance, and how to manage access responsibly.

Click through to see what’s new.

Leave a Comment

Choosing Fields to Hide in Power BI

Published 2025-06-26 by Kevin Feasel

Reza Rad has something up his sleeve:

To tidy up your Power BI solution, there are some options, and one of them is hiding fields from the report view. This option, although simple, has a significant impact on making your Power BI solution very tidy and clean and easier to maintain. However, you might wonder what are fields that have to be hidden in Power BI? In this article, I will explain how to hide a field in report view, and then what are fields which are a good candidate for this option. If you like to learn more about Power BI. Read Power BI book from Rookie to Rock Star.

The very short answer is, hide things that business users won’t (or shouldn’t) care about. Reza gives much more guidance on the topic.

Based on the comments section, this appears to be a re-post from several years ago, but still worth reading because the content is evergreen.

Comments closed

Writeback Options in Power BI

Published 2025-06-25 by Kevin Feasel

Jon Vöge comes continues looking at Power BI writeback:

This blog has previously covered the basics of native Microsoft Fabric / Power BI write-back with Translytical Task Flows.

In my first post on the subject, we created a simple Comment/Annotation solution, allowing the user to input free text comments on Data Points directly in Power BI.

However, Translytical Task Flows do not only support Free Text as an input type for the users of your reports. All of the new & updated Power BI Slicer visuals work with Translytical Task Flows, and we can use List and Button slicers for users to add categorical data to our task flows too.

Read on to see these other options in action.

Comments closed