Error: Missing BigQuery Scopes
When setting up or running BigQuery exports in Power My Analytics, you may see an error message stating “Missing BigQuery Scopes.” This means the Google account you use as your BigQuery destination is missing the permissions Power My Analytics needs to write your data. This guide explains the cause and walks you through reconnecting with the correct permissions.
Error
“Missing BigQuery Scopes”
- Affected Data Destination: BigQuery exports
- Affected Component: Exports > BigQuery > Create Export (or Edit Export) > Destination
- Occurs: When selecting or using a Google account as a BigQuery destination
Cause
This error occurs when the Google account connected as your BigQuery destination is missing the BigQuery permissions (scopes) that Power My Analytics needs to write your data. It usually happens when the account was first connected without granting both BigQuery permissions, or when those permissions were later removed or expired.
BigQuery is a destination, not a data source. You will not find a BigQuery account under Sources to reconnect. You reauthorize your Google account directly in the export configuration, using the steps below.
Solution
To resolve this error, reconnect your Google account from the export configuration screen. This prompts Google to grant the BigQuery permissions Power My Analytics needs.
- In your hub, go to Exports > BigQuery.
- Click + Create Export, or click the pencil (Edit Export) icon on the export showing the error.
- In the Configure the Export window, under Destination, click the blue + button next to Google BigQuery.
- Sign in to (or select) the Google account associated with your BigQuery dataset.
- When Google’s permissions screen appears, grant both of the following permissions to Power My Analytics, then continue:
- Insert data into Google BigQuery
- View and manage your data in Google BigQuery and see the email address for your Google Account
Power My Analytics will never edit, create, or delete anything in your BigQuery destination dataset or Google account without your specific approval. Google does not provide a read-only option for these permissions.
- Once reconnected, select your Destination, finish configuring the export, and click Update (or Add). Your BigQuery export will now run with the correct permissions.
Related Articles
Error: Missing YouTube Analytics Scopes
When creating a report using your YouTube Analytics account in Power My Analytics, you may encounter an error message stating "Missing YouTube Analytics Scopes." This guide will help you understand the cause of this error and provide step-by-step ...Error: Missing Google Ads Scopes
When creating a report using your Google Ads account in Power My Analytics, you may encounter an error message stating "Missing Google Ads Scopes." This guide will help you understand the cause of this error and provide step-by-step instructions to ...Error: Missing Google Search Console Scopes
When creating a report using your Google Search Console account in Power My Analytics, you may encounter an error message stating "Missing Google Search Console Scopes." This guide will help you understand the cause of this error and provide ...Error: Missing Google Business Profile Scopes
When creating a report using your Google Business Profile account in Power My Analytics, you may encounter an error message stating "Missing Google Business Profile Scopes." This guide will help you understand the cause of this error and provide ...How to Export to BigQuery
Once you have a report ready in Data Builder, you are able to export it to BigQuery. This export option is available on the Custom plan if your negotiated agreement includes data exports. Follow the instructions in this article to get started. Grant ...