Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.

Syntax

Connect-ExcelServices -MaxRows string

Data Type

cstr

Default Value

"-1"

Remarks

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.