Forum Discussion
Passthrough Authentication for Google BigQuery?
Hi Anonymous ,
There're some tips in this document for your reference:
When authenticating through a Google service account in Power BI Desktop, there's a specific credential format that's required by the connector.
- Service Account Email: must be in email format
- Service Account JSON key file contents: once this JSON key is downloaded, all new lines must be removed from the file so that the contents are in one line. Once the JSON file is in that format, the contents can be pasted into this field.
When authenticating through a Google service account in Power BI service, users need to use "Basic" authentication. The Username field maps to the Service Account Email field above, and the Password field maps to the Service Account JSON key file contents field above. The format requirements for each credential remain the same in both Power BI Desktop and Power BI service.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-yanjiang-msft ,
thank you for your reply. We are using the Service Account with a key file for now, but this workaround doens't scale in our case.
This is fine for our first report which consumes data from one Google Project, but as the data is distributed accross serval Projects operated by different teams, we now have to create service accounts for each project and this results in many manual (afaik, as I don't see options for Workload Identity Federation) Key Rotations in the gateway in future.
We also have to implement additional secruity measures in power BI as our Policies in Google are bypassed.
I will update this thread when we found a suitable solution for our architecture