The number of response rows to allow before erroring. Set to 0 for no limit.

Data Type

int

Default Value

100000

Remarks

Selecting a lot of columns results in a number of crossjoins occurring under the hood when translated to something that is acceptable for SQL Server Analysis Services. This is not intuitive if you are not familiar with MDX. It can easily result in very large responses that time out. The ResponseRowLimit is designed to try and alert the user to understand what can be very expensive requests.