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 storage modes – Import vs DirectQuery

When building datasets in Power BI, you have different options on how to connect and store the data in your model. There are two main modes to choose from when querying data from sources. These are import mode and DirectQuery mode. Import mode allows you to import the data in your local dataset, and use … Read more