This article will assist with the following issue:
A Google Sheets report is missing data or does not show enough data for a date range.
Cause
Power My Analytics' Google Sheets connector defaults to a 1,000 row limit.
Solution
Check the sidebar under Options. The row limit can be increased up to 1,000,000.