Looker Studio - BigQuery query

Allbright · 12-02-2024 07:37 AM

Hi

Not sure how this works (first time posting) but I have inherited a Looker Studio report and need to sync it up with a BigQuery query.

When I attempt to add a data source from BigQuery, I can choose from any existing tables but I cannot choose a query.

Am I not permitted to use a BigQuery query as a data source for a LookerStudio report? That would seem weird bearing mind the name of BigQuery.

So, assuming I should be able to see the queries, what do I need to do to connect them?

Thanks

Mehdi_Oudjida

Here how to create a BigQuery custom query as a data source.

I hope it helps.

Feel free to tell me if you need more info, otherwise you can accept this answer as a solution.

Mehdi