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

Table chart - Configuration Error

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

I have written Google App Script which periodically updates data to google sheets, and I have connected this sheet with Table chart in Google Data Studio.
So, whenever there is no record (we have headers) in Google Sheets it gives an connection error. Ideally it should show no data in table chart when we have only headers in source data.
Screen Shot:

1.JPG

2.JPG

 

Can you please let me know what wrong we are doing here ?

Table chart - Configuration Error

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

Hi!

 

If it's a configuration error, then the problem is with the data source. I would try adding "testing" data to your columns to see if something shows, but I don't think it will. 

 

Maybe review your data source or even your Sheets. 

Re: Table chart - Configuration Error

Follower ✭ ✭ ☆
# 3
Follower ✭ ✭ ☆

I created one test Sheet with only headers, and then tried to connect with Dashboard. It gives error like "No fields were found for this configuration.", please see below screen shot. Therefore, does it mean we should have at least one record along with headers to get connected with Data Studio?

 

555.JPG

 

666.JPG

 

 

Table chart - Configuration Error

Explorer ✭ ✭ ☆
# 4
Explorer ✭ ✭ ☆

Hey!

 

Never tried this so I guess that makes sense DS doesn't connect your data source if you don't have at least one row of data per dimension/metric. 

Table chart - Configuration Error

Follower ✭ ✭ ☆
# 5
Follower ✭ ✭ ☆

Hi,

In my initial post, I have mentioned that we are getting data into Google sheets through google app script. So, may be at some situation we don't have any records in Google sheets (but we do have headers and it won't change).

So, at least table chart should show "no data", instead of giving configuration error.

 

Any suggestions/inputs would be really helpful here.

 

Thank you,

Table chart - Configuration Error

Follower ✭ ✭ ☆
# 6
Follower ✭ ✭ ☆

Hello Team,

Looking for a solution here.

 

Thank you,