cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
carlossantiago
Frequent Visitor

Power BI limitations for large datasets

‎10-10-2017 02:49 AM

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

Labels:
Message 1 of 4
3,248 Views
0
1 ACCEPTED SOLUTION
vanessafvg
Super User
Super User

‎10-10-2017 03:11 AM

@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

Message 2 of 4
5,397 Views
3 REPLIES 3
v-chuncz-msft
Community Support
Community Support

‎10-10-2017 11:29 PM

@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.
Message 4 of 4
3,198 Views
0
miltenburger
Helper V
Helper V

‎10-10-2017 03:16 AM

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

Message 3 of 4
3,236 Views
vanessafvg
Super User
Super User

‎10-10-2017 03:11 AM

@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!




Message 2 of 4
5,398 Views

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.

View All