Data Studio
1.9K members online now
1.9K members online now
Ask questions about Data Studio
Guide Me

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.