MaxRows Parameter (Connect-ExcelOnline Cmdlet)
Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.
Syntax
Connect-ExcelOnline -MaxRows int
Data Type
int
Default Value
-1
Remarks
Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.