The number of response rows to allow before triggering an error. 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 Microsoft Power BI XMLA. 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 alert the user to very expensive requests.