topic Re: Max size of PBIX file, SSAS cube. in Developer

Max size of PBIX file, SSAS cube.

deepak2024 — Tue, 05 Mar 2024 14:33:41 GMT

Hi,

What is the maz size of PBIX file in Power BI?

What is the maz size of SSAS Cube?

How much of the max data set can be handled for one application (One data model) in Power BI?

If there any limitation of tables that can be loaded in PBI?

Thanks

Re: Max size of PBIX file, SSAS cube.

lbendlin — Wed, 06 Mar 2024 01:22:24 GMT

There is no real maximum size for a PBIX. The initial size of a table that you publish from Power BI Desktop cannot exceed 10 GB (1GB for shared) but with incremental refresh you can go beyond that to have any number of partitions up to 10GB each.

Re: Max size of PBIX file, SSAS cube.

deepak2024 — Wed, 06 Mar 2024 03:21:38 GMT

For Power BI pro account PBIX file size should not exceed 1 GB and for premium capacity it should not exceed 100 GB. Is this True.

Is this for import mode?

Thanks

Re: Max size of PBIX file, SSAS cube.

lbendlin — Wed, 06 Mar 2024 04:20:48 GMT

All correct except for the 100GB

Re: Max size of PBIX file, SSAS cube.

deepak2024 — Wed, 06 Mar 2024 04:57:56 GMT

The in premium what is the max PBIX file size is it 10 GB?

How much data we can load using SSAS cube?

thanks

Re: Max size of PBIX file, SSAS cube.

Anonymous — Mon, 18 Mar 2024 08:36:44 GMT

@lbendlin Thanks for your contribution on this thread.

Hi @deepak2024 ,

Just as @lbendlin said, there are different limit size for different license type. Please find the details in the following links. And it's important to note that these are not hard limits and the actual size may be smaller due to factors such as available memory and system resources.

Max Offline Semantic model Size

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

As for the amount of data that can be loaded using SSAS cube, it depends on a number of factors such as the hardware configuration of the server and the complexity of the data model.

SSAS Performance Tuning

Best Regards