Forum Discussion
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,...
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.
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.