A modern data platform should be able to handle streaming data, both in batch and real time. We as a society have come to expect organizations and people to respond to situations fast . We cannot always wait a day until the data warehouse has processed the nightly batch to analyze the data the next
Continue reading...
If you would like to automate Power BI deployments, or want to include Power BI reports in your devops pipeline you should check out Power BI Actions which a former colleague of mine created: https://marketplace.visualstudio.com/items?itemName=maikvandergaag.maikvandergaag-power-bi-actions Power BI is both a self service BI and an enterprise BI tool. In a lot of cases, people publish
Continue reading...
If you ever have created a stacked column chart in Power BI, you may have noticed that it is not possible to get the total data value shown as a label. What it will do, is show the total for each slice of the bar, which is nice, but you then have to add up
Continue reading...
When you start a new Power BI report, you may run into some options that might confuse you. Maybe you already know what they are, but you don't really know when to use what? This is the blog post for you 🙂 Import This option loads all the data into the Power BI report. This
Continue reading...
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...
Organizations that start with Power BI often ask me "Jesse, how do you go about development, test and production environments when using Power BI?". I have decided to write about my experiences - I have been implementing Power BI since the beginning of the product - and share you my ideas. The reason why this
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...