cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ashishrj
Power Participant
Power Participant

How to Find Data Model size in Designer File ?

When it was Excel file earlier, it was pretty much easier to find the exact size of data model using the method given below

How to Find Power BI Excel Data Model Size. But how to find the data model size in case of power BI designer file? Do size of pbix represents model size ? Power BI free says a data capacity limit of 1 GB. So this represents total size of pbix and other files uploaded on Power BI service. Does data model size really matter ?

4 REPLIES 4
andre
Memorable Member
Memorable Member

Yes, it's the size of the .PBIX file that cannot be more than 250MB if you want to upload it to PowerBI.com.  Number of rows is irrelevant.  The file also cannot have more than ten reports.  These are the two main limitations.

ashishrj
Power Participant
Power Participant

@andre So what about the size of the Excel file. How large it can handle?

andre
Memorable Member
Memorable Member

it's 240MB for data, 10mb for reports ( so don't go crazy with logos and background images) and up to 10 reports per file.

The enforcments are really checked and enforced on the server and not on the client.

 

You can imagine a scenario where the PBIX files, while in development can be very small (sample of few rows).

Then the user schedule a refresh on the service that loads all the data. That is when it matters. Not during refresh itself as much as where the file lives.

 

That being said, I can see why it can be useful to know on the client size the size of the file. feel free to add it to uservoice for user voting.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors