cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ssharman
Frequent Visitor

Power BI limitations for large datasets

Hello,

 

I understand there is a 1GB limit for datasets with Power BI.  However, it appears that with premium this limit is 10 GB.

 

We have purchased a Power BI embedded instance and assigned the workspaces to this embedded capacity.  However, when we try to push more data into a 1 GB dataset we still get the following error:

 

 {"error":{"code":"InvalidRequest","message":"Dataset size is limited to 1024Mb."}}

 

The workspace is configured to use the Power BI embedded and appears in the UI as Power BI premium content.  Shouldn't we now be allowed to push up to 10GB into the dataset?

4 REPLIES 4
Community Support
Community Support

Re: Power BI limitations for large datasets

Hi @ssharman,

 

Current only increase data model size limit at least request premium P1 SKU license.  If you use premium EM license, it still has 1 GB limit:

Power BI Premium support for large datasets

 

Large models can be very resource-intensive on your capacity; we recommend at least a P1 SKU for any models larger than 1 GB. The following table describes recommended SKUs for various .pbix sizes:

SKU Size of .pbix
P1 < 3 GB
P2 < 6 GB
P3 up to 10 GB

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
ssharman
Frequent Visitor

Re: Power BI limitations for large datasets

I have scaled our Power BI Embedded instance to an A6 skew, which I believe is equivalent to an A3 instance and I am still seeing the same errors when trying to push data to a 1GB dataset.

 

Any other suggestions?

ssharman
Frequent Visitor

Re: Power BI limitations for large datasets

Sorry, I mistyped.  I have scaled to an A6 Power BI Embedded instance which I believe is equivalent to a P3.  Still getting the 1 GB errors

Community Support
Community Support

Re: Power BI limitations for large datasets

HI @ssharman,

 

I haven't found another documents mention these limitations, maybe you can submit a support ticket to power bi team to get further support.

Support Ticket.gif

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.