Changing maximum number of rows to fetch
To change the default setting, navigate to the Data menu, and
change the value in the text box for Maximum number of rows to
fetch.
At the dashboard level, you can change this setting on the Data
tab of a filter widget.