If you want to set up Continuous Integration using Visual Studio Team Services (VSTS) in order to build your BI projects, you'll run into the fact that some project types can be built and released out-of-the-box by MSBuild, while others need specific logic to create or deploy artifacts. In this post, I share my current
Continue reading...
Storing and processing personal data In case your data warehouse processes and stores sensitive data such as social security or credit card numbers you could implement a mechanism to secure this data. In case you store the data on a MS SQL Server database, one way to do this is by using Always Encrypted. If
Continue reading...
Recently Microsoft re-launched PowerBI Embedded as part of the PowerBI Premium offering. Instead of a pay-per-view pricing model Microsoft now offers dedicated capacity. There are three parts to get this new PowerBI Embedded working: Configuration in Azure (Register an app, activate the PowerBI Embedded capacity) Configuration in the PowerBI service (create a PowerBI app and
Continue reading...
One of the cool features of Power BI are workspaces. They make it possible to work together on reports, share information, share reports, share datasets, etc. You can add administrators and members. Members can be read-only, or report authors. I often see that members are set to be read-only. There is another way to have
Continue reading...
I see a new pattern emerge: every time I want to write a blog post about something I've been thinking about, I discover some content that's way better than I could ever produce. Just like last week's Wikipedia article contained everything I wanted to say, so today there's an article making a far better point
Continue reading...
I've been thinking about writing three posts:
Continue reading...
In this post I am going to discuss how to design a dashboard in Power BI. What makes a good dashboard work? I think a good dashboard tells you immediately how you are doing. Not just "show me the numbers". KPI's are just as important. What is a measure without a target?
Continue reading...
I have been very curious about Azure Data Lake. So I started experimenting with it. In this post I share with you my thoughts about it.
Continue reading...
I've been looking into DWA for a few months now, and might give it a try sooner or later. Here's some thoughts about it:
Continue reading...
In my previous post I explained how to enable row level security on your SQL database. However, if you use Power BI as a live connection to your database, it will filter according to the user that is used in the data gateway. This effectively means that you cannot rely on sql row level security
Continue reading...