Power BI data types in relationships – Does it matter?

If you have a background in traditional database development you might have learned that using integer over e.g. string has a performance benefit in for example indexes and joins. You might have brought this knowledge with you into the world of Power BI or tabular development. Perhaps you are enforcing the use of integer columns … Read more

Level up your Power BI model using DAX Studio – Part 2

Welcome back to part two of how to level up your workflow and Power BI model using DAX Studio! I’m showing you my go to scenarios on when to use Power BI together with DAX Studio. In the first part of this post I started with an introduction to what DAX Studio is. I discussed … Read more

Level up your Power BI model using DAX Studio – Part 1

DAX Studio is a popular tool used by many Microsoft data professionals. It is commonly used as an advanced enterprise tool when working with tabular models. Are you new to DAX Studio or want to learn more about how to use it in combination with Power BI? Follow along while I show you my go … Read more

Inside Power BI – Compression and the power of Vertipaq

Vertipaq is the actual database engine used in Power BI. It is also the engine used in Analysis Services Tabular and Excel Power Pivot.One of the reasons behind Vertipaq’s great performance is due to the different compression and encoding techniques that it applies to the data. The overall purpose of the different compression techniques used … Read more

Conditional formatting a matrix with Calculation groups in Power BI

Time to read: 5 minutes Calculation groups is a powerful feature in Power BI. However, using them adds some complexity and brings some limitations to Power BI’s native functionality. Or should I say, changes them. One of these cases are related to the use of Conditional formatting using a calculation group as e.g. columns in … Read more

How to add total values in bar and line charts in Power BI

A while back I did some work for a client which involved adding total values to a bar chart in Power BI. This isn’t an out of box feature in Power BI at the moment. Therefore I thought it would be of some value to write about it here and show you one way of … Read more

Why you shouldn’t use Power BI “Publish to web” and what to use instead

In this blog post I will try and guide you through Power BI’s functionality Publish to web as well as the security aspects of sharing your data. How does it work, when should I and when shouldn’t I use it? What is it? Power BI’s Publish to web functionality has been widely used since it’s … Read more

%d bloggers like this: