Looker Studio - BigQuery query

[Allbright]

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]

@Allbright

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

https://support.google.com/looker-studio/answer/6370296?#connect-to-custom-query&zippy=%2Cin-this-article

I hope it helps.

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

Mehdi