Issue with PowerBI Bigquery EntraID connector.

[Anonymous]

Hi all,

I am working on a client use-case where we want to utilize the "Bigquery(EntraID) connector". Now to get the enable there are following requirements:

* Having gcp project with billing enabled.

* Workforce Identity Federation(GCP) should be working.

The above requirements are covered and we are able to sign-in to gcp using our Azure credentials. But, when we try to configure the PowerBI connector using the Provider-ID (From gcp), the connection is refused.

Since we are not getting any error details, I am clueless on this.

Please let us know if anyone else has faced similar issue or have any solution.

[Anonymous]

Hi @Anonymous 

Access denials are generally caused by insufficient credential permissions provided, here are some steps you can take:

1. Ensure that the service account in GCP has the necessary permissions to access BigQuery. The service account should also have the BigQuery User role or an equivalent custom role with the required permissions.

2. Double-check the Provider ID (which is usually the client ID of the workload identity pool provider) that you are using in Power BI. It should be correct and match the one set up in your GCP Workload Identity Pool. Confirm that the Workforce Identity Federation is correctly set up between Azure AD and GCP. Ensure that the identity provider (Azure AD) is correctly mapped to the GCP Workload Identity Pool and Provider.

3. Make sure that the authentication method is set to "Workload Identity Federation" in the Power BI connector configuration. Verify that the service account in GCP is linked to the Azure AD identity that is being used to sign in to Power BI.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.