How to Find Data Model size in Designer File ?

Question

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 · Answer

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

ashishrj · Answer

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

andre · Answer

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 · Answer

The enforcments are really checked and enforced on the server and not on the client.&nbsp;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.&nbsp;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.

Forum Discussion

How to Find Data Model size in Designer File ?

4 Replies

Related content

semantic model can't find DateTable

Modelling

Pipeline Design

Model Design - Using a Surrogate Key

data model design