Power Query · 02. Juni 2021
The other day I was facing an interesting question "How can I randomly draw ten records from the top 50 for each group using Power Query?" As you may guess, this article also contains the answer.
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.