BigQuery Error: Code 403; Message: Access Denied
This article will assist you with the following errors:
Code: 403; Message: Access Denied: BigQuery BigQuery: Streaming insert is not allowed in the free tier (accessDenied)
Code: 403; Message: Access Denied: Dataset: Permission denied on dataset (or it may not exist).(accessDenied)
Cause
Streaming insert is not allowed in the free tier
You are currently using BigQuery's free tier. The free tier does not allow PMA exports to BigQuery.
Permission denied on dataset (or it may not exist)
The Google account you are using does not have write access to BigQuery.
Solution
Upgrade your BigQuery plan
If the error was due to using BigQuery's free tier, you'll need to upgrade your plan in order to enable exports from PMA. We use streaming inserts to export data to BigQuery, and Google currently prices streaming inserts to BigQuery at $0.01 USD per 200MB. For more details, please see Google's BigQuery data ingestion pricing.
Enable write access to BigQuery
If the error is due to permission being denied for the dataset, make sure to enable write access to BigQuery on the Google account you're using when selecting a BigQuery destination. Your BigQuery admin can check your Google account and grant write permissions to BigQuery.
Still having issues?
Send us a ticket and we will get back to you.
Related Articles
Troubleshooting BigQuery
When troubleshooting BigQuery, you may need to view your BigQuery export logs. This article will show you how to check the logs and see details about any errors. Viewing Export Logs Your BigQuery export logs show a timestamped record of your exports ...BigQuery Error: Could Not Handle the Request, Error Code 500 or 502
This article will assist you with the following errors: Error: could not handle the request (500), Error: could not handle the request (502) Cause These errors can occur when your export is larger than BigQuery's limits. This will cause your export ...Unauthorized Access Error When Connecting to Shopify
This article will assist with the following error: Cause Many Shopify accounts have more than one URL that redirects to the store. Only the "myshopify.com" URL can be used to fetch data. You may have entered the wrong Shopify URL during the ...Error: Missing BigQuery Scopes
This article will address the following error: Missing BigQuery Scopes Cause You may receive this error when connecting to a BigQuery account. It is a result of insufficient permissions granted to Power My Analytics. Solution Step 1: Disconnect ...Error Connecting to Instagram Media Insights
Instagram requires specific permissions to be enabled in Facebook. This article will show you what you need to know to get your Instagram account connected. This article will assist you with the following error: Causes and Solutions Incompatible ...