You can translate the question and the replies:

How to restrict results returned in PowerBI using a parameter?

we have a table in denodo with a time dimension, can we restrict the number of results using a parameter in PowerBI?
Parameter Power BI
user
03-05-2022 16:08:18 -0400
code

1 Answer

Hello, 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!
Denodo Team
04-05-2022 12:25:18 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here