Hello everyone,
We're facing a recurring issue with our Looker Studio setup and are looking for some guidance.
Background
We have a series of Looker Studio reports that visualise data from an AppSheet data source. To improve performance, we use an "Extract Data" source in Looker Studio, which acts as a cache. This data extract is scheduled to refresh automatically once every 24 hours.
The data flow is: AppSheet -> Looker Studio "Extract Data" (daily refresh) -> Looker Studio Reports.
The Problem
Over the last year, the daily data extraction has been failing more and more often. When it fails, it seems the AppSheet source provides no data during the refresh process. This leaves our reports empty for the next 24 hours until the next scheduled update.
We have a manual workaround where clients can press the "Save and Extract" button in the "Extract Data" source settings. This usually fixes the problem for the day, although it sometimes requires multiple attempts.
The failures are intermittent, and we've recorded them on the following dates:
- June 12, 2025
- June 6, 2025
- June 4, 2025
- May 28, 2025
- April 30, 2025
- November 22, 2024
What We've Tried
The only change we've attempted is adjusting the scheduled time of the daily refresh, but this has had no noticeable effect on the frequency of failures.
Help appreciated
What could be causing these intermittent data extraction failures between our AppSheet source and Looker Studio? We would appreciate any suggestions on how to diagnose or resolve this.
Thank you for your help!
Note: I am aware that there have been related outages, but based on this status, they should be fixed - https://www.google.com/appsstatus/dashboard/products/FWjKi5U7KX4FUUPThHAJ/history
Update 2025.06.12
When manually testing the data extraction to the cached data source, I have managed to get the following exception twice on the "Extract Data" data source side:
Sorry, we encountered an error and were unable to complete your request.
Error ID: e1fb7a5f
LinkedIn
Twitter
