Forum Discussion
Intermittent Refresh Failure - Google Big Query Source (HY000)
Hello JenAbe,
It sounds like you're encountering an error with the refresh process of your Power BI dataset connected to Google BigQuery. This error specifically mentions a failure to retrieve an error message related to the GHighThroughputApiError.
Here are a few steps you can try to troubleshoot and resolve the issue:
1. Check your Google BigQuery API quota: It is possible that your API quota is being exceeded, which is causing the error.
You can check the API quota in the Google Cloud Console and request an increase if needed.
2. Verify the credentials: Make sure that your Power BI account has the necessary permissions to access the Google BigQuery data source. You can also try creating a new connection to the source and verifying the credentials.
3. Try a manual refresh: Manually refresh the data in Power BI Desktop and check if it resolves the error. If it does, you can schedule a manual refresh in the Power BI service.
4. Restart the Power BI service: Try restarting the Power BI service to see if that resolves the issue.
These steps should help you troubleshoot and resolve the issue you're facing with the Google BigQuery data source in Power BI.
Let me know if you might need further guidance.