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.

データ型

int

デフォルト値

100000

解説

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 本製品 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.