In my previous blog I showed how you can stream Twitter data to an Event Hub and stream the data to a Power BI live dashboard. In this post, I am going to show you how to store this data for long term storage. An Event Hub stores your events temporarily. That means it does
Continue reading...
Uncategorized
Some time ago a colleague of mine - let's call him John - was bouncing up and down, saying we need Power BI Premium. A report was not performing very well and he had read that Premium would give us dedicated capacity. A quick glance at the problem made me realize he was having trouble
Continue reading...
4 years ago I was a speaker for an event called "Power BI for municipalities". The first speaker showed some of the reports they had been making at their organization. The audience was very involved and enthusiastic. They simply loved it. The main feeling going through everyone's mind was "I want to start with Power
Continue reading...
Retrieving SharePoint Online List data SharePoint Online List data is one of those sources that can be of interest to integrate with other data in your Azure Data Platform. If your organization or client is already using SharePoint then Lists are often easy to set up and provide users a friendly way of data entry.
Continue reading...
It is quite common to update your skills in a product, Power BI for example. It is not so common to re-validate concepts or theory very often. For example "Joins are performance heavy", or "Data warehouses need surrogate keys". Usually these things don't change very often. Still it is important to update your view on
Continue reading...
In Microsoft BI, a tabular model is often the way to go. OLAP gets more and more often replaced by Tabular cubes and Power BI models. However, it's really hard to create a model that covers the whole enterprise. In this post I propose a solution for doing just that in a simple way. In
Continue reading...
The last two and a half years I have been helping organizations adopt and implement Power BI. With the right approach Power BI can be a huge success. But if you are not sure how to do it right, you might make the data landscape messier and more confusing. Here are the 5 simple lessons
Continue reading...
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...
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...