Press "Enter" to skip to content

Category: Power BI

Building Dashboards to User Expecatations

Ruben Van de Voorde provides some advice:

Data visualization has entered the era of “articulate it and let AI build it”. AI coding agents have cut the cost and effort required to create novel digital experiences, and the landscape of tools at our disposal to show data to our users keeps expanding. When each new dashboard can come with its own way of selecting, highlighting, and clearing selections, we run the risk of reinventing UX patterns in similar but different ways. A prompt such as “make an interactive dashboard of these sales” doesn’t say how UX should work, so every agent invents its own UX. Let’s relate it back to — what did you expect — semantic models to show what we mean.

To be blunt, very little of the specific advice has anything to do with AI agents. The same problems happen with dashboards humans create entirely, and the same good guidance applies.

Leave a Comment

Making the Power BI Gantt Chart Useful

Valerie Junk shares some tips:

If you drag the new Power BI Gantt chart onto your report page and add a task with a start and end date, you get… well, a Gantt chart! But does it really tell you anything? A project plan is there to answer questions: where are we, what’s late, and who’s working on it? 

The good news: you don’t need anything fancy. With a few tweaks in the format pane, you can get a long way!

Click through for seven tips to turn this from a mess into a practical visual.

Leave a Comment

Report Bursting with Dataflows Gen2 and Action Sequences

Chris Webb follows up on a prior post:

A couple of weeks ago I wrote this post about how you can use the new Send Email action in Dataflows Gen2 to send out email-based reports to a list of recipients. I did it by creating a parameterised Dataflow – which worked but the end result was slow and therefore expensive. So I started thinking about other approaches and it turns out there is indeed another way of solving the problem, using a whole branch of M functions that is not properly documented and which I’ve never used before.

Read on to learn more about these Action Sequences.

Leave a Comment

The IsAvailableInMDX Flag in Power BI Semantic Models

Phil Seamark explains:

There is a property in Power BI semantic models you can set per column called IsAvailableInMDX. When most people discuss this property, the first question often asked is, “Are you using Excel to query the semantic model?”. If the answer is no, the usual follow up is “turn it off everywhere, you will save memory and your refresh will be faster”.

For Import models, turning it off can save memory by removing a supporting structure from a column. But a DAX query may have been making good use of that structure, particularly when filtering the column. Direct Lake is different: it uses its column dictionary for these DAX optimisations, but the setting still matters for Excel field availability.

Read on to learn whether your environment might benefit from this, as well as other considerations.

Leave a Comment

Optimizing Power BI Semantic Models via Column Splitting

Phil Seamark provides some advice:

Column splitting is an idea worth testing when you are looking to reduce the size of a large semantic model to potentially reduce the SKU required to host the model. The good news is, the technique can also benefit the time to load data into a model and speed up your DAX queries.

Instead of storing each complete value in one column, split the column vertically and store it in smaller pieces. Then use a DAX measure to combine the pieces back together. Those pieces often repeat more frequently, which can help Power BI compress them.

What’s interesting is how similar this approach is to financial systems from back in the day, where all money was stored as two separate integers. In that case, it was for the sake of precision and correctness rather than performance, but it’s nice to see these techniques still kicking.

Leave a Comment

Administering Power BI at Scale

Heidi Hasting shares some notes:

PPCC26 has wrapped up and I am still buzzing. A huge thank you to everyone who came along to Power BI Administration at Scale: Governance Patterns for Enterprise Deployments with Shabnam Watson and me. I promised I would share the demo code, so here it is.

In this post, I’m going to cover:

  • A quick recap of the session
  • How this builds on my earlier tenant settings post
  • What the demo does and how it works
  • Where to download the notebook and the full kit

Click through for that recap as well as some extra details and tools.

Comments closed

Where the Business Logic Lives in Power BI

Teo Lachev answers a question:

A current engagement calls for migrating a rather elaborate financial dashboard from Qlik to Power BI. Just when we think there is light at the end of the tunnel, another business rule is unearthed in Qlik that we need to convert. These rules range from business calculations and dummy rows in dimension tables to allocation overrides.

This brings us to an important question: Where should all this business logic live?

Click through for Teo’s answer to this question.

Comments closed

Power BI for Nonprofits

Stephanie Bruno breaks out the green visor:

Your nonprofit is ready to escape spreadsheet chaos and move into Power BI. Then you open the licensing page. Pro? Premium Per User? Fabric capacity? F2, F64, F-what?! If you’re a nonprofit trying to make every dollar count, figuring out what to buy can feel like reading a spellbook in a language you don’t speak. We get this question a lot, so here’s our plain-language guide.

Prices below are in USD and current as of October 2026. Microsoft changes licensing pretty often, so always double-check the official nonprofit offers page before you buy.

Read on for several tips on how to get the most out of Power BI if you do work for a non-profit organization.

Comments closed

Using a Continuous Axis for Date Tables in Power BI

Marco Russo and Alberto Ferrari gussy up a visual:

In a previous article, Creating a simpler and chart-friendly Date table in Power BI, we showed you how to create a Date table you can use in a line chart with a continuous X-axis instead of a categorical one, even when the granularity is the month rather than the day. That technique stores every level as a DateTime column and relies on custom format strings to display the month name.

The auto date/time feature in Power BI provides the same user experience using a different technique. Its hidden date table uses text columns for quarters and months, sorted by a numeric column. However, the line chart still offers a continuous X-axis when you drill down to the month level. We keep saying that auto date/time is not a best practice, but this behavior is useful. Can we obtain it with our own Date table? Yes, we can.

If you have a Date table in your model (as you should!), this article explains how to enable the continuous X-axis in your report when the user groups dates by year, quarter, month, or week.

Click through to see how it looks, as well as how it works.

Comments closed

Full-Text Indexing and Power BI Semantic Model Refresh Times

Chris Webb runs a test:

The September release of Power BI saw the introduction of a powerful new feature: full text indexing, which makes searching and filtering on text columns much faster and enables the use of the new TextContains() and TextSimilarity() DAX functions. You need to enable it on a per-column basis and when you do that you have the option to rebuild the full-text index for those columns when you do a Full refresh or when you do a refresh of the type Indexes. So the big question is: how long does it take to build a full-text index on a column and what impact will it have on your overall refresh times?

Read on for that answer in a reasonably-sized dataset containing street addresses.

Comments closed