Forum Discussion
Failed Refresh
Hi All,
I'm using the Power BI online service for some years now and it always worked fine. I have a BigQuery connection, and this is where the data is coming from. The scheduled refresh always worked fine, but now I get this error:
Offertes&OHW has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.
<ccon>DataSource.Error: ODBC: ERROR [HY000] [Microsoft][BigQuery] (115) Operation timeout. Error happened in ExecuteRetriable. Error Code:403. Error Message:Quota exceeded: Your project exceeded quota for free query bytes scanned. For more information, see LINK . Microsoft.Data.Mashup.ErrorCode = 10478. DataSourceKind = GoogleBigQuery. DataSourcePath = GoogleBigQuery. OdbcErrors = #table({"SQLState", "NativeError", "Message"}, {}). </ccon>. The exception was raised by the IDbCommand interface. Table: pipedrive_cross_sel.
Next refresh for Offertes&OHW is scheduled for March 25, 2025 13:30 UTC.
Seems to mee that i exceed my qouta but i have unlimited qouta in Big Query so i dont know how to fix it. Does someone know this problem
Hi StefcoAE,
Thank you for reaching out to the Microsoft Fabric Forum Community.
It appears you're facing a quota-related issue with your BigQuery connection in Power BI. Despite having an unlimited quota, Google Cloud may still impose certain limits.Thank you, Akash_Varuna for sharing your insights.
This discussion might be useful as it deals with a similar problem:
Solved: Re: Quota exceeded: Your project exceeded quota fo... - Microsoft Fabric Community
Error messages | BigQuery | Google Cloud
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi StefcoAE
The error message indicates that your Power BI scheduled refresh is failing due to a quota exceeded issue in BigQuery, specifically related to free query bytes scanned. Even though you have an unlimited quota, Google Cloud imposes certain limits on query usage depending on your billing settings and project configuration. The issue may arise due to one of the following reasons:
-
Billing Project Settings: If your Power BI connection is using a Google Cloud project that does not have billing enabled, it might be defaulting to the free tier, which has limits on the amount of data scanned per month.
-
BigQuery API Limits: There are API quotas that limit the number of queries per minute/hour, even if you have a paid plan. If your dataset is large and multiple refreshes are happening within a short timeframe, you might be hitting these limits.
-
Permissions and Service Account Issues: If your Power BI service account does not have the necessary permissions to bypass quota restrictions, it may still encounter these errors despite an unlimited quota.
-
Concurrency Issues: If multiple queries are being executed at the same time, BigQuery might restrict usage under certain policies, causing an operation timeout.
-
Power BI Query Optimizations: If your Power BI queries are inefficient (e.g., scanning large tables instead of using partitioning or filtering), they may consume excessive resources, triggering quota limits.
Possible Fixes:
-
Check Your Billing Account: Go to the Google Cloud Console → Billing and ensure the correct project has billing enabled.
-
Verify Query Optimization: Use partitioning and clustering in BigQuery to reduce scanned data size.
-
Increase API Quotas: Navigate to Google Cloud Console → IAM & Admin → Quotas, search for BigQuery quotas, and request an increase.
-
Check Service Account Permissions: Ensure that the Power BI service account has the required permissions.
-
Test Refresh with Smaller Datasets: Try reducing the scope of the query in Power BI and check if a smaller dataset refreshes successfully.
If the issue persists despite these fixes, you may need to contact Google Cloud Support to check if there are specific restrictions on your account.
-
6 Replies
Hi StefcoAE Since you have unlimited quata in big query try to increase the query timeout in power bi and if in DirectQuery you could switch to impoert mode and schedule some refreshes to avoid the timeout i guess
Hi StefcoAE,
Thank you for reaching out to the Microsoft Fabric Forum Community.
It appears you're facing a quota-related issue with your BigQuery connection in Power BI. Despite having an unlimited quota, Google Cloud may still impose certain limits.Thank you, Akash_Varuna for sharing your insights.
This discussion might be useful as it deals with a similar problem:
Solved: Re: Quota exceeded: Your project exceeded quota fo... - Microsoft Fabric Community
Error messages | BigQuery | Google Cloud
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi StefcoAE,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi StefcoAE,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi StefcoAE
The error message indicates that your Power BI scheduled refresh is failing due to a quota exceeded issue in BigQuery, specifically related to free query bytes scanned. Even though you have an unlimited quota, Google Cloud imposes certain limits on query usage depending on your billing settings and project configuration. The issue may arise due to one of the following reasons:
-
Billing Project Settings: If your Power BI connection is using a Google Cloud project that does not have billing enabled, it might be defaulting to the free tier, which has limits on the amount of data scanned per month.
-
BigQuery API Limits: There are API quotas that limit the number of queries per minute/hour, even if you have a paid plan. If your dataset is large and multiple refreshes are happening within a short timeframe, you might be hitting these limits.
-
Permissions and Service Account Issues: If your Power BI service account does not have the necessary permissions to bypass quota restrictions, it may still encounter these errors despite an unlimited quota.
-
Concurrency Issues: If multiple queries are being executed at the same time, BigQuery might restrict usage under certain policies, causing an operation timeout.
-
Power BI Query Optimizations: If your Power BI queries are inefficient (e.g., scanning large tables instead of using partitioning or filtering), they may consume excessive resources, triggering quota limits.
Possible Fixes:
-
Check Your Billing Account: Go to the Google Cloud Console → Billing and ensure the correct project has billing enabled.
-
Verify Query Optimization: Use partitioning and clustering in BigQuery to reduce scanned data size.
-
Increase API Quotas: Navigate to Google Cloud Console → IAM & Admin → Quotas, search for BigQuery quotas, and request an increase.
-
Check Service Account Permissions: Ensure that the Power BI service account has the required permissions.
-
Test Refresh with Smaller Datasets: Try reducing the scope of the query in Power BI and check if a smaller dataset refreshes successfully.
If the issue persists despite these fixes, you may need to contact Google Cloud Support to check if there are specific restrictions on your account.
-
Hi StefcoAE,
We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.
Thank you.
