Troubleshooting BigQuery

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 as well as information about their status, showing success or an error message. These error messages can help you to understand any issues occurring with your BigQuery exports.

To view logs for an export, start in your hub. Under Exports, select BigQuery.

The BigQuery section of the Power My Analytics hub, under Exports.

Find the row of your export and click View Logs.

A log of exports under a scheduled export in the Exports to BigQuery section of the PMA hub.

Each entry will display a message under Information and a timestamp under Logged At.

Troubleshooting BigQuery Errors

  1. BigQuery Export Limitations
  2. Could Not Handle the Request, Error Code 500 or 502
  3. Code 403; Message: Access Denied

    Still having issues?
    Send us a ticket and we will get back to you.
      • Related Articles

      • BigQuery Export Limitations

        Your data exports to BigQuery may encounter errors in certain situations such as large export sizes. This article will show you how to identify and correct errors with your BigQuery exports. Export Limitations If you are using connectors other than ...
      • Basic Troubleshooting

        Most errors can be solved easily and independently. This article will guide you through some basic troubleshooting steps to get your reports looking great as quickly as possible. Click "See Details" on the Error Description If your report was made ...
      • How to Export to BigQuery

        Once you have a report ready in Data Explorer, you are able to export it to BigQuery. This export option is included in the Enterprise plan. Follow the instructions in this article to get started. Grant Required Roles and Permissions A successful ...
      • 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 ...
      • 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 ...