Limits the number of rows when using the DirectQuery mode. This helps avoid performance issues at design time.

Data Type

int

Default Value

10000

Remarks

Limits the number of rows returned when using the DirectQuery Mode. This limit only applies when aggregation is not being used. Queries with SUM, MIN, MAX, GROUP BY, and so on will not be limited.