Top tips to speed up your Power BI DirectQuery semantic models

This post is aimed towards Power BI DirectQuery semantic models. However, a lot of the information in this post is also viable for import mode semantic models. This is a short summary with the purpose of giving you an overview of some important areas that can impact the performance of your Power BI DirectQuery semantic … Read more

Optimizing Power BI: A Practical Guide to DirectQuery Performance – Part 3

Welcome back to part 3 in a series of articles where you will learn how to improve and optimize the performance of your Power BI DirectQuery semantic models.In part 1 we covered the basic aspects of DirectQuery semantic models in Power BI, such as the importance of star schema modeling in Power BI and how … Read more

Mastering DirectQuery in Power BI: A Deep Dive into Performance Optimization – Part 2

In the first part of this series, we explored the essentials of Power BI’s DirectQuery mode. We discussed its core components and initial steps towards optimization. We touched on the topic of formula engine and the storage engine in Power BI, the importance of a well-structured data source, and the basics of optimizing Power BI … Read more

Mastering DirectQuery in Power BI: A Deep Dive into Performance Optimization – Part 1

Working with Power BI DirectQuery datasets, you might sometimes find that performance issues can feel inevitable. Especially with larger datasets where many moving parts can cause potential complications. In this series, I will guide you towards mastering DirectQuery in Power BI, starting with an overview to help you understand the aspects of DirectQuery performance and … Read more

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