Forum Discussion
How does aggregation table get populated?
Hi Anonymous
If you want to understand the aggregation in Power BI, you can take a look at these articles Understanding Power BI Aggregations and Use aggregations in Power BI.
For creating aggregation table in Power BI, you can refer Power BI Aggregation: Step 1 Create the Aggregated Table.
Hope it can helps!
Best Regards
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi, your first link is totaly irrelevant since it explains another type of aggregations, not aggregation tables.
The other link is from Microsoft documentation which I have ofcourse read before I posted here, but this one jumps over the step how the agg table is populated. It misleads me (maybe) in direction for me to think that Power BI should auto-populate the table when I configure gorupings and summarization.
Article from third link describes copying the fact table and then grouping on it, without possibility to use another dimension table, as you can see in screenshots, configuration of the grouping does not give an option to choose where the source column is comming from, it is limited to the current table.
I've been trying to get the answer on this question a long time now in all possible channels, is it possible that there is noone out there who can answer: Should Power BI populate the table, which is configured as aggregation table, automatically, or am I responsible to get the data into the table?
Thanks in advance