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

feb52e32 4211-40d6-aa83-410bae410e6a 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

7e62290b eb59-48f0-926a-0d0ba4cd5ea9 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

caf46d12 364c-4a04-bfe8-5ef6f1e5183b 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

6c8bf776 a03f-4a31-b8ca-c658d2a63742 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

355a81e2 0dac-47d2-a1b9-e63ff15e5227 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

b6ee1c6b 2998-467a-a230-36557965d615 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

56b4748e 386d-439e-8d83-91486f8d7740 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

dc220a6c c93c-480c-955f-c51759ff3635 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

62b47818 3a3f-4a84-acec-e068ee055509 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

50edaf24 0bb3-4eae-864f-fc97f23ee413 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?