Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at element61, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

T-SQL Tuesday #88 – The daily (database-related) WTF

It’s the time of the month again: the T-SQL Tuesday! This month’s edition is hosted by Kennie Nybo Pontoppidan (blog|twitter) and the topic is “daily database related WTF”. In other words, we get to tell one of our horror stories we encountered in our career as… Read more

0 comments, 180 reads

Posted in Koen Verbeeck on 14 March 2017

Hands-On Data Analysis With Power BI Desktop at PASS BA Marathon

I’m delighted to announce I’ll give a session at the next PASS BA webinar marathon. The topic of this marathon is Data Driven Storytelling and Data Discovery. My session will focus on working with Power BI Desktop: getting data in, cleaning it, creating a model and visualizing the data.… Read more

0 comments, 118 reads

Posted in Koen Verbeeck on 6 March 2017

Webinar – Executing, Configuring and Scheduling SSIS 2016 Packages

I’ll be giving a webinar for MSSQLTips.com at March 30th. It’s a sponsored webinar, meaning there will also be a vendor to talk about JAMS,  a scheduler that “runs, monitors and audits critical processes across a diverse array of servers and business applications”. Anyway, the title is Executing, Configuring and… Read more

2 comments, 1,024 reads

Posted in Koen Verbeeck on 1 March 2017

Not An Administrator For Analysis Services Tabular

A couple of weeks back I installed SQL Server 2016 on my personal machine, including SSAS Tabular. Yesterday I created a new Tabular model project in SQL Server Data Tools. When I had to choose where to locate the model – integrated or a server workspace – I got the… Read more

0 comments, 970 reads

Posted in Koen Verbeeck on 28 February 2017

Updates to the Power BI course

Recently I published an open-source course/workshop to learn Power BI Desktop. Fellow MVP Dan English (blog | twitter) gave me the excellent feedback that IMDB actually doesn’t like people scraping their website for data. Furthermore, the OMDB API appears to have fallen almost out of funds and is… Read more

0 comments, 142 reads

Posted in Koen Verbeeck on 16 February 2017

Open Source Power BI Desktop Workshop

I’ve created a free, open-source workshop to teach people the capabilities and features of Power BI Desktop. I was inspired to do this by Brent Ozar, who also created a free open-source course How to Think Like the Engine. If you haven’t checked out that course, make sure you… Read more

9 comments, 430 reads

Posted in Koen Verbeeck on 13 February 2017

Missing Checkbox for Security Filter in Power BI Desktop

Just a quick blog post so that other people don’t waste 15 minutes of their life looking for a missing checkbox.
I was implementing security using roles in a Power BI Desktop model. I had defined the role along with its filter on top of a many 2 many relationship.… Read more

0 comments, 708 reads

Posted in Koen Verbeeck on 9 February 2017

Dynamically Changing Shapes in Power BI – Alternatives

NOTE: the DAX presented in this blog post is written in my locale (nl-BE). This means that semicolons are used in the functions and lists instead of commas. Also, we use the comma as the decimal seperator. 0.95 (in the US) is 0,95 in my locale. A couple of well… Read more

13 comments, 813 reads

Posted in Koen Verbeeck on 8 February 2017

Dynamically Changing Shapes in Power BI

UPDATE: I also published a blog post using a DAX only approach. Check it out here.

Recently someone had a question if it was possible to change the color of a shape depending on the value of a measure. Imagine for example a dashboard with the picture of a… Read more

9 comments, 1,377 reads

Posted in Koen Verbeeck on 7 February 2017

Microsoft Data Platform MVP Award

I’m very pleased, humbled, surprised and overall gleeful to announce I’m awarded the Microsoft Data Platform MVP 2017 Award.
This is a great honor and I’m grateful for all the support I’ve received of Microsoft, my peers and the SQL Server community over the past years. I’d like to… Read more

3 comments, 200 reads

Posted in Koen Verbeeck on 2 February 2017

Speaking at Techorama 2017

I’m delighted to announce that I’m selected as a speaker for the Techorama event.
Techorama is a developer congress focusing (but not limited to) Microsoft technologies. This year, the event is even bigger as they have merged with the IT Pro event ITPROceed (where I have spoken 3 times in… Read more

0 comments, 141 reads

Posted in Koen Verbeeck on 31 January 2017

Help me raise money for cancer research #tourneeminerale

In Belgium, a national campaign is launched to raise money for cancer research: #TourneeMinerale. In this campaign, people can be sponsored for not drinking alcohol for the whole month of February 2017. This sponsor money is donated to the national cancer research center. The name of the campaign – Tournée… Read more

0 comments, 197 reads

Posted in Koen Verbeeck on 19 January 2017

T-SQL Tuesday 86: SQL Server Bugs & Enhancement Requests

 Let’s kick off the new year with a T-SQL Tuesday! This month’s edition is hosted by Brent Ozar:

Announcing T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests

Brent wants us to blog about our favorite Connect items because Microsoft is currently listening to its customers and actually closing items.… Read more

0 comments, 218 reads

Posted in Koen Verbeeck on 10 January 2017

Clustered Columnstore Index really hates Updates

First a little background. I’m working on a large fact table that behaves itself as a slowly changing type 2 dimension. Weird right? But I have a good reason for this: it’s a snapshot table and if I would create the snapshots like you’re supposed to (by exploding the fact… Read more

2 comments, 1,210 reads

Posted in Koen Verbeeck on 23 December 2016

Master Data Services Error – Missing Temp Directory

I recently had to install SQL Server 2016 again on my Windows 10 machine. This also meant that I had to install and configure MDS as well. Last time it didn’t went so smoothly: Master Data Services error – Cannot read configuration file due to insufficient permissions. However, this… Read more

2 comments, 266 reads

Posted in Koen Verbeeck on 15 December 2016

SSIS Naming Conventions 2.0

People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server MVP Jamie Thomson: Suggested Best Practises and naming conventions. The blog post served as a guidance point for many SSIS projects regarding naming conventions of the various tasks and… Read more

5 comments, 2,549 reads

Posted in Koen Verbeeck on 2 December 2016

Problem where you can only browse Google websites

Note: not a SQL/BI related post like usual, but since it’s a common issue I want to share my solution here

Quite recently I had a bizarre issue on my laptop: suddenly I could only browse Google websites (Google search, YouTube, Gmail …). All the other websites would time out… Read more

0 comments, 233 reads

Posted in Koen Verbeeck on 1 December 2016

Calculate a semi-additive average in DAX

A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure that can be summed across some dimensions, but not all. Typically it’s the time dimension that isn’t additive. For example, the stock level at various warehouses. You can add all… Read more

0 comments, 380 reads

Posted in Koen Verbeeck on 24 November 2016

SQL Server 2016 service pack 1 is here!

SQL Server 2016 service pack 1 has been released and it is a mayor one! You can download it here.
Why, you ask, is it so important? Because a lot of Enterprise Edition database engine features are now available in the other editions as well. In other words, you… Read more

0 comments, 1,897 reads

Posted in Koen Verbeeck on 22 November 2016

Book Review – Power Pivot and Power BI

Since Power BI is all the rage right now, I was in need of some material to spice up my knowledge of DAX (read: finally understand how CALCULATE works). I’ve been following the website powerpivotpro.com for quite some time now and they always have very insightful articles about DAX and… Read more

0 comments, 1,653 reads

Posted in Koen Verbeeck on 15 November 2016

Older posts