In my previous post, I showed you how to stream real time tweets to Power BI using Azure Databricks, Azure Streaming Analytics and Power BI. Then, I showed you how to store those tweets for long time storage in your data lake. But how do we bring that data to our data warehouse?First of all:
Continue reading...
Just when Microsoft announced the upcoming composite Power BI model some friends of mine were wondering out loud: "what's the deal, will they focus on power to end users or on IT enterprise BI?". Just to be clear: the upcoming feature Microsoft announced is the ability to extend Power BI and Azure Analysis Services Models
Continue reading...
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...
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...