In order to restrict the number of results, you can either use the limit clause or use a where condition.
The limit clause will limit the number of rows that would be retrieved when a query is executed in Denodo, which can be useful in this case.
For reference on this, access the link on [OFFSET, FETCH and LIMIT.](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/queries_select_statement/offset_fetch_and_limit/offset_fetch_and_limit)
You can also check the following link from the PowerBI Community on [Limiting Number of Rows in Table Visual](https://community.powerbi.com/t5/Desktop/Limiting-number-of-Rows-in-Table-Visual/m-p/761653).
Hope this helps!