The credentials provided for the GoogleBigQuery source are invalid

Hi JWT 

The issue you're experiencing with Google BigQuery (GBQ) credentials in Power BI, where you receive the error "The credentials provided for the GoogleBigQuery source are invalid," typically points to an authentication or token expiration issue. This problem arises when the credentials used by Power BI for scheduled refreshes become invalid, often due to expired tokens or insufficient permissions. Since you're using a Google BigQuery service account, it’s important to verify that the service account has the appropriate permissions in Google Cloud, specifically the BigQuery Data Viewer and BigQuery Job User roles for the dataset and project you're accessing. If permissions are not set correctly, the credentials might work during manual refresh but fail during the automated refresh. In addition to this, service account credentials, especially if you're using a JSON key file, can expire or be rotated, causing issues with authentication in Power BI. You should check that the key file is valid and hasn't expired, or if you're using OAuth 2.0 credentials, ensure that they haven’t expired or been invalidated. To address the issue, start by re-entering the credentials directly in the Power BI Service by going to the dataset settings and ensuring the credentials are properly configured. You may also want to clear the stored credentials in Power BI Desktop and reauthenticate before republishing the report. Clearing the credentials and reconnecting the service account can sometimes resolve caching issues in the Power BI Service. Additionally, checking the scheduled refresh history in the Power BI Service can provide more details about the specific error during the refresh process, helping you identify whether the issue is with the credentials or the connection itself. If the credentials keep failing, consider testing with DirectQuery mode instead of Import Mode, as it may help avoid issues with expired data refresh tokens by querying data in real-time instead of caching it. Ultimately, ensuring correct permissions, up-to-date credentials, and refreshing token management practices will help resolve the recurring issue with scheduled refreshes in Power BI.