Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Solved! Go to Solution.
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
Proud to be a Super User!
By the way, for custom visuals, check https://github.com/Microsoft/PowerBI-visuals/blob/master/Capabilities/DataViewMappings.md#data-reduc....
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
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
Proud to be a Super User!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.