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 do because it’s great fun and […]
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. The relationship between the fact […]
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 placed search and replaces should […]
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 database server. If up-time is good […]
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 take this moment to thank you […]
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 the last years). So I’m […]
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 Minéral – comes from the […]
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. So it is the time […]
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 table) I would end up […]
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 time I had already applied Service […]