Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
Thanks,
We resolved this issue by using billing in source.
Source = GoogleBigQuery.Database([BillingProject="projectname", UseStorageApi=false])
@quanple
@v-easonf-msft
Hi, didnt understand the statement "Source = GoogleBigQuery.Database([BillingProject="projectname", UseStorageApi=false])"
How do i do this?
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
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
Thanks,
We resolved this issue by using billing in source.
Source = GoogleBigQuery.Database([BillingProject="projectname", UseStorageApi=false])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.