Prasenjit
Prasenjit

Reputation: 5

Adding BigQuery query result in an already existing report in Google Data Studio(Looker Studio)

I have an already existing Google Data Studio(Looker Studio) Report where the data is coming from a Google BigQuery table. Now when I am making a new query using that table and trying to attach the query result in the existing data studio report, it is not hapenning. Basically I am not getting any option to attach the query result in the already existing data studio report. Need help regarding this issue.

First I ran the query on a table in bigquery and exported the result in a data studio report. Now when i am running another query on the same table, I can't able to add the new result in the already existing dashboard report. When I am exporting the query result, every time it is generating a new dashboard report.

Upvotes: 0

Views: 803

Answers (1)

aleph
aleph

Reputation: 130

If you use Big Query table as a data source in your report, each time that Looker Studio document is loaded or its filters are updated, Looker Studio will run a query to the data source to fetch data. You should have no problem to display new info in your report if you insert the new rows in the right table.

As you mention you are trying to update the data with a query result, you can write the result to the datasource table as destination table.

Upvotes: 0

Related Questions