Forum Discussion
Power BI Premium Accessing Trino Datasets (2 Billion Rows × 3 Columns / 3 Million Rows × 800 Columns
Hi Rita2,
Power BI can handle large datasets, but Import mode is not suitable if data exceeds memory or refresh limits. For scenarios with very large datasets, such as 2 billion rows, DirectQuery or Hybrid mode is recommended. DirectQuery has a 1 million row limit per query and requires data aggregation, with performance depending on the source, so optimizing Trino is important. Microsoft recommends doing transformations, indexing, and pre-aggregation at the source for better performance. Wide tables with around 800 columns are supported, but visuals are limited to about 125 columns for large results, which can impact performance, so reducing columns and proper modeling are necessary. In Premium, some limits like row set size can be increased, but they must be managed according to the datasource and capacity to avoid performance issues.
DirectQuery in Power BI: When to Use, Limitations, Alternatives - Power BI | Microsoft Learn
Use DirectQuery in Power BI Desktop - Power BI | Microsoft Learn
DirectQuery model guidance in Power BI Desktop - Power BI | Microsoft Learn
How to configure workloads in Power BI Premium - Microsoft Fabric | Microsoft Learn
Thank you.
Hi Rita2,
Power BI can handle large datasets, but Import mode is not suitable if data exceeds memory or refresh limits. For scenarios with very large datasets, such as 2 billion rows, DirectQuery or Hybrid mode is recommended. DirectQuery has a 1 million row limit per query and requires data aggregation, with performance depending on the source, so optimizing Trino is important. Microsoft recommends doing transformations, indexing, and pre-aggregation at the source for better performance. Wide tables with around 800 columns are supported, but visuals are limited to about 125 columns for large results, which can impact performance, so reducing columns and proper modeling are necessary. In Premium, some limits like row set size can be increased, but they must be managed according to the datasource and capacity to avoid performance issues.
DirectQuery in Power BI: When to Use, Limitations, Alternatives - Power BI | Microsoft Learn
Use DirectQuery in Power BI Desktop - Power BI | Microsoft Learn
DirectQuery model guidance in Power BI Desktop - Power BI | Microsoft Learn
How to configure workloads in Power BI Premium - Microsoft Fabric | Microsoft Learn
Thank you.