Recently I have seen implementations of Analysis Services that go directly to the Data Lake. In order to speed things up and to remove redundancy, there is no relational data storage even if the data is relational in nature. Data is persisted raw in the lake and goes directly to a user friendly data model
Continue reading...
Uncategorized
The differences between Power BI Service and Power BI Report Server are well documented in the Planning a Power BI Enterprise Deployment whitepaper and the online documentation. The whitepaper by Chris Webb and Melissa Coates also includes a comparison between Power BI Service and Power BI Report Server (Jun 2017 version). Because this is a
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...
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...
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...
As you might know, I'm keeping an eye on how I can automate my Data Warehousing testing. In "Automated Testing for the Data Warehouse" my observation was In essence, testing a Data Warehouse isn't that complex It turns out I'm not the only one thinking about this (really? 😉 ). Some time ago I listened to
Continue reading...
One of the cool new features of SQL 2016 or SQL Azure is that you can add row level security to your database directly. So you don't need to use a cube or a tabular model to implement row level security. Let me show you how you can use it. The example is based on
Continue reading...
Just recently I was writing a very complicated query. Took me 2 hours to write. In the end I saved it as a view in the development database. I did not yet synchronize it back to the solution in visual studio, because I wanted to add a few related views for the problem I was
Continue reading...
The idea of organizational Business Intelligence was to create "One version of the truth, One Ring version to rule them all" errrr, well that was the idea. Away with all those Excels and bring on the conformed BI reports right? Of course it is a great idea to make sure you have a data warehouse where your data
Continue reading...