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

Joining multiple Bigquery tables with Custom Query does not work with federated tables

Explorer ✭ ✭ ✭
# 1
Explorer ✭ ✭ ✭

I have been using Bigquery to join multiple datasets in Data Studio, and it works well unless the Bigquery tables are using Google Sheets as the data source.

After doing lots of tests with many datasets, I believe that Data Studio either has a bug that prevents it from querying federated tables specifically or there is an API or setting in the Cloud Console that needs to be enabled. I feel like I've tried everything at this point so if anyone has any tips or fixes for this issue, I would love to hear them!