Forum Discussion

joakimfenno's avatar
joakimfenno
Icon for Helper V rankHelper V
2 years 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
    2 years 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.

     

     

frithjof_v's avatar
frithjof_v
Icon for Community Champion rankCommunity Champion
2 years ago

If I understand correctly, it shows that Direct Lake outperforms DirectQuery significantly. 

 

So the row limit for Direct Lake needs to be taken into account when considering which SKU to buy. 

 

Perhaps it's possible to trick the system by splitting the fact table into 2 tables and then use measure to "append them"? ๐Ÿค”๐Ÿ˜„

joakimfenno's avatar
joakimfenno
Icon for Helper V rankHelper V
2 years ago

yes, I can see different workarounds (splitting into different tables and combining with common measures for example) but no solution that is satisfying

I did split fact tables 15 years ago before partitioning came around ๐Ÿ™‚