✏️ Explanatory Question

What are Aggregation Tables?

👁 1 Views
📘 Detailed Answer
🟢 Easy
💡

Answer with Explanation

Aggregation Tables store summarized data to accelerate report queries.

Example:

  • Detailed Sales Table → 500 Million Rows
  • Monthly Summary Table → 10 Thousand Rows

Power BI can automatically use the summary table to improve performance.