Skip to main content

Power BI

Completed

Increase dataset size limit from 250 MB for PowerBI Pro

Vote (258) Share
rg's profile image

rg on 05 Oct 2015 22:08:04

Now a dataset can store 250 MB of data. That’s not a lot, especially when You want to analyze big data sources. In that case You have to make additional aggregations before putting data to Power Bi. Increasing the limit to 1GB (for example) for a dataset would be very nice, especially that the Power BI Pro gives us 10GB of storage
By the way, Power BI Desktop doesn’t have this limit.

Administrator on 15 Jun 2016 07:47:12

We included the dataset limit to 1 GB! You can read the details in our blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-service-may-update-file-size-increase-to-1-gb/#oneGB

Comments (34)
rg's profile image Profile Picture

Andrew T. on 05 Jul 2020 22:57:29

RE: Increase dataset size limit from 250 MB for PowerBI Pro

1GB is just not sufficient for many uses.

rg's profile image Profile Picture

J Michael Williams on 05 Jul 2020 22:49:38

RE: Increase dataset size limit from 250 MB for PowerBI Pro

1GB is just not enough. I need to be able to push a file that is at least 2GB to give my consuming audience enough years of data to evaluate. When I say years I mean Academic Years which start every July 1 and ends June 30. Even with limiting the data to 3 Academic Years the PBIX is 1.5GB.

rg's profile image Profile Picture

Brandon on 05 Jul 2020 22:40:21

RE: Increase dataset size limit from 250 MB for PowerBI Pro

Is it possible to bump the data set size limit up? Im at a gig and a half of data and unable to publish online...

rg's profile image Profile Picture

Hassen on 05 Jul 2020 22:34:48

RE: Increase dataset size limit from 250 MB for PowerBI Pro

Hi,
I have a a question about the dataset size : is it the size of the data thet you import, or the size of data once imported and transfomed through PowerQuery. Suppose I have a SharePoint list with thousands of lines. I import this list content to PowerBI desktop, and I see that PBI downloads 10 Mb. However, After cleaning this data using PowerQuery, I save only 1 Mb. So, in this case, does PowerBI consume 1 Mb or 10 Mb ?
On my storage report, I see that powerBI uses only 1 Mb, please can you confirm ?
thx

rg's profile image Profile Picture

Matt Allington on 05 Jul 2020 22:22:54

RE: Increase dataset size limit from 250 MB for PowerBI Pro

This has been delivered. Please close this so we can get our votes back

rg's profile image Profile Picture

Bobby on 05 Jul 2020 22:22:39

RE: Increase dataset size limit from 250 MB for PowerBI Pro

Didn't they just announce an increase to 1GB file sizes?

rg's profile image Profile Picture

Ali Uluğ on 05 Jul 2020 22:21:16

RE: Increase dataset size limit from 250 MB for PowerBI Pro

I just uploaded two local .pbix files to my Power BI Pro account (trial account). Their datasets are 409 MB and 793 MB. Screenshot is on https://www.adayazilim.com/sabit/powerbi.png

Power BI Service did not give any error messages during upload and I can work normally with these datasets online, on powerbi.com.

Am I missing something? Is this limit cancelled?

rg's profile image Profile Picture

Leo on 05 Jul 2020 22:21:14

RE: Increase dataset size limit from 250 MB for PowerBI Pro

any comment on when this might be available?

rg's profile image Profile Picture

Cliff Brandon on 05 Jul 2020 22:20:06

RE: Increase dataset size limit from 250 MB for PowerBI Pro

I have a data set of 85K U.S. Mines with a number of attributes (see www.asaservices.biz). As it stands now, I can only load ~2300 records.

rg's profile image Profile Picture

Borut on 05 Jul 2020 22:20:06

RE: Increase dataset size limit from 250 MB for PowerBI Pro

That is great! Now it has been more than 20 days since started. When we will be able to use it?