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
5.6K members online now
5.6K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Date Not Coming In As Date For One BQ Table ( even though its identical format to other tables )

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

I have a BQ table with a DATE field, it shows as a date field in the BigQuery table viewer.  It is a legacy table.

 

When I import it into DataStudio, I have to force it to be a date ( it tries to be an int).  

 

Then when I try to use it to create a timeseries it does not load ( I get garbage dates ).

 

I have the same date format column in another BG table, and it loads as date just fine. What gives?

 

If I have a BigQuery table telling me its a date column, shouldn't DataStudio load it as a date?

 

PS: I tried using standard sql views but DataStudio complained it was trying to use legacy sql to load a standard sql view, so that doesn't work.