A while ago I blogged about a use case where a pipeline fails during debugging with a BadRequest error, even though it validates successfully. If you’re wondering, this is the helpful error message that you get: In that blog post, the issue was that there were some lingering user properties that were configured incorrectly and […]
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure Data Factory instance (or Azure Synapse Pipelines) and you have a couple of linked services that point to Fabric artifacts such as a lakehouse or a warehouse. You want to deploy your ADF instance with an Azure Devops build/release pipeline to […]
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at dataMinds Saturday. It’s a topic close to my heart, and I’ve always wanted to present on it. The slides can be found at GitHub. Hope to see you there!
SSMS 22 still inserting tabs instead of spaces
I’m not trying to start up a debate whether you should use tabs or spaces when indenting code. Personally, I prefer spaces because when I copy the code to another editor the outlining of the code remains the same while with tabs it’s not always the case (looking at you, Word and Outlook). But I […]
Power BI PBIR Format Admin Setting
The Power BI Enhanced Report Format (PBIR) will soon become the default, and that’s a good thing because it significantly makes git integration easier. You can already enable it in the preview features of Power BI Desktop (also enable PBIP and TMDL to make git integration of the model itself much easier). There’s also a […]
Logged in as a member of an Azure AD Group Error while Deploying DACPAC
Quite a long title for a short blog post 🙂While deploying a DACPAC (from a SQL Server Data Tools Database Project) through Azure Devops, I got the following error message: The user attempting to perform this operation does not have permission as it is currently logged in as a member of an Azure Active Directory […]
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be downloaded. Well, it cannot be downloaded from the user interface, that is. Suppose you have a report in a Power BI workspace (Pro, PPU, Fabric, it shouldn’t matter), and they’ve lost the original Power BI Desktop file. You try to download […]
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that was presented at the dataMinds Connect 2025 conference at GitHub.
Cloud Data Driven User Group 2025 – Slides & Scripts
The slidedeck and the SQL scripts for the session Indexing for Dummies can be found on Github.