BigQuery Error: Billing Has Not Been Enabled for This Project

BigQuery Error: Billing Has Not Been Enabled for This Project

This article explains how to resolve a BigQuery billing error that can occur when attempting to run your data exports.

Error



When attempting to run a BigQuery export of your Power My Analytics report, you may see the following error in the View Logs panel:

"Billing has not been enabled for this project. Enable billing at https://console.cloud.google.com/billing"

Causes

Data imports into BigQuery require a paid plan with active billing enabled. Free BigQuery plans do not support the data import functionality needed for Power My Analytics exports.

This error typically occurs when:

  • You're using a free BigQuery version. Data imports into BigQuery, such as those provided by PMA's export feature, are not supported by BigQuery's free plan.
  • You're using a paid version of BigQuery that does not currently support the required data imports.

Solution

Enable billing for your BigQuery project. This requires your project to be linked to a valid, active Cloud Billing account.

  1. Follow Google Cloud's support instructions to identify the Cloud Billing account linked to your BigQuery project.
  2. If there is no Cloud Billing account linked to your project, this page will read "This project has no billing account".
  3. To enable billing on your BigQuery project, follow the Google Cloud support instructions to enable billing for an existing project.
Once your BigQuery project is linked to a Cloud Billing account and billing is enabled, it may take up to 24 hours to become active. Please wait 24 hours after activating billing in your project before running your BigQuery export in PMA.
Next, run your export again and verify that it ran successfully:
  1. Return to the Exports > BigQuery section of your PMA hub. Find your export and click the Run Export Now button.
  2. Open the View Logs panel for the export. The logs should show that the export ran successfully.

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

      • 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: 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 ...

      • 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 ...

      • How to Use the Exports Add-On

        Power My Analytics offers the option to export data from your reports into destinations like BigQuery, MySQL, Azure SQL Database, PostgreSQL, and FTP. With our easy-to-use Exports Add-On, you can set up a report in PMA's Data Explorer and schedule ...

      • 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 ...