Exclude empty rows from the returned data

[ivanahuckova]

Google Sheets data source be improved to automatically exclude empty rows from the returned data. For example, using the range Sheet!!A1:J can result in ~1000+ rows being returned, often with numerous trailing empty rows. This adjustment would ensure that only relevant data is retrieved, eliminating the need for additional filtering and manual range specifications. (more context here).

This was brought up by data viz team that mentioned that data source should do the best-effort data structuring around its own unique quirks, since handling every quirk of every data source at the panel level once we've received bad data is not a super amazing or sustainable solution.

Workaround: User can specify only rows that have values - e.g.Sheet!!A1:J100