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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
pennyhoho117
Helper IV
Helper IV

Semantic model size limit 1G in Pro License what is the size limit in Power Fabric (diff. CUs)

Semantic model size limit 1G in Pro License what is the size limit in Power Fabric (diff. CUs)

2 ACCEPTED SOLUTIONS

Hi @pennyhoho117 ,
Thanks for reaching out to Fabric community Forum.
@Akash_Varuna  Thanks for your Prompt response.

Based on your query you can refer the below documentation :

https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-what-is

https://www.microsoft.com/en-us/power-platform/products/power-bi/pricing

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!




View solution in original post

Poojara_D12
Super User
Super User

Hi @pennyhoho117 

In Power BI, under the Pro license, the maximum size for a semantic model (dataset) is 1 GB, which limits the volume of data you can import and store directly within a model. However, when using Microsoft Fabric with Premium capacity, the limits increase significantly depending on the Capacity Unit (CU) or SKU you are using. For example, with Fabric F64 and higher (formerly known as Power BI Premium P SKUs), the maximum dataset size can go up to 400 GB or more per semantic model, with the total storage depending on your purchased capacity. The higher the SKU (F64, F128, F256, etc.), the more resources and memory are allocated, enabling much larger and more complex models. Additionally, when using large models and incremental refresh, Fabric helps manage and optimize memory usage even further. This flexibility is essential for enterprise-level analytics where large volumes of data from data warehouses or lakehouses are common. Therefore, moving from a Pro license to a Fabric Premium capacity not only lifts the 1 GB limit but also unlocks enhanced performance, scalability, and advanced features needed for larger-scale business intelligence.

 

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"

Kind Regards,
Poojara - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS

View solution in original post

5 REPLIES 5
Poojara_D12
Super User
Super User

Hi @pennyhoho117 

In Power BI, under the Pro license, the maximum size for a semantic model (dataset) is 1 GB, which limits the volume of data you can import and store directly within a model. However, when using Microsoft Fabric with Premium capacity, the limits increase significantly depending on the Capacity Unit (CU) or SKU you are using. For example, with Fabric F64 and higher (formerly known as Power BI Premium P SKUs), the maximum dataset size can go up to 400 GB or more per semantic model, with the total storage depending on your purchased capacity. The higher the SKU (F64, F128, F256, etc.), the more resources and memory are allocated, enabling much larger and more complex models. Additionally, when using large models and incremental refresh, Fabric helps manage and optimize memory usage even further. This flexibility is essential for enterprise-level analytics where large volumes of data from data warehouses or lakehouses are common. Therefore, moving from a Pro license to a Fabric Premium capacity not only lifts the 1 GB limit but also unlocks enhanced performance, scalability, and advanced features needed for larger-scale business intelligence.

 

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"

Kind Regards,
Poojara - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
Akash_Varuna
Community Champion
Community Champion

Hi @pennyhoho117 

  • Power BI Pro: Semantic model size limit is 1 GB.
  • Power BI Premium: Supports models up to 400 GB with incremental refresh and partitioning.
  • Microsoft Fabric: Same 400 GB limit as Premium; performance depends on allocated Compute Units.

 

 

where can find the model size limit up to  400GB from Power BI document in Fabric License.Thanks

Hi @pennyhoho117 ,
Thanks for reaching out to Fabric community Forum.
@Akash_Varuna  Thanks for your Prompt response.

Based on your query you can refer the below documentation :

https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-what-is

https://www.microsoft.com/en-us/power-platform/products/power-bi/pricing

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!




Hi @pennyhoho117 ,

Just following up on your query regarding the 1 GB semantic model size limit under the Power BI Pro license. You had also asked about the limits across different capacities in Microsoft Fabric  happy to provide further details if needed.

 

If your issue has already been resolved, it would be greatly appreciated if you could mark the helpful response as Accepted. Doing so helps others in the community who might encounter similar questions.

Looking forward to your confirmation or any additional questions you might have!

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.