Data Studio
462 members online now
462 members online now
Ask questions about Data Studio
Guide Me

Announcing BigQuery data source improvements

Google Employee
# 1
Google Employee

Dear Data Studio fans;


This week, we've made 2 improvements to BigQuery data sources:


  • You can now enable or disable automatic date detection in date-partitioned tables. 
  • You can now override the default Billing Project ID and Project ID in custom queries.


By default, if you are using date-partitioned tables in BigQuery, the data sources uses the table's partition time as the date range dimension.  Now, you can uncheck the Use _PARTITIONTIME as time dimension option while creating or editing the data source connection to use explicit date fields in the table as the date range dimension.


Overriding the default project IDs helps large users of BigQuery, who may have more projects than will fit in the displayed list. 


As always, thanks for your interest in Data Studio!


Then Data Studio team

1 Expert replyverified_user