Model data size

[juanbizzz]

Is the limit 250 MB the max size of a model in power BI or i can have a model that have for example 1G of size?

[alexanderg]

Is there a new limit? Because yesterday I was testing with a "pbix file" greater than 250 MB... and there is any issue in the publication.

[GuyInACube]

Yes. the limit is 1GB now. Up from 250MB. 

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

[alexanderg]

thanks @GuyInACube This must be recent, because in that "link" shared by you, it still says 250MB as a limit per each dataset

[GuyInACube]

The change actually happened about 2 weeks ago. The doc change went in yesterday but looks like caching may still be occurring. The doc looked good on my end.

[GuyInACube · Accepted solution]

There is still a limit of 250MB for the Data Model size with regards to Excel files or Power BI Designer files.

[diverdown1964]

I like the word "still" in that sentence. It implies impermanence...... 🙂

[ashishrj]

@GuyInACube I suppose it's 250 MB instead of GB 🙂

[GuyInACube]

Yes.  MB not GB  🙂

[ashishrj]

@GuyInACube But how can we check data model size of designer file? Is it the size of pbix file?

[Seth_C_Bauer]

@ashishrj whoa.. mind = blown

@GuyInACube is also a mind reader.. he must have known this follow up was coming because he posted his awesome blog about how to figure this out only 5 hours ago 🙂

This should cover everything you need to know

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

[bsjut]

The blog link returns a 404; here's the moved page: https://powerbi.microsoft.com/en-us/blog/the-conceptual-data-model-and-limits/

[GuyInACube]

I just tried it and it came up for me. Maybe a local thing?  What happens if you try (without the en-us):

https://powerbi.microsoft.com/blog/the-conceptual-data-model-and-limits/

[bsjut]

The link above is the archive link: https://powerbi.microsoft.com/en-us/blog/archive/2015/08/11/the-conceptual-data-model-and-limits.asp...

-> That's not working.

(The link with removed archive and removed en-us works fine)

[GuyInACube]

Got it. Yeah there is redirect badness going on. The Power BI support blog was recently migrated to a single Power BI blog off of powerbi.microsoft.com.

Thanks for calling it out. I've passed it onto the services team to get it fixed.