Power BI Premium Accessing Trino Datasets (2 Billion Rows × 3 Columns / 3 Million Rows × 800 Columns

[Rita2]

We use Power BI Premium Gen2, connect to Trino data source via DirectQuery/Import modes, and need to access two types of data for report development. We kindly request official confirmation on the following:

1. Dataset ①: 2 Billion Rows × 3 Columns (Narrow Table); Dataset ②: 3 Million Rows × 800 Columns (Ultra-Wide Table
2. Does Power BI Premium officially support the access of these two datasets?
3. Performance impacts, official risk thresholds and recommended solutions under DirectQuery/Import modes.
4. 2 Billion Rows × 3 Columns: DirectQuery supportability, whether Import mode exceeds upper limit, and performance impacts.
5. 3 Million Rows × 800 Columns: Whether 800 columns are supported, performance impacts, official safe column count and optimization solutions.

Clarify support conclusion, performance risks, scenario-specific best practices and whether preprocessing is needed on Trino side.

[v-saisrao-msft]

Hi @Rita2,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

[v-saisrao-msft]

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.

[v-saisrao-msft · Accepted solution]

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.