Press "Enter" to skip to content

Day: February 25, 2026

Approval Workflows in Purview Data Governance

Published 2026-02-25 by Kevin Feasel

Barney Lawrence looks into a new old feature:


This is a feature that’s been missing from Purview for a while. It was built into the “classic” interface that was left behind by Microsoft at the tail end of 2024 for the new interface we have now. I don’t have the inside scoop on the reasoning behind the interface change but reading between the lines Microsoft had walked themselves into a few dead ends with the old interface that needed to be backed out of before they could start to flesh out the feature set and start moving forwards again.

Workflows were one of those lost features. A neat and relatively sophisticated way of defining control flows for approval, it looked a lot like Power Automate but wasn’t actually Power Automate i.e. there was an impossible task in keeping up with a key Microsoft product and replicating its features in parallel. The switch to the new interface backed out of that challenge and a year on we now have first sight of workflows in the new world.

Read on to see what has replaced this feature, as well as how it works today.

Leave a Comment

An Edge Case with Row Locks and Joins in PostgreSQL

Published 2026-02-25 by Kevin Feasel

Haki Benita digs into a problem:

Here’s a database riddle: you have two tables with data connected by a foreign key. The foreign key field is set as not null and the constraint is valid and enforced. You execute a query that joins these two tables and you get no results! How is that possible? We thought it wasn’t possible, but a recent incident revealed an edge case we never thought about.

If you answered “READ COMMITTED isolation level is weird,” congratulations: you win a prize.

Leave a Comment

Comparing Lakehouse and Warehouse Performance again

Published 2026-02-25 by Kevin Feasel

Gilbert Quevauvilliers provides some more comparisons:

I learnt a lot and based on the feedback people asked for me to compare the Lakehouse vs the Warehouse with 1 billion rows.

What I also did this time was to optimize anything I could with regards to loading data into the Lakehouse or the Warehouse based on the feedback I received.

Below is a list of the changes I made

Read on for those changes and how they affected performance. That’s the tricky part about performance comparisons: unless you know how to tweak all options equally, you can end up with skewed results.

I’d also be interested in how the Eventhouse fares. I believe that, when it comes to data retrieval, the Eventhouse is the fastest option available to us.

Leave a Comment

Debugging DAX Variables via TOJSON() and TOCSV()

Published 2026-02-25 by Kevin Feasel

Marco Russo and Alberto Ferrari write out some intermediate results:

In a previous article, Debugging DAX measures in Power BI, we described several techniques to find errors in a DAX formula. The most basic approach, one that requires no external tools, is to temporarily change the RETURN statement of a measure so that it returns the value of an intermediate variable instead of the final result. When the variable contains a scalar value such as a number or a string, this is straightforward: you change the RETURN, observe the result in the report, and compare it with your expectations.

Read on to see how these functions work.

Leave a Comment

An Introduction to MicrosoftFabricMgmt

Published 2026-02-25 by Kevin Feasel

Rob Sewell has a series of posts on MicrosoftFabricMgmt. The first post provides an introduction:

I have been introducing the Microsoft fabric-toolbox — covering the toolbox itself, FUAM, and FCA. All excellent tools. But there is one item in the toolbox that I have been personally involved in building, and it is the one I am most excited to write about.

Today I am kicking off a series of posts about MicrosoftFabricMgmt — an enterprise-grade PowerShell module that gives you comprehensive, scriptable control over the entire Microsoft Fabric REST API. It is hosted as part of the fabric-toolbox on GitHub.

The second post covers installation and authentication:

Yesterday I introduced the MicrosoftFabricMgmt module and explained what it can do. Today we are getting hands on — installing the module, sorting out dependencies, and making your first connection to Microsoft Fabric.

By the end of this post you will have the module installed, be authenticated, and have your first list of Fabric workspaces in your terminal.

The third post involves not having to deal with a bunch of GUIDs:

Which workspace is 948d3445-54a5-4c2a-85e7-2c3d30933992? Which capacity? Who knows — go look it up. Multiply that by fifty items across ten workspaces and you have a frustrating afternoon ahead of you.

The PowerShell Module**MicrosoftFabricMgmt** solves some of this frustration.

Leave a Comment