Some parameterized queries return no more than 1000 rows¶

What is new - 25.0¶

Reports that use an SQL parameterized query as a data source can leverage parameter binding by using question marks (?). The Studio automatically creates a parameter for each question mark. However, when using a declared variable instead of parameter binding, the result may be limited to returning no more than 1,000 rows, even when additional rows are available in the database. This 1,000-row limitation is a common issue when working with large datasets. Although using declared variables may appear to be a valid solution, it does not always function correctly. While we have resolved an issue related to this behavior, we strongly recommend against replacing parameter binding with a declared variable. --- Let me know if you'd like further adjustments!