cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
carlossantiago
Frequent Visitor

Power BI limitations for large datasets

Hi guys,

 

Does anyone know what are the limitations for integrate datasets into Power BI? What is the limit in terms of records? The limitation on desktop is the same on the server?

 

Thanks

1 ACCEPTED SOLUTION
vanessafvg
Super User
Super User

@carlossantiago

 

it depends on a variety of things, large datasets can be compressed quite small if there is a lot of similar data, are you using imported mode?  some of the limitations will be your machine hardware, there is a limitation of 10gb i think in total but maybe 1gb per file, direct query obviously allows more space





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
v-chuncz-msft
Community Support
Community Support

@carlossantiago,

 

By the way, for custom visuals, check https://github.com/Microsoft/PowerBI-visuals/blob/master/Capabilities/DataViewMappings.md#data-reduc....

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
miltenburger
Helper V
Helper V

When using DirectQuery your max recordsrows is 1.000.000

See other message http://community.powerbi.com/t5/Service/direct-query-limitation/td-p/122894

vanessafvg
Super User
Super User

@carlossantiago

 

it depends on a variety of things, large datasets can be compressed quite small if there is a lot of similar data, are you using imported mode?  some of the limitations will be your machine hardware, there is a limitation of 10gb i think in total but maybe 1gb per file, direct query obviously allows more space





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.