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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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.

Arieln
Microsoft Employee
Microsoft Employee

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 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.

October NL Carousel

Fabric Community Update - October 2024

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