Forum Discussion
Helper IVQuestion about Import mode 1GB definition
Hi pennyhoho117
The 1GB limit for Power BI Pro users applies to the compressed size of the dataset after it has been imported and processed by Power BI. This limit is for the dataset size in the Power BI service, not the original data source size.
Data Compression in Import Mode
Power BI uses advanced compression techniques when importing data:
• The VertiPaq engine, which Power BI uses, can achieve significant compression ratios, often around 10x.
• For example, 10GB of source data might compress down to about 1GB in Power BI.
• Compression rates can vary depending on data characteristics, such as cardinality and data types.
Row Limits
• The 1 million row limit specifically applies to DirectQuery mode, not Import mode.
• In Import mode, there is no hard limit on the number of rows, as long as the compressed dataset size remains under 1GB (for Pro users).
Column Limits
• The 16,000 column limit applies to both Import and DirectQuery modes.
• This limit includes the total number of columns across all tables in the dataset.
• Power BI actually uses an internal row number column, so the practical limit is 16,000 minus one.https://blog.crossjoin.co.uk/2022/11/21/how-much-data-can-you-load-into-power-bi
Please accept this solution and give kudos if this is helpful
Super UserHi pennyhoho117
The 1GB limit for Power BI Pro users applies to the compressed size of the dataset after it has been imported and processed by Power BI. This limit is for the dataset size in the Power BI service, not the original data source size.
Data Compression in Import Mode
Power BI uses advanced compression techniques when importing data:
• The VertiPaq engine, which Power BI uses, can achieve significant compression ratios, often around 10x.
• For example, 10GB of source data might compress down to about 1GB in Power BI.
• Compression rates can vary depending on data characteristics, such as cardinality and data types.
Row Limits
• The 1 million row limit specifically applies to DirectQuery mode, not Import mode.
• In Import mode, there is no hard limit on the number of rows, as long as the compressed dataset size remains under 1GB (for Pro users).
Column Limits
• The 16,000 column limit applies to both Import and DirectQuery modes.
• This limit includes the total number of columns across all tables in the dataset.
• Power BI actually uses an internal row number column, so the practical limit is 16,000 minus one.
https://blog.crossjoin.co.uk/2022/11/21/how-much-data-can-you-load-into-power-bi
Please accept this solution and give kudos if this is helpful