Reply
Regular Visitor
Posts: 15
Registered: ‎12-14-2016
Accepted Solution

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!

 


Accepted Solutions
Highlighted
Super User
Posts: 1,627
Registered: ‎07-03-2015

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.

View solution in original post


All Replies
Super User
Posts: 1,627
Registered: ‎07-03-2015

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.
Regular Visitor
Posts: 15
Registered: ‎12-14-2016

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
Posts: 1,627
Registered: ‎07-03-2015

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.