cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chienim Regular Visitor
Regular Visitor

Desktop publish limitation : Pro or Free account?

 

Hello all,

Currently I'm playing with Power BI and learning about how it handles data storage by different data sources and connection way,

I did read this:

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-manage-your-data-storage-in-power-bi...

and understand the limitation of publish from Desktop.

 

Here's something I don't understand,

When publishing to Service, does the limitation of publish(1Gb) change to 10G if I upgrade to pro account? Which means I can have a 10G .pbix file including imported dataset and upload it to Service am I correct?

 

Thanks for some advise!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Desktop publish limitation : Pro or Free account?

If you do it right, load what you need and not what you don't, and shape the data right, I would be shocked if a 1TB data source got anywhere near 1GB.

 

Read my best practices here.  http://exceleratorbi.com.au/best-practices-power-pivot-power-query-power-bi/



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
3 REPLIES 3
Super User
Super User

Re: Desktop publish limitation : Pro or Free account?

Wow, I wouldn't want to be publishing a 10GB pbix file. Do you know it will actually be this size or is this just a general question?  Power bi compression is awesome. I have a 60 million row workbook that is 250mb. If you don't build it right they can be large, and of course if you have billions or rows it may also be large. 

 

My understanding is the max workbook size is 1GB (so you can have 10 of them with pro). 

 

 

 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
chienim Regular Visitor
Regular Visitor

Re: Desktop publish limitation : Pro or Free account?

Hi!

 

Thanks for the reply,

Yes you're right this is just a general question; I don't have such a sample on hand Smiley Happy

 

The scenario here is that my customer may have a huge data source say, 1TB in on-prem db.

so if I go with importing data there may be a large data model built in power bi (don't have a rough image about the size after compression though),

that's why I come up with this question if Direct Query is not preferred.

 

Thanks for the info too!

 

 

Highlighted
Super User
Super User

Re: Desktop publish limitation : Pro or Free account?

If you do it right, load what you need and not what you don't, and shape the data right, I would be shocked if a 1TB data source got anywhere near 1GB.

 

Read my best practices here.  http://exceleratorbi.com.au/best-practices-power-pivot-power-query-power-bi/



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 284 members 2,974 guests
Please welcome our newest community members: