Combining Dimension Tables in Power BI using Power Query: Basics and Foundations of Modeling

The article that I wrote earlier this week about the shared dimension had a lot of interest, and I’m glad it helped many of you. So I thought better to write about the basics of modeling even more. In this article, I will be focusing on a scenario that you have all faced, however, took ...

Read More

Creating a Shared Dimension in Power BI Using Power Query: Basics and Foundations of Modeling

For a data warehouse professional, a shared dimension concept is always clear, and a star schema design always includes such type of entity. However, in the Power BI user’s world, there are many users who are not coming from a data warehousing background. It is necessary to understand some of the concepts in order to ...

Read More

Multiple Layers of Aggregations in Power BI; Model Responds Even Faster

Aggregations are speeding up the model. However, the aggregated table is not just one table, It can be multiple layers of aggregations. Aggregation by Date, aggregation by Date and Product, aggregation by Date and Product and Customer. Having multiple layers ensures that you always have the best performance result possible, and you only query the ...

Read More

Power BI Aggregations Step 3: Configure Aggregation Functions and Test Aggregations in Action

Aggregation can speed up the performance of DirectQuery sourced tables significantly. To use it, firstly you need to create an aggregation table, secondly, you need to set up proper storage modes for tables in the model. Finally, you have to configure the aggregation functions, which is what I’m going to explain in this post. You ...

Read More

Dual Storage Mode; The Most Important Configuration for Aggregations! Step 2 Power BI Aggregations

An aggregated table can be a layer on top of the source DirectQuery table. This table needs to have a proper relationship set up with other tables, and also the proper storage mode configuration. Storage Mode configuration of the composite model, in fact, is an important configuration and critical part of setting up the aggregation. ...

Read More

Power BI Aggregation: Step 1 Create the Aggregated Table

Aggregation tables are the fast performing solution for huge DirectQuery tables in Power BI. In the previous blog post, I explained what is an aggregation, and why it is an important part of a Power BI implementation. Aggregations are part of the Composite model in the Power BI. For the aggregation set up, your first step ...

Read More