Koen Verbeeck's Avatar

Koen Verbeeck

@koenv

BI pro and tattooed #sqlserver geek. Data warehousing. Former Data Platform MVP. Punk rock fan. Married & father of 2. He/him @koen@dataplatform.social.

587
Followers
275
Following
725
Posts
26.07.2023
Joined
Posts Following

Latest posts by Koen Verbeeck @koenv

If the agent is a human, I'd expect less than 10 mins. If chatbot, immediately.

10.03.2026 10:50 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

They expire?

10.03.2026 10:49 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Stuff like this shouldn't be that hard. It's like MS is deliberately throwing hurdles in the path to a true enterprise data platform.

10.03.2026 09:00 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

The MI is part of the security group in the tenant setting you mentioned and contributor on the workspace, but still the pipeline fails. Annoying. I'm thinking it's the notebook activity in the pipeline that is causing this, hence the need to use a notebook connection.

10.03.2026 08:58 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

I'd rather use something that doesn't have secrets that expire. The thing I want to solve is that I want to trigger a Fabric Pipeline from ADF using the ADF managed identity, but for some reason the pipeline fails (again with user token issue).

10.03.2026 08:57 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

I get that you need to do this for service principals, but workspace identities? They're part of the system itself (yes, I know they're service principals behind the scenes).

10.03.2026 08:54 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

OK, that's annoying as we work with a new workspace for each git branch, and each time adding the workspace identity to the security group is major overhead since we cannot do this ourselves (and we don't have this Entra ID permission at most of our clients)

10.03.2026 08:53 πŸ‘ 0 πŸ” 0 πŸ’¬ 2 πŸ“Œ 0

anyone got the new notebook connection working with a workspace identity from a data pipeline? #microsoftfabric cc @erwindekreuk.bsky.social

09.03.2026 11:13 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Post image

You would think that if you run your own #MicrosoftFabric capacity, that queueing would be less...

09.03.2026 11:05 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Oh wait, I've read the entire thing now. Yes, it's that time of the year again πŸ˜…

06.03.2026 13:46 πŸ‘ 2 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Nope, we change on the 29th of March.

06.03.2026 13:45 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Preview
I’m Not Gonna Waste Time Debunking Crap onΒ LinkedIn. LinkedIn is full of absolute trash these days. Just flat out bullshit garbage. (Oh yeah, that - this post should probably come with a language disclaimer, because this stuff makes me mad.) People wanna look impressive without actually putting in the work to gain real knowledge. They're asking ChatGPT to write viral "expertise" knowledge posts for them, and they're publishing this slop without so much as testing it.

I’m Not Gonna Waste Time Debunking Crap onΒ LinkedIn.

LinkedIn is full of absolute trash these days. Just flat out bullshit garbage. (Oh yeah, that - this post should probably come with a language disclaimer, because this stuff makes me mad.) People wanna look impressive without actually putting in…

06.03.2026 13:16 πŸ‘ 8 πŸ” 2 πŸ’¬ 4 πŸ“Œ 0

There are so many of these crap posts nowadays in my feed. "SQL Logical query order" "Why you should use CTEs" "How to remove duplicate rows" and so on. @drsql.bsky.social has apparently the patience of an angel to comment on them to point out mistakes :)

06.03.2026 13:29 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Preview
ADF Pipeline Debugging Fails with BadRequest - The Sequel 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 th...

New blog post: #Azure Data Factory Pipeline Debugging Fails with #BadRequest – The Sequel sqlkover.com/adf-pipeline...

06.03.2026 10:08 πŸ‘ 2 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0
Preview
What's New in SSIS 2025? Discover new features of SSIS in SQL Server 2025 and learn if an upgrade makes sense for your on-premises solutions.

New article: What’s New in #SSIS2025? (TL;DR not much :)
www.mssqltips.com/sqlservertip... #ssis #sqlserver

05.03.2026 12:05 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

What's the point of having a database if the data can't go out? πŸ€ͺ

04.03.2026 19:26 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Post image

#MicrosoftFabric community down?

03.03.2026 10:57 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Preview
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 l...

New blog post:
How to Parameterize #MicrosoftFabric Linked Services in #Azure Data Factory for #AzureDevops Deployment sqlkover.com/how-to-param...

03.03.2026 08:44 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Ooo take care. I had kidney stones and I do wish them upon my worst enemies πŸ˜…

01.03.2026 09:16 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

It might be my background as an SSIS developer, but I like the clicky-draggy-droppy development in the browser :D

24.02.2026 14:44 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

It's not permissions, as it works perfectly fine if I define the git integration manually. The git integration is obviously only for the development environment. ADF code is pushed to the other envs using ARM.

24.02.2026 14:34 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Devops.I specified a custom collaboration branch (adf_main), publish branch is adf_publish, root folder is /adf. All through bicep. When I disconnect to git integration and re-connect, it does work.

24.02.2026 13:46 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Post image

I get this nasty error in #Azure Data Factory. Any ideas?

24.02.2026 13:10 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Post image

Use the TOJSON and TOCSV functions to inspect the content of intermediate table variables when debugging a DAX measure.
Article + video available!

#powerbi #dax

https://www.sqlbi.com/articles/debugging-dax-variables-using-tojson-and-tocsv/

24.02.2026 11:04 πŸ‘ 4 πŸ” 3 πŸ’¬ 1 πŸ“Œ 0
Preview
Develop SSIS Packages with SSIS 2025 In this tip, we show you to develop SSIS 2025 packages for SQL Server 2025, and how you can migrate existing projects to the latest version.

New article: Develop #SSIS Packages with #sqlserver2025 www.mssqltips.com/sqlservertip... > another SSIS article in my series :)

24.02.2026 09:49 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

I did some testing with data clustering in the #MicrosoftFabric warehouse and damn, that database is quite fast on an F2.

23.02.2026 09:41 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image

Introducing MicrosoftFabricMgmt: Managing Microsoft Fabric with PowerShell

Introduction If you have been following this blog for a while, you will know that I am a huge fan of using PowerShell to manage and automate things. SQL Server, dbatools, dbachecks β€” auto
blog.robsewell.com/blog/introdu...

23.02.2026 07:52 πŸ‘ 4 πŸ” 3 πŸ’¬ 1 πŸ“Œ 0

Two questions:
1. Can you also use it for Power BI Pro stuff? (I assume yes)
2. If used in Azure Devops, can I use it with a service connection with federated identity, and don't have the need for a secret that expires?

23.02.2026 08:15 πŸ‘ 0 πŸ” 0 πŸ’¬ 2 πŸ“Œ 0

So. Annoying.

17.02.2026 08:10 πŸ‘ 5 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Preview
Loadtesting Microsoft Fabric, partΒ II This blog can also be known as 'The Sequel', not to be confused with SQL, even though Fabric SQL will be mentioned in this blog. Anyway, I digress and don't call me Shirley. For those of you who have been following this blog for a long time, you may have read the posts on Fabric where I'm comparing the F64 Trial with the F2, and other shenanigans.

Blog alert!

I've revisited my loadtests in Fabric and wrote them down. Enjoy!
#MicrosoftFabric
#LoadTesting
#Lakehouse
#Warehouse
#Eventhouse
#FabricSQL

16.02.2026 15:00 πŸ‘ 1 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0