topic Re: Model data size in Service

Model data size

juanbizzz — Thu, 25 Jun 2015 14:17:57 GMT

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?

Re: Model data size

GuyInACube — Mon, 03 Aug 2015 13:10:32 GMT

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

Re: Model data size

diverdown1964 — Fri, 26 Jun 2015 03:01:56 GMT

I like the word "still" in that sentence. It implies impermanence...... :-)

Re: Model data size

ashishrj — Sun, 02 Aug 2015 18:48:39 GMT

GuyInACube I suppose it's 250 MB instead of GB :)

Re: Model data size

GuyInACube — Mon, 03 Aug 2015 13:10:11 GMT

Yes. MB not GB :)

Re: Model data size

ashishrj — Wed, 12 Aug 2015 03:33:31 GMT

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

Re: Model data size

Anonymous — Wed, 12 Aug 2015 03:40:42 GMT

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.aspx

Re: Model data size

bsjut — Mon, 21 Mar 2016 20:31:51 GMT

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

Re: Model data size

GuyInACube — Mon, 21 Mar 2016 20:35:56 GMT

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/

Re: Model data size

bsjut — Mon, 21 Mar 2016 20:40:43 GMT

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

-> That's not working.

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

Re: Model data size

GuyInACube — Mon, 21 Mar 2016 20:45:48 GMT

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.

Re: Model data size

alexanderg — Thu, 12 May 2016 12:55:11 GMT

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.

Re: Model data size

GuyInACube — Thu, 12 May 2016 12:58:42 GMT

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/#dataset-limits

Re: Model data size

alexanderg — Thu, 12 May 2016 15:08:41 GMT

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

Re: Model data size

GuyInACube — Thu, 12 May 2016 15:18:23 GMT

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.