I'm not sure this approach is feasible by the data size perspective, but anyways..
Got to datasource and right click and View Data.
You can see the number of rows.
And clicking top -right same as excel, you can select all the data and copy ==> paste to excel or something to validate..
If the data volume is significantly big, you can drag
And get number of items as well.