Panels not updating before report is sent

Morning

I am using the Grafana online free account to be able to schedule some dashboard reports via email.
The datasource is an elastic search cluster on aws.
When the 7 day report runs, it takes a while to produce the data for the panels.
It seems that the scheduled report is not waiting for the data to fully load on the panels and is sending the pdf of the dashboard with a bunch of panels showing “No data” or “N/A”

The daily reports we send out are always populated fine, i assume because it queries much less data.

If I load the dashboard myself, it loads fines but with a delay.
Is there any way around this issue, seems like a timing issue to me. Any advice would be appreciated.