Specifies the maximum number of response rows allowed before triggering an error. Use 0 to remove the limit entirely. This property helps prevent performance issues caused by large queries.

Data Type

int

Default Value

100000

Remarks

Selecting a large number of columns can create multiple crossjoins when the query is translated into MDX, as required by Microsoft Power BI XMLA. Crossjoins often lead to very large response sets, which may time out or degrade performance. If the response exceeds the specified row limit, the connector triggers an error to alert you to the high cost of the query.

This property provides a safeguard against unintentionally expensive requests. If you know your queries will generate large responses and want to process them, you can increase the limit or set it to 0 to disable the restriction. However, use caution when setting a very high limit or removing the limit altogether, as it may lead to performance degradation or timeouts.