Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
PBI_Vladimir
Helper I
Helper I

Size of datamodel in Fabric

Hello Community,
We have a PPU license and model ~40GB. We also have ~370 users and we took it into consideration option for shift to 
Fabric F64 or (ex P1).
But we have some question regarding model size.
In PPU we have 100GB for model and in F64 only 25GB, so if we good understand license options than F64 is not a option.
On the other hand in F64 we can make DataWarehouse and on top of that DWH there is automatically dataset and also we can produce many datasets from that DWH.
But how big DWH can be in F64? Is it also limited to 25 GB? If not, and if DWH can be more than 25GB what's happen 

with size of dataset which is automatically created. And whats happen with other datasets which can be created from that DWH, are they still limited on 25GB?

Does anyone have experience with this?
Thank You in advance



1 ACCEPTED SOLUTION
Tutu_in_YYC
Super User
Super User

Yup, PPU is equivalent to F256. So moving to P1 will not work.

I think you are referring to Lakehouse (not DWH, but yeah semantics :D). The auto dataset created is gonna be on DirectLake mode. So you will need to review the limitation on the mode. 
https://learn.microsoft.com/en-us/fabric/get-started/direct-lake-overview#fallback

AFAIK (since things are changing all the time), there's no limit to storage/size of the Lakehouse nor the Semantic model with DirectLake, but there is a limit on the DirectLake compute/query, and if you go over the limit, it will fallback to Direct query (which supposedly to be slower than DirectLake).

Please do note that there could be a cost for the storage of the lakehouse
https://azure.microsoft.com/en-ca/pricing/details/microsoft-fabric/

Tutu_in_YYC_0-1723477017169.png

 

View solution in original post

2 REPLIES 2
PBI_Vladimir
Helper I
Helper I

Thank You @Tutu_in_YYC  very useful information. 

 I will check your references links.

 

 

Tutu_in_YYC
Super User
Super User

Yup, PPU is equivalent to F256. So moving to P1 will not work.

I think you are referring to Lakehouse (not DWH, but yeah semantics :D). The auto dataset created is gonna be on DirectLake mode. So you will need to review the limitation on the mode. 
https://learn.microsoft.com/en-us/fabric/get-started/direct-lake-overview#fallback

AFAIK (since things are changing all the time), there's no limit to storage/size of the Lakehouse nor the Semantic model with DirectLake, but there is a limit on the DirectLake compute/query, and if you go over the limit, it will fallback to Direct query (which supposedly to be slower than DirectLake).

Please do note that there could be a cost for the storage of the lakehouse
https://azure.microsoft.com/en-ca/pricing/details/microsoft-fabric/

Tutu_in_YYC_0-1723477017169.png

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.