Data Studio
2.4K members online now
2.4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Configuration Error with Google Sheet as Data Source

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I'm seeing a recurring issue where after a period of time a Report that we have connected to a Google Sheets data source begins throwing Configuration Errors.

 

The details reads:

Error Details

Changes to fields in the Google Sheet detected. Please refresh data source fields.
Learn more about the Google Sheets connector in Data Studio.

Error ID: 41235df4

 

Refreshing the data source connection and/or fields does not resolve the issue. The Google Sheet in question is not getting modified either... I'm at a loss as to what to do to troubleshoot this. I've rebuilt the data source from scratch and the error keeps appearing a few hours into building the Report.

 

Thanks in advance for the help!

 

Configuration Error with Google Sheet as Data Source

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hello Josh,

 

I had similar Configuration Errors using Google Sheets as the data source. It turned out to be the YYYYMMDD date format, even when selecting this format in the Google sheet the individual cells held the dates as MM/DD/YYYY. You could try converting the date column from a date to a number format in excel / csv before you upload it to Google Sheets. This fixed it for me so if your errors are stemming from the same issue it should work.