How can I solve error ID: 7c43b14a?

[robindiego_]

Hey there, I created a dashboard using Typeform data stored in a Google Spreadsheet through the API.

I noticed that the "Submitted At" field retrieved via the API is +7 hours ahead of my timezone, so I tried to fix this by creating a new calculated field with the following formula:

"DATETIME_SUB(
PARSE_DATETIME("%d/%m/%Y %H:%M:%S", Submitted At),
INTERVAL 7 HOUR
)"

However, when I tried to use this field to create charts, I encountered the following error:

"Looker Studio cannot connect to your data set.

The data from the underlying Google Sheet could not be retrieved.

error ID: 7c43b14a"

I have already tried the following:
1. Check Google Sheets Access
2. Re-authenticate Google Sheets Data Source
3. Verify Google Sheet Link
4. Check Data Source Configuration
5. Share the Google Sheet
6. Clear Cache

Unfortunately, none of these solutions worked.

Does anyone know how to solve this?

Thanks in advance!

[Mehdi_Oudjida]

@robindiego_ 

To check if it is a parsing problem first:

PARSE_DATETIME("%d/%m/%Y %H:%M:%S", Submitted At) returns the expected Date time values? 

[robindiego_]

Hey Mehdi, thanks for your reply.

I have already created a new calculated field using the instructions you sent me, but the same message appears, although the error ID has changed:

"Looker Studio cannot connect to your data set.
The data from the underlying Google Sheet could not be retrieved.
Error ID: d52d57f5"

However, I checked my spreadsheet, and the "Submitted At" column has the following structure: "%d/%m/%Y %H:%M:%S" (e.g., 12/07/2024 14:11:47).

Do you have any idea what might be happening?

[Mehdi_Oudjida]

@robindiego_ 

What field type is it in Sheets on one hand and in LS on the other hand? 

[loopa_market]

I have a similar problem, did you solve the problem?