Power BI Archives - Hat Full of Data

7th November 2025

Microsoft Fabric – Direct Lake and User Permissions

Direct Lake is the best way to build a semantic model on data in a Lakehouse or a Warehouse. We can then use Power BI to build reports and possibly even a make a Workspace App to deliver those reports to the business. So what permissions do the business users need to view those reports? This post will explore using...

Microsoft Fabric/Power BI

22nd September 2025

Power BI – Use ISINSCOPE to improve a Matrix

I recently had a request for totals in a Matrix to be shown for some columns and not for other columns. My solution was to use ISINSCOPE in a Matrix to work out which level of the matrix to choose what to return. Scenario At an event you sell tickets. So for the Cheese and Wine evening we can see...

DAX/Power BI

15th September 2025

Power BI – Counting Active records easily

Recently in a few Power BI projects and training courses we’ve needed to create a measure for counting active records based on start and end dates for a time period. This has varied from active projects, active employees to active contracts. All of them have had the common feature of start and end dates. Scenario Task Start End A 01-May...

Power BI

29th July 2025

Power BI – Improve a card with SVG

The not so new card in Power BI, introduced in 2023, includes some lovely features. The first is the simplest of adding multiple values and having cards laid out evenly in a row in a single visual. The second awesome feature adding an image to a card with SVG. Starting Point This report is visualising web site views per year....

Power BI/SVG

15th July 2025

Power BI – Calculation Groups aren’t scary

Let’s start by being honest, calculation groups scared me. I had read the brilliant articles, seen the demos and walked away going “hell no!”. Then in a training session a client asks for a visual that really really should be done with a calculation group, so I had to sit down and get my head around them. This post is...

Power BI

11th June 2025

Power BI – Create a calendar using TMDL

TMDL is short for Tabular Model Definition Language in Power BI desktop. It allows us to script definitions and changes to a Power BI model. In this post I use TMDL to quickly create a calendar for a report that includes column options such as sort by, formatting and hidden columns. Calendar Table Nearly every report I create includes a...

Power BI

12th May 2025

First refresh it broke! #LauraBrokeIt

I set up my dataflow and it was working great. Then it broke on the refresh. Here is how I fixed it. Previously In the previous post we ingested a SharePoint folder into a table in a Lakehouse. That is a well known process and nothing new except for one thing. I split the process into two stages, firstly the...

Dataflow/M/Microsoft Fabric

6th January 2025

Power Query – Creating New Parameters

Good practice is to use parameters for these values so your query is reusable etc. And its always our intention to go and create the new parameter later.

Power Query/Excel/Power BI

23rd September 2024

Inherited Value in a Parent Child Pattern

There are times it is useful to calculate an inherited value from parent item to child. The target date of a feature to be passed down to the child user story and then onto the child tasks.

Power BI/DevOps

2nd September 2024

DevOps Parent Child Hierarchy in Power BI

Azure DevOps is built around the pattern than items have child items and so a backlog view will show the items in a hierarchy. When the work items some into Power BI that is not shown. So this gives me the chance to use one of my favourite resources, DAX Patterns and their Parent-Child pattern.

Power BI/DevOps

Category: Power BI

Microsoft Fabric – Direct Lake and User Permissions

Power BI – Use ISINSCOPE to improve a Matrix

Power BI – Counting Active records easily

Power BI – Improve a card with SVG

Power BI – Calculation Groups aren’t scary

Power BI – Create a calendar using TMDL

First refresh it broke! #LauraBrokeIt

Power Query – Creating New Parameters

Inherited Value in a Parent Child Pattern

DevOps Parent Child Hierarchy in Power BI