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

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Reply
jwryu
Advocate II
Advocate II

Size limit per Semantic model

Hi,

since i've noticed the Size limit per Semantic model has updated.

when i am wondering if the new upper limit for Semantic model size(below link's Max Memory(GB) column) is the limit for each Semantic model or total amount of Semantic models published to workspace(F SKU).

What is Power BI Premium? - Power BI | Microsoft Learn

 

Thanks

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @jwryu ,

 

The limitations on semantic model are briefly described below:

 

  • For Power BI Pro, the semantic models are capped at 1 GB.
  • For Power BI Premium P1, the limit is 10 GB per model.
  • For Power BI Premium F32, the limit is 10 GB per model.
  • For Power BI Premium F64, the limit is 25 GB per model.

vhuijieymsft_0-1721282073603.png

 

The limit (for example, 10 GB for F32 and 25 GB for F64) is per semantic model, not the total number of all semantic models published to the workspace. Therefore, if you have F64 capacity, you can publish multiple models as long as each model does not exceed 25 GB.

 

The main constraint in semantic models is the overall size of the model. For the row limit, Power BI imposes a limit on the query results sent to the underlying data source only if you use the Direct Query mode. If a query sent to the data source returns more than one million rows, an error occurs and the query fails.

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @jwryu ,

 

The limitations on semantic model are briefly described below:

 

  • For Power BI Pro, the semantic models are capped at 1 GB.
  • For Power BI Premium P1, the limit is 10 GB per model.
  • For Power BI Premium F32, the limit is 10 GB per model.
  • For Power BI Premium F64, the limit is 25 GB per model.

vhuijieymsft_0-1721282073603.png

 

The limit (for example, 10 GB for F32 and 25 GB for F64) is per semantic model, not the total number of all semantic models published to the workspace. Therefore, if you have F64 capacity, you can publish multiple models as long as each model does not exceed 25 GB.

 

The main constraint in semantic models is the overall size of the model. For the row limit, Power BI imposes a limit on the query results sent to the underlying data source only if you use the Direct Query mode. If a query sent to the data source returns more than one million rows, an error occurs and the query fails.

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Just for the records, the table above is correct, but the bullet-points are not:

  • Power BI Premium P1 equivalent in Fabric: F64!
  • F32 is not a Premium SKU.

What about PPU? Do I get 100 GB, even if I only have Fabric F8?

Helpful resources

Announcements
FabCon and SQLCon Highlights Carousel

FabCon &SQLCon Highlights

Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Fabric Update Carousel

Fabric Monthly Update - March 2026

Check out the March 2026 Fabric update to learn about new features.