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

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!