Specifies the maximum number of rows returned by queries in both Import and DirectQuery modes.

Data Type

int

Default Value

10000

Remarks

This property applies to all Power BI operations, including Import and DirectQuery modes.

If a query requests more rows than the specified value, the connector rewrites the query to the DirectQueryLimit value.

This property helps control memory usage and improve performance when working with large datasets.