Forum Discussion

Tcs2022's avatar
Tcs2022
New Member
7 months ago
Solved

MS Fabric : Manage Aggregations Support

1. Does MS Fabric support Manage Aggregations as is available in Power BI?

2. Have created a table in One Lake . Total rows > 100B rows. The current Fabric capacity supports max 3B rows in "Direct Lake" mode. Would like to know if there is "Manage aggregations" option whereby higher grain can be sourced from aggregate table in One lake (Direct lake mode) whereas transaction grain (100B rows) falls back to direct query mode? We dont see the "Manage Aggregation" option in MS Fabric?

3. If "manage aggregation" is not supporte in MS Fabric then how do we handle 100B rows as it will always fallback to "Direct Mode"

 

Need Help
  • v-veshwara-msft's avatar
    v-veshwara-msft
    7 months ago

    Hi Tcs2022 ,

     

    Thanks for reaching out to Microsoft Fabric Community.

    Thanks to cengizhanarslan and Murtaza_Ghafoor for the detailed explanations.

     

    Fabric can handle very large data volumes at the storage and compute layer. But, Direct Lake semantic models do not currently support classic Manage Aggregations, and fallback to DirectQuery is expected once table limits are exceeded, even for higher-grain queries.

     

    If aggregation awareness across mixed grains is a hard requirement, a traditional Power BI composite model using Import for aggregates and DirectQuery for detail remains the supported approach.

     

    Regarding Dataflows, they are intended for reusable data preparation and incremental refresh scenarios, and very large initial ingestions are constrained by refresh and capacity limits.

    For ingestion at this scale, Fabric scenarios typically rely on Lakehouse ingestion patterns such as pipelines or notebooks, with aggregates materialized separately.

     

    Hope this helps. Please reach out for further assistance.
    Thank you.