Forum Discussion

Krupar's avatar
Krupar
Frequent Visitor
1 year ago
Solved

Semantic Model limits

Hi Team

am new to PowerBI and just want to know is there a limit to number of the semantic models ..Currently we are in migration to PowerBI from other reporting tool and just want to know the limit on the count of semantic models that can be created.

 

Thanks,

Krupa

  • Hi Krupar ,

    As i know in Power BI, the number of semantic models you can create depends on your license type and capacity. There is no hard limit on the number of semantic models, but there are storage and performance constraints based on the plan you choose.

    For Power BI Free and Pro users, there is a 10 GB total storage limit per user, which indirectly limits the number of models you can create. Power BI Premium Per User (PPU) allows for larger dataset sizes, up to 100 GB per model, and supports auto-scaling beyond the 10 GB limit. If you are using Power BI Premium (capacity-based, such as P1, P2, etc.), there is no strict limit on the number of semantic models, but each dataset's size is constrained by the SKU purchased, with P1 supporting up to 25 GB per dataset.

  • Hi KR ,

     

    I do believe there is not a limit of the number of semantic models but there is a limit on how big a semantic model can be depending on your license.

     

    Power BI offers PRO and PPU for single users, and I believe they are moving to Fabric for company wide licenses.

    Depending on how many users needs to visualize your reports in the Service you may want to use PRO or PPU, if not too many. 

     

    Please have a look at here -> https://community.fabric.microsoft.com/t5/Fabric-platform/Size-limit-per-Semantic-model/m-p/4047585/highlight/true#M8783

     

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

3 Replies

  • Hi Krupar ,

    As i know in Power BI, the number of semantic models you can create depends on your license type and capacity. There is no hard limit on the number of semantic models, but there are storage and performance constraints based on the plan you choose.

    For Power BI Free and Pro users, there is a 10 GB total storage limit per user, which indirectly limits the number of models you can create. Power BI Premium Per User (PPU) allows for larger dataset sizes, up to 100 GB per model, and supports auto-scaling beyond the 10 GB limit. If you are using Power BI Premium (capacity-based, such as P1, P2, etc.), there is no strict limit on the number of semantic models, but each dataset's size is constrained by the SKU purchased, with P1 supporting up to 25 GB per dataset.

  • Hi KR ,

     

    I do believe there is not a limit of the number of semantic models but there is a limit on how big a semantic model can be depending on your license.

     

    Power BI offers PRO and PPU for single users, and I believe they are moving to Fabric for company wide licenses.

    Depending on how many users needs to visualize your reports in the Service you may want to use PRO or PPU, if not too many. 

     

    Please have a look at here -> https://community.fabric.microsoft.com/t5/Fabric-platform/Size-limit-per-Semantic-model/m-p/4047585/highlight/true#M8783

     

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