How much data can Power BI Desktop hold?

[jperry1120]

How much data can Power BI Desktop hold?

[Greg_Deckler · Accepted solution]

Whoops, just found this:

http://community.powerbi.com/t5/Service/Model-data-size/td-p/116

250MB

[jperry1120]

@Greg_Deckler thanks! 🙂

[ashishrj]

http://blogs.technet.com/b/powerbisupport/archive/2015/08/11/the-conceptual-data-model-and-limits.as...

[andre]

Just to clarify, a Desktop model can theoretically hold very large amount of data.  Practically speaking, you are mostly limited by RAM in your computer if you are running 64 bit version of the product.  However, if your intention is to upload that model to powerbi.com then you are limited by roughly 250MB.

[Greg_Deckler]

I have not seen a published limit. In File | Options and settinsg | Options under GLOBAL there is a maximum Cache limit which defaults to 4GB. There are limits on data model sizes that you can upload to Power BI service that are around 50MB of data model size I *believe*.