Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply

Model data size

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?

1 ACCEPTED SOLUTION
GuyInACube
Microsoft Employee
Microsoft Employee

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

Adam W. Saxton | Microsoft Employee | Business Intelligence
@GuyInACube | youtube.com/guyinacube

View solution in original post

14 REPLIES 14
alexanderg
Advocate II
Advocate II

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. 

 

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

 

Adam W. Saxton | Microsoft Employee | Business Intelligence
@GuyInACube | youtube.com/guyinacube

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.

Adam W. Saxton | Microsoft Employee | Business Intelligence
@GuyInACube | youtube.com/guyinacube
GuyInACube
Microsoft Employee
Microsoft Employee

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

Adam W. Saxton | Microsoft Employee | Business Intelligence
@GuyInACube | youtube.com/guyinacube

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

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

Yes.  MB not GB  🙂

Adam W. Saxton | Microsoft Employee | Business Intelligence
@GuyInACube | youtube.com/guyinacube

@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

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


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

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
Microsoft Employee
Microsoft Employee

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/

Adam W. Saxton | Microsoft Employee | Business Intelligence
@GuyInACube | youtube.com/guyinacube

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
Microsoft Employee
Microsoft Employee

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.

Adam W. Saxton | Microsoft Employee | Business Intelligence
@GuyInACube | youtube.com/guyinacube

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors