Forum Discussion
Power BI Premium Accessing Trino Datasets (2 Billion Rows × 3 Columns / 3 Million Rows × 800 Columns
- Dataset ①: 2 Billion Rows × 3 Columns (Narrow Table); Dataset ②: 3 Million Rows × 800 Columns (Ultra-Wide Table
- Does Power BI Premium officially support the access of these two datasets?
- Performance impacts, official risk thresholds and recommended solutions under DirectQuery/Import modes.
- 2 Billion Rows × 3 Columns: DirectQuery supportability, whether Import mode exceeds upper limit, and performance impacts.
- 3 Million Rows × 800 Columns: Whether 800 columns are supported, performance impacts, official safe column count and optimization solutions.
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.
3 Replies
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,
Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.
Thank you.
Hi Rita2,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.