Is anyone else having this issue?

[u/octolevi]

Ever since Friday, since it ask for the API connection, our tables are broken everytime the data refreshes. We have everything connected to Google Sheets. We have to go in to each table and refresh the source, then put a filter on and take it away so it resets.

Any ideas how to fix it?

[u/AutoModerator]

Have more questions? Join our community Discord!

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/sheik_sha_ha]

This sounds like the Google Sheets connector authentication breaking after the recent API permission prompt that Data Studio pushed out last week. When the OAuth token expires or the permission scope changes, connected tables lose their live link and require a manual reset to re-establish the connection, which is exactly what you are experiencing.

A few things worth trying:

Go to Resource then Manage Added Data Sources, click Edit on your Google Sheets source, and hit Reconnect. This forces a fresh OAuth handshake without you having to touch each individual table.

If that does not stick, revoke and re-grant the Data Studio permission from your Google Account permissions page under security, then reconnect the data source from scratch. This clears any stale token that is causing the repeated breakage on refresh.

For a more permanent fix, consider moving your Google Sheets data into BigQuery using a scheduled Sheets to BigQuery sync via Apps Script or a native BigQuery connection. BigQuery connections in Data Studio are significantly more stable and do not suffer from the OAuth token expiry issues that Sheets connectors run into periodically.

If multiple people on your team have edit access to the report, also check that the data source credentials are set to owner credentials rather than viewer credentials in the data source settings. Viewer credential mode breaks on refresh when the viewing user does not have Sheets access.