How to Resolve Google BigQuery Authentication Issue on disabled APIs
Google BigQuery is a powerful tool for data analysis. However, users may sometimes encounter a 403 forbidden issue. This is often due to the People API not being enabled.
In Bold BI BigQuery connector, data can be fetched by providing a client id and client secret. However, when using a client id and client secret from a People API account, it is necessary to enable the People API to provide permission. By default, the People API is in a disabled state.
Here are the steps to enable the API permission:
Step 1: Identify the Issue
Before enabling the API, an error message will be displayed in Bold BI. The link to enable the API can be found in the error message itself.
Step 2: Enable the People API
Click the link provided in the error message to enable your People API. The page will render as shown below.
Step 3: Reconnect the BigQuery Account in Bold BI
After enabling the API, you will need to reconnect the BigQuery account in Bold BI.
(i) Click the ‘Connect New Account’ option.
(ii) Add or select the respective account from the pop-up window.
(iii) Now, you should be able to connect your project in Bold BI.
By following these steps, you should be able to resolve the Google BigQuery authentication issue.
References
