Make Repeat Children - table rows disappear when expression is selected

Hi,
I have added a table to display customer information from an MSSQL database. I have setup a Multiple Records Query type.
When I try to bind the table to the query, as soon as I click on the “Make Repeat Children” Property, the sample records disappear. And no records are displayed even after adding the server connect expression.
If I enter 5 or 10 number values in the expression field, the sample rows are repeated as many times.
I have another table on the page and it is working correctly. This table has less than 10 records to display from the database.
I am not sure whether there is an issue due to the number of records. The table that is not working has ~8k records and is running as a View in the database.
I’d appreciate any suggestions to resolve this issue.
Thanks.

Community Page
Last updated: