Occasionally, not all reports are updated as scheduled. This issue typically arises when there are more than 15 reports queued for a data refresh.
It's important to note that data refreshing is subject to a strict time constraint — it must be completed within 6 minutes. Therefore, when a Google Sheets document contains a large number of reports, this time frame may be insufficient to update all the reports.
To ensure timely updates, we recommend dividing numerous reports across multiple Google Sheets documents. This approach helps to manage the data refresh process more efficiently, preventing the time limit from hindering the update of all reports.