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 ...Error: Missing BigQuery Scopes
When setting up BigQuery exports in Power My Analytics, you may encounter an error message stating "Missing BigQuery Scopes." This guide will help you understand the cause of this error and provide step-by-step instructions to resolve it. Error ...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 Connecting to Instagram Media Insights
You may encounter the error "This Instagram account is not connected to a Facebook page" when attempting to connect your Instagram Insights account to Power My Analytics for data reporting. This guide addresses the common error and provides ...