Usually, this is caused by:
1.) Active filter(s) in the view.
To remedy this, click the More actions button (3 vertical dots) and select Clear filters.
Clear all filters.
2.) Remaining rows weren’t included in the datasource range.
The range must have been configured to only go as far as the nth row.
In our example, there are 26 rows of data but only 11 are shown because P13 was specified in the datasource range. As a consequence, only 11 records (2 for the header & parameters row, 11 for the data) will only be displayed on your view even though the entire row is specified in the datasource range.
Follow the prescribed format of entering the data range:
You can learn more about this here.
This ensures that newly added rows will automatically be reflected in your view.
Don’t forget to click the UPDATE VIEW button for the changes to take effect.
3.) A significant number of records (rows) were hidden - intentionally or accidentally.
Simply unhide the rows.
4.) The Google Sheets datasource is currently filtered to a specific subset(s).
Clear or remove all filters to reflect all the records on your view.
In our example, there are 26 rows of data but only 2 are shown because it’s currently filtered to show the category Spreadsheet under the Type column. As a consequence, only 2 records will only be displayed on your view even though the entire row is specified in the datasource range.
Never filter or hide row(s) of the datasource.