--- title: Underlying data access issues with Google Sheets, BigQuery and Looker Studio description: If you are joining the BigQuery data with tables that are connected to Google Sheets, reusing the query within Looker Studio may result in an error about missing access to the underlying data. This can happen if the user creating the Looker Studio report is not the same as the user connecting the Google Sheet to BigQuery originally. And this will happen even if the user has all access permissions to the original Google Sheet or to run queries in BigQuery. image: https://bubblemarble.pro/hubfs/DALL%C2%B7E%202024-07-21%2015.50.48%20-%20A%20highly%20minimalistic%20purple%20sketch%20illustrating%20the%20connections%20between%20tables%2c%20a%20database%2c%20and%20charts.%20Use%20simple%2c%20abstract%20icons_%20rectangular%20shape.png --- [Skip to Content](https://bubblemarble.pro/blog/underlying-data-access-issues-looker-bq-gsheets#body) [![bm-positive (1)](https://bubblemarble.pro/hs-fs/hubfs/bm-positive%20(1).png?width=161&height=70&name=bm-positive%20(1).png "bm-positive (1)")](https://bubblemarble.pro/?hsLang=en) - [Development](https://bubblemarble.pro) - [Marketing](https://bubblemarble.pro/marketing-services) - [AI Chat](https://chatts.ai/?utm_source=bm) [back to blog](https://bubblemarble.pro/blog) [Analytics](https://bubblemarble.pro/blog/topic/analytics?hsLang=en) # Underlying data access issues with Google Sheets, BigQuery and Looker Studio Read Time **1 mins** | Written by: Kostia L [mailto:?subject=Underlying%20data%20access%20issues%20with%20Google%20Sheets%2C%20BigQuery%20and%20Looker%20Studio&body=https%3A%2F%2Fbubblemarble.pro%2Fblog%2Funderlying-data-access-issues-looker-bq-gsheets](mailto:?subject=Underlying%20data%20access%20issues%20with%20Google%20Sheets%2C%20BigQuery%20and%20Looker%20Studio&body=https%3A%2F%2Fbubblemarble.pro%2Fblog%2Funderlying-data-access-issues-looker-bq-gsheets) ![](https://bubblemarble.pro/hubfs/DALL%C2%B7E%202024-07-21%2015.50.48%20-%20A%20highly%20minimalistic%20purple%20sketch%20illustrating%20the%20connections%20between%20tables%2c%20a%20database%2c%20and%20charts.%20Use%20simple%2c%20abstract%20icons_%20rectangular%20shape.png) I like using Google Sheets as an external data source in BigQuery. It is strange in some ways, but has its benefits: - You can use Gsheet as manual input from end users. - You can use Gsheet as a temporary solution to cover the need for data (in my case I used the daily exchange rate that I pulled from Google Finance and used in BigQuery calculations). - Or you can use it as additional data to be combined with the rest of the data. You can have a version of a business plan where you take the target values to compare with the actual metrics.   What I want to dive into, is an error that I got for different projects within the last weeks, and that I couldn’t find an answer to quickly.   The solution is quite odd, but simple and effective. All you need to do is add any Google Sheet as a direct data source to your Looker Studio report. This will trigger an authorization process, and once it is connected, all other problems with querying tables, connected to Google Sheets disappear. You have to do it once, and then it will take effect on the user account level, so other Looker Studio reports will start working as well. ## Lets work on your project together! [Get in touch](https://bubblemarble.pro/get-in-touch?hsLang=en) ##### Kostia L Share the Love [mailto:?subject=Underlying%20data%20access%20issues%20with%20Google%20Sheets%2C%20BigQuery%20and%20Looker%20Studio&body=https%3A%2F%2Fbubblemarble.pro%2Fblog%2Funderlying-data-access-issues-looker-bq-gsheets](mailto:?subject=Underlying%20data%20access%20issues%20with%20Google%20Sheets%2C%20BigQuery%20and%20Looker%20Studio&body=https%3A%2F%2Fbubblemarble.pro%2Fblog%2Funderlying-data-access-issues-looker-bq-gsheets) You May Like These ## Related Articles ![](https://bubblemarble.pro/hs-fs/hubfs/ChatGPT%20Image%20Feb%2020%2c%202026%2c%2002_55_38%20PM.png?width=700&name=ChatGPT%20Image%20Feb%2020,%202026,%2002_55_38%20PM.png) Development ### [Casino Games Integration in the US: Single API Guide, Architecture & Go-Live Checklist](https://bubblemarble.pro/blog/casino-games-integration-in-the-us-checklist?hsLang=en) Learn how casino games API integration works for US operators. Explore single API aggregation, walle... Keep Reading ![](https://ucarecdn.com/276b3876-f4f5-44bd-a6fb-bef24e91a07c/-/preview/1000x1000/) Marketing ### [How to attract and convert leads through SEO and Paid Ads](https://bubblemarble.pro/blog/growth-strategy-for-service-based-businesses?hsLang=en) local business seo for service businesses: how to win more leads with SEO and Paid Ads, from local s... Keep Reading ![](https://ucarecdn.com/e0cb963b-6e85-4dfb-b557-7b39c3f0798b/-/preview/1000x1000/) Marketing ### [Step-by-step plan for improving performance metrics](https://bubblemarble.pro/blog/90-day-growth-roadmap-for-digital-brands?hsLang=en) digital growth plan for founders: a 90-day seo ppc roadmap with CRO, benchmarks, and tools to improv... Keep Reading [![bm-negative (3)](https://bubblemarble.pro/hs-fs/hubfs/bm-negative%20(3).png?width=115&height=50&name=bm-negative%20(3).png "bm-negative (3)")](https://bubblemarble.pro?hsLang=en) Bubble Marble LTD ©  2024 [Blog](https://bubblemarble.pro/blog) [Privacy policy](https://bubblemarble.pro/privacy-policy?hsLang=en) ###### Services - [Product analytics](https://bubblemarble.pro/product-analytics) - [Automated Content Creation](https://bubblemarble.pro/automated-content) - [Marketing Services](https://bubblemarble.pro/marketing-services) - [Site speed impact](https://bubblemarble.pro/site-speed-revenue-calculator) - [Affiliate performance optimization](https://bubblemarble.pro/affiliate-performance) - [Ecommerce performance optimization](https://bubblemarble.pro/ecommerce-performance-optimization) ###### Contact Us [sales@bubblemarble.pro](mailto:sales@bubblemarble.pro) Have a question? Feel free to reach out. We love to hear from you! ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Kostia L", "url" : "https://bubblemarble.pro/blog/author/kostia-l" }, "dateModified" : "2024-07-21T13:56:26.929Z", "datePublished" : "2024-07-21T13:53:44.000Z", "headline" : "Underlying data access issues with Google Sheets, BigQuery and Looker Studio", "image" : [ "https://bubblemarble.pro/hubfs/DALL%C2%B7E%202024-07-21%2015.50.48%20-%20A%20highly%20minimalistic%20purple%20sketch%20illustrating%20the%20connections%20between%20tables%2c%20a%20database%2c%20and%20charts.%20Use%20simple%2c%20abstract%20icons_%20rectangular%20shape.png" ], "mainEntityOfPage" : { "@id" : "https://bubblemarble.pro/blog/underlying-data-access-issues-looker-bq-gsheets", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://bubblemarble.pro/hubfs/bm-positive%20(1).png" } } } ```