Power BI Service · 03. April 2021

Here I will describe how to buy a brand new SKU, namely the Power BI Premium Per User Add-on. This SKU can be used to upgrade existing Power BI Pro licenses, either if you purchased a Pro license separately or together with an M365 E5 subscription, if you want to unlock new capabilities. The purchase is rather simple, just go to the M365 Admin portal purchase the necessary number of licenses and assign the Add-on to existing users that already have a Power BI Pro license assigned. BE AWARE (1),...

Data Visualization · 03. April 2021

This blog is about one visualization task. In particular, this task is called part-to-whole. Effective visualizations will reveal the contribution of a single item to the whole, as Claus Dieter Wilke calls this in his book "Fundamentals of Data Visualization": "… visualizing proportions … as part of the total." and how this task can be solved using Power BI, now and even more important in the future.

Data Modeling · 28. Februar 2021

Object Level Security (OLS) helps to protect our data assets inside Power BI. OLS can be applied to a table or just a single column.

Power Query · 18. Januar 2021

I tend to create tables using M or a combination of point-and-click and M, because these tables are treated as base tables if the model is refreshed and for this reason these tables will benefit from all the compression magic, whereas tables created using DAX are not that well compressed.

DAX · 17. Januar 2021

There is just one thing that is more satisfying than writing complex DAX measures, and that is avoiding complex DAX due to smart data modeling.

Power BI Service · 03. Januar 2021

One of the most exciting things about being a Power BI service administrator is watching what's going on inside the service. This blog starts a series of articles on how to create your own Service Monitoring application using Power BI.

Power BI Service · 29. November 2020

This is the start of a series of articles that explain why the Power BI service admin can be considered being an agent of change helping enterprises becoming a data-enabled organization.

DAX · 02. November 2020

This article will provide a different approach to tackle a common requirement, determining the previous value given a current date.

Data Visualization · 22. September 2020

How to display the Total data label in Power BI the - the new way!

Power BI · 13. Juni 2020

A common search strategy has to combine multiple items with an AND instead of the default OR. This Power BI file contains two DAX measures solving a search operation with the fancy name: relational division