Forum Discussion

joakimfenno's avatar
joakimfenno
Icon for Helper V rankHelper V
1 year ago
Solved

Fabric - rows per table limitation

I have read about Semantic Model SKU limitation here I am concerned about max number of rows per table in lakehouse and warehouse as well as limitations on semantic model. Is it correct that direct...
capacities
  • AndyDDC's avatar
    AndyDDC
    1 year ago

    300M is the row limit per table in an F8 SKU where DirectLake will be supported.  Any tables above 300M when running on an F8 capacity will fall back to DirectQuery.

     

     

AndyDDC's avatar
AndyDDC
Icon for Most Valuable Professional rankMost Valuable Professional
1 year ago

Hi joakimfenno the direct lake document has the row limits and model sizes per Fabric SKU (about half way down the document in a table)

https://learn.microsoft.com/en-us/fabric/get-started/direct-lake-overview#fabric-capacity-guardrails-and-limitations

 

eg F64 allows for 1.5billion rows in a table and respects direct lake, exceeding this row limit will cause a fallback to direct query 

 

table limits will be the same for lakehouse sql endpoint and warehouse