-->
SQL Clone
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.

Archives: April 2016

Dynamic Security in Power BI

UPDATE: the feature has changed since its introduction. For more information, see the update at the bottom of the post.

In case you haven’t noticed, Power BI added a new feature in preview mode: row level security (RLS). This blog post describes how you  can use this feature to implement… Read more

5 comments, 1,864 reads

Posted in Koen Verbeeck on 28 April 2016

Power BI Service error: “This visual has unrecognized fields”

Recently I stumbled across a quite annoying error in the Power BI service. I uploaded two working reports from Power BI Desktop to the cloud service. Each report connects to its own cube and both cubes are in the same SSAS MD database. On the server, I have a gateway… Read more

4 comments, 1,641 reads

Posted in Koen Verbeeck on 22 April 2016

Loading Data into Clustered Columnstore Index with SSIS

I’m using a clustered columnstore index (CCI) on one of my fact tables at a client. The row size is between 8 and 9 million rows and I was wondering how I could load data efficiently in this CCI using SSIS.

I stumbled upon this MSDN blog post: SQL Server… Read more

0 comments, 942 reads

Posted in Koen Verbeeck on 21 April 2016

Overview of Published Articles – 2016Q1

Here is an overview of the articles I published in the first quarter of 2016.

R Services series:

SSIS & AlwaysEncrypted:

Read more

0 comments, 307 reads

Posted in Koen Verbeeck on 19 April 2016

SSIS Trick: Adding Multiple Packages to a Project

A little SSIS trick today. Sometimes you start a new Integration Services project and you want to add some existing packages to this project. So you can right-click the SSIS Packages node and choose Add Existing Package.

In the dialog, you choose the File System.

All you now… Read more

5 comments, 2,388 reads

Posted in Koen Verbeeck on 6 April 2016