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 dynamic security. In other words, the […]
Month: April 2016
Power BI Service error: “This visual has unrecognized fields”
UPDATE: IT SEEMS THE BUG HAS NOW BEEN FIXED. THREE HOORAYS FOR THE POWER BI TEAM! 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 […]
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 2016 SSIS Data Flow Buffer […]
Overview of Published Articles – 2016Q1
Here is an overview of the articles I published in the first quarter of 2016. R Services series: SQL Server 2016 R Services: Executing R code in SQL Server SQL Server 2016 R Services: Display R plots in Reporting Services SSIS & AlwaysEncrypted: Reading Always Encrypted Data with SQL Server Integration Services 2016 Writing Always Encrypted […]
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 have to do is choose the package […]