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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi rfgonc 

 

Here are a few steps to help troubleshoot and resolve this issue:

  1. Review Aggregation Configurations: Ensure that after partitioning, the aggregation configurations are still correctly set up. It's crucial that the aggregation table and its partitions are properly recognized by Power BI. Revisit the "Manage aggregations" dialog in Power BI Desktop to confirm that the configurations are intact and correctly applied. For more details on managing aggregations, please refer to the User-defined aggregations - Power BI | Microsoft Learn

  2. Check Partition Compatibility: Ensure that the partitions created in the aggregation table are compatible with the aggregation configurations. The partitions should not alter the granularity or the structure expected by the aggregation setup. It's also important to ensure that the data types between the detail and aggregation columns match.

 

 

 

 

Best Regards,

Jayleny