cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

maximum file size for pbix

Hi,

I wanted to understand what is the maximum size for pbix file under Power BI Pro account.

Is it same as normal (250 MB) or higher (2 GB somewhere I read)

 

Thanks,

Dilkush

1 ACCEPTED SOLUTION

Accepted Solutions

Re: maximum file size for pbix

The limit is the same for pro and free users but the total size a user can store in the service is 1 GB for free and 10 GB for Pro so the Pro user can store 10 times the data although each data model cannot be larger than 250 MB

View solution in original post

5 REPLIES 5
greggyb New Contributor
New Contributor

Re: maximum file size for pbix

The 250MB limit is specifically for the data model within a .pbix file. If you look at the .pbix in the file explorer, the total size will be larger than the data model component. You can check the size of the data model as follows:

 

  1. Create a backup copy of your .pbix
  2. Change the name of your .pbix to alter the file extension to zip
    i.e. Sample.pbix -> Sample.zip
  3. Open the .zip archive with the archive / compression tool of your preference
  4. Find the file named 'Datamodel'
  5. Check the size of 'Datamodel' - this is the component that has a 250MB size limit.

Re: maximum file size for pbix

@greggyb is this limit same for both pro and free users?

Re: maximum file size for pbix

The limit is the same for pro and free users but the total size a user can store in the service is 1 GB for free and 10 GB for Pro so the Pro user can store 10 times the data although each data model cannot be larger than 250 MB

View solution in original post

residentx Member
Member

Re: maximum file size for pbix

These numbers are for 32 bit. I've been using 64 bit  and I have a HP Z840 with 1TB RAM and I've loaded 100s of gigabytes into the desktop client. I cannot load these into the PowerBI service though.

Highlighted
Super User III
Super User III

Re: maximum file size for pbix

@residentx The 250mb restriction is for 32 and 64bit and applies to loading a PBIX to the Service. The 1 GB and 10GB relate to how much data you can store in the Service.

As far as I know, there is no restriction on how large a PBIX file can be locally, you just wouldn't be able to publish anything to the Service - as you said.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors