How to Find Data Model size in Designer File ?

[ashishrj]

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 ?

[andre]

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]

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

[andre]

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.

[Arieln]

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.