This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

how to perform data manipulation (insert/update) actions to the BQ table from the dashboard

Posted on 10-11-2024 07:04 AM
suryal
New Member
Reply posted on --/--/---- --:-- AM

I understand that the Looker Studio dashboards are primarily used as a data visualization/reporting tool. However, I'm curious to know whether we have an approach to trigger the BQ queries or cloud function/runs to insert/update the data in the BQ table from the UI of the Looker studio dashboards. Please suggest some approach.

0 1 136
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
sam8
Staff
Reply posted on --/--/---- --:-- AM

You're correct that updating/inserting isn't really what Looker Studio is built for. 


You can add hyperlinks to Looker Studio dashboards, which I think is about as close as you will get. If you have a URL that updates BigQuery, you could have users click that. Unfortunately, I don't think there is any way to pass user input.

If you have Looker, there might be some ways to make this work. You can pass data values and parameter values through hyperlinks and actions. 

0 Likes