AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

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

Google Cloud SQL & Data Studio = Invalid Dimension

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I've succesfully created a Google Cloud Console Data source and the columns are being correctly brought in as fields.

 

However, when adding a simple "table" of data, the dimensions and metrics are shown as "Invalid Dimension" or "Invalid Metric".

 

There is dummy data in the table and doing a SELECT query shows the data correctly.

 

Really at a loss as to why this isn't working...

Google Cloud SQL & Data Studio = Invalid Dimension

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I'm experiencing the same thing with the PostgresSQL connector, I expect there's a bigger issue/bug around this. Thanks for posting, glad to see it wasn't just me.

Google Cloud SQL & Data Studio = Invalid Dimension

EB
Visitor ✭ ✭ ✭
# 3
EB
Visitor ✭ ✭ ✭

Also seeing this, from a quick look at the data of my dimensions which are failing It (MIGHT) be the existence of characters such as "_" and or data which is non english. Have yet to confirm or test either theory 

 

Google Cloud SQL & Data Studio = Invalid Dimension

EB
Visitor ✭ ✭ ✭
# 4
EB
Visitor ✭ ✭ ✭

Checked again today issue might be resolved can anyone else check ?