Forum Discussion

rfgonc's avatar
rfgonc
Frequent Visitor
2 years ago
Solved

Aggregation table is ignored after creating partitions

I have a model where the fact table is in Direct Query with a huge amount of data. Added an aggregation table in import mode and loaded some data. I've configured the aggregations in PowerBI desktop,...
Need Help
  • rfgonc's avatar
    rfgonc
    2 years ago

    After some tests we realized that if an aggregation table has any unprocessed partitions, the table is ignored.
    We partitioned the table by year_month and created partitions for future dates and remained unprocessed and was causing the issue.

rfgonc's avatar
rfgonc
Frequent Visitor
2 years ago

Hi Anonymous ,

 

Thanks for the reply, but after creating the partitions I won't be able to open the model in Power BI desktop.

Regarding the partition compatibility, I even tried duplicating the existing partition in Tabular Editor, and as soon I save the changes and run the same query, the query goes to DQ instead of hitting the aggregation.

 

I tried to replicate the behaviour in a different model in a different tenant and the same is happening. Once I create the partition, the aggregation isn't hit anymore.