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

Exploring the model pane in Power BI Desktop: A Hands-on guide

❕ Note – The new model explorer is currently in preview as part of Power BI Desktop October 2023 release. To enable the preview feature go to File -> Options and settings -> Options -> Preview features and enable “Model explorer and Calculation group authoring” The Model Pane feature is showcased here as part of … Read more

Unlocking Power BI: A Deep Dive into Import vs DirectQuery Storage Modes

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

Finding the Highest and Lowest Values Across Many Columns in Power BI using DAX

When working with data in Power BI, sometimes you need to find the highest (maximum) and lowest (minimum) values across several columns. This task is straightforward in programs like Excel where you can just use the MAX and MIN functions with multiple arguments like so: MAX(columnA, columnB, columnC). However, in Power BI, using DAX (Data … Read more

Dimensional modeling for Power BI: The purpose of data modeling

Data modeling techniques and methodologies are a common discussion topic when working on BI or data warehouse projects. There are multiple practices of data modeling and different reporting tools support different ways to handle data. If you have past experience of working in the data area, chances are you have come across Kimball dimensional modeling, … 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