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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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?

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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