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

DAX · 04. März 2020

This blog provides an introdution into some universal truths, of course things like evaluation context, or data lineage will be mentioned

Data Visualization · 12. August 2018

Using svg graphics to create information dense data visualizations often called microcharts or sparklines using the table and matrix visual in Power BI.