If, when first connected, your sheets don't display any data or not all of it, chances are that there is an issue with the way your data is formatted. Here are a few reasons why.
Reason 1: The date range on the sheets doesn’t match the calendar on the report.
Make sure that whichever date range you have selected on the sheets, these dates are covered by the reporting calendar as well.
Reason 2. The date column has different date formatting across the sheets.
Make sure you settle on a "YYYY-MM-DD" date format. When using different date formats, in the report it might not show the data correctly for the date period that you have chosen.
Wrong example
Correct example