Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
wojciech
Helper I
Helper I

PowerBI Dataset size limit in Fabric capacity

Hi All,

 

I was wondering what is PowerBI Dataset size limit in Fabric capacity.

 

I know that in Fabric, storage is de-capuled form compute so if you are using direct lake storage mode then dataset size limit doesn't matter. 

 

Howevere, what is I want to host my PowerBI datasets in a more afordable Fabric capacity, and have them in import mode becouse my source data is SQL.

P1 which is equivalent to F64 has got 25GB dataset limit, what about Fabric capacities below F64?

 

Any thoughts more then welocme 

 

WJ 

3 REPLIES 3
pratyashasamal
Super User
Super User

Hi @wojciech ,

There is no data volume limitation for a load for either DirectQuery or Import. However, when you publish a pbix file over 1GB to Power BI Service, you will get limitation error message. That is to say, the data set of a single pbix file you are going to publish must be smaller than 1 GB. Power BI Premium supports uploads of Power BI Desktop (.pbix) files that are up to 10 GB in size. Once uploaded, a dataset can be refreshed to up to 12 GB in size. To use a large dataset, publish it to a workspace that is assigned to Premium capacity.

 

Reference:

File size limit increase to 1 GB

Power BI Premium support for large datasets

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Thank you Pratyasha,

 

In plain english, if I want a large dataset in import mode, they need to be hosted on PowerBI Premium capacity as Fabric capacity won't support it?

Power BI Premium does support large datasets. Enable the Large dataset storage format option to use datasets in Power BI Premium that are larger than the default limit.

With Premium capacities, large datasets beyond the default limit can be enabled with the Large dataset storage format setting. When enabled, dataset size is limited by the Premium capacity size or the maximum size set by the administrator.

You can follow this link :-
https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-large-models





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.