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

Power BI dataset size limit

bimchahaha_0-1611026386707.png

So my report (.pbix) has 10 Datasets.... so if I am a user of PowerBI pro. so that report max size is 1GB ???? No matter how many datasets are there in the reports ??? And using import mode ?

1 ACCEPTED SOLUTION
v-caitlyn-mstf
Community Support
Community Support

Hi,@bimchahaha 

 

I am not very agree with your opinion that your report (.pbix) has 10 datasets.

One Pbix file corresponds to one dataset. There is a 1 GB limit per dataset that is imported into Power BI. If you have chosen to keep the Excel experience, instead of importing the data, the limit is 250 MB for the dataset.

 

Please notice that if we say max dataset size is 1 GB - it means the dataset of a single pbix file you are going to publish must be smaller than 1 GB. when you publish a pbix file over 1GB to Power BI Service, you will get limitation error message.

For more information, please refer to this: https://docs.microsoft.com/en-us/power-bi/connect-data/service-get-data

 

Depending on the SKU, Power BI Premium supports uploading Power BI Desktop (.pbix) model files up to a maximum of 10 GB in size. You should have at least a P1 or an A4 SKU for any datasets larger than 1 GB.

For more information, please refer to this: https://docs.microsoft.com/en-us/power-bi/admin/service-premium-what-is#large-datasets

 

 

Hope it helps.

 

Best Regards,

Caitlyn Yan

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Adam_Summers_ms
Microsoft
Microsoft

Hey @bimchahaha ,

 

regardless of how many different queries you are importing, 1G is actually a _lot_ of memory if you use it wisely to build a model. The key is not to assume that you just import a table from a source, and do no ETL. For example, if you are importing datetimes, and you only really need the date, then only store the date (and if you need the time, often keep that in a separate field) -- this reduces the cardinality of the column, and saves a LOT of memory.

 

It can be a tough learning curve, but I highly recommend this as a bible: Definitive Guide to DAX, The (2nd ed.) by Russo, Marco (ebook) (ebooks.com)

 

Cheers,

Adam

v-caitlyn-mstf
Community Support
Community Support

Hi,@bimchahaha 

 

I am not very agree with your opinion that your report (.pbix) has 10 datasets.

One Pbix file corresponds to one dataset. There is a 1 GB limit per dataset that is imported into Power BI. If you have chosen to keep the Excel experience, instead of importing the data, the limit is 250 MB for the dataset.

 

Please notice that if we say max dataset size is 1 GB - it means the dataset of a single pbix file you are going to publish must be smaller than 1 GB. when you publish a pbix file over 1GB to Power BI Service, you will get limitation error message.

For more information, please refer to this: https://docs.microsoft.com/en-us/power-bi/connect-data/service-get-data

 

Depending on the SKU, Power BI Premium supports uploading Power BI Desktop (.pbix) model files up to a maximum of 10 GB in size. You should have at least a P1 or an A4 SKU for any datasets larger than 1 GB.

For more information, please refer to this: https://docs.microsoft.com/en-us/power-bi/admin/service-premium-what-is#large-datasets

 

 

Hope it helps.

 

Best Regards,

Caitlyn Yan

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

StefanoGrimaldi
Solution Sage
Solution Sage

exactly, each dataset cant be bigger them 1gb and each workspace cant get more tham 10gb of total space (these its multiplied by each existing license of power bi pro but not to tha workspace total but the amount of possible workspaces. )

using import mode its the one option that consumes more space but load the least on your company servers if they are the source and gateway location. 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors