October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
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?
Solved! Go to Solution.
There is still a limit of 250MB for the Data Model size with regards to Excel files or Power BI Designer files.
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.
Yes. the limit is 1GB now. Up from 250MB.
thanks @GuyInACube This must be recent, because in that "link" shared by you, it still says 250MB as a limit per each dataset
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.
There is still a limit of 250MB for the Data Model size with regards to Excel files or Power BI Designer files.
I like the word "still" in that sentence. It implies impermanence...... 🙂
Yes. MB not GB 🙂
@GuyInACube But how can we check data model size of designer file? Is it the size of pbix file?
@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
The blog link returns a 404; here's the moved page: https://powerbi.microsoft.com/en-us/blog/the-conceptual-data-model-and-limits/
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/
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)
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.