Quota exceeded: Your project exceeded quota for free query bytes scanned.

[quanple]

Hi everyone, 

We are having an issue when refresh in Power BI service. The refresh works in desktop, but fails in service. The detail error: 

ODBC: ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Quota exceeded: Your project exceeded quota for free query bytes scanned. For more information, see https://cloud.google.com/bigquery/troubleshooting-errors

How can we fix it? 

Thanks!

[v-easonf-msft · Accepted solution]

Hi, @quanple 

As mentioned by the error messege,for more information, see https://cloud.google.com/bigquery/troubleshooting-errors

This looks more like a problem caused by google bigquery quotas and limits. 

Please check the the free usage tier limits.

It is suggested to enable billing for your account so that you can access more storage.

Best Regards,
Community Support Team _ Eason

[abhisheknairr]

@quanple 
@v-easonf-msft 

Hi, didnt understand the statement "Source = GoogleBigQuery.Database([BillingProject="projectname", UseStorageApi=false])"

How do i do this?

[quanple]

Processing error: ODBC: ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Quota exceeded: Your project exceeded quota for free query bytes scanned. For more information, see https://cloud.google.com/bigquery/troubleshooting-errors
Cluster URI: WABI-SOUTH-EAST-ASIA-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 21ad96b0-e49c-47da-b715-7444d2f5c821
Request ID: 7c30f314-92d5-1e0c-f1e7-08e23a443582
Time: 2021-03-09 01:59:59Z

[v-easonf-msft · Accepted solution]

Hi, @quanple 

As mentioned by the error messege,for more information, see https://cloud.google.com/bigquery/troubleshooting-errors

This looks more like a problem caused by google bigquery quotas and limits. 

Please check the the free usage tier limits.

It is suggested to enable billing for your account so that you can access more storage.

Best Regards,
Community Support Team _ Eason

[quanple · Accepted solution]

Thanks,

We resolved this issue by using billing in source. 

Source = GoogleBigQuery.Database([BillingProject="projectname", UseStorageApi=false])