Increase dataset size limit from 250 MB for PowerBI Pro
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.
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
Andy T. commented
1GB is just not sufficient for many uses.
J Michael Williams commented
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.
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...
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 ?
Matt Allington commented
This has been delivered. Please close this so we can get our votes back
Didn't they just announce an increase to 1GB file sizes?
Ali Uluğ commented
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?
any comment on when this might be available?
Cliff Brandon commented
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.
Great! When will be able to use this, really need this!
That is great! Now it has been more than 20 days since started. When we will be able to use it?
Florian Kiene commented
When do you think this feature will be published?
wow great! (hope this is not April Joke :))
Jonathan Aisenberg commented
woohoo! couldn't be more pumped
Zach Fransen commented
Either this or provide a PaaS tabular implementation.
Same to me. Useless this low size of data
Our organization collects over a billion events every day, aggregating several into business views in our data warehouse, which is then pushed to PowerBI, which we are trying to use as our primary dashboarding/routine analytics platform. This limit is starting to kill us, as we can only cut certain events by 6 dimensions or so before we hit this limit.
1GB would be great! 500MB would solve most
250MB is perfect for presentation not for real