Tom Urwin on 31 Jul 2018 19:37:04
Traditionally with ODBC connections, we are able to use a service account and key on the gateway server. This allows refreshes in the cloud without using a personal account. Our user accounts in BigQuery authenticate via a third party IdP where MFA and IP restrictions are in place.
When setting up data source credentials for a BigQuery dataset, it only shows an OAUTH2 option which then takes us to a Google username/password logon.
We need to be able set up a data source using a service account and key instead.
Administrator on 29 Jun 2021 22:05:31
This was released: Power BI June 2021 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI
- Comments (13)
RE: Refresh BigQuery data sources using a service account
its always better to use a service account to gain a better control
RE: Refresh BigQuery data sources using a service account
This would be a great feature to add. Right now we have to publish a data set from a user instead of a service account. We need the ability for Direct Query and Import to BigQuery data sets to be published and refreshed with a Google Cloud Service Account. We need this on Power BI Service and Desktop.
RE: Refresh BigQuery data sources using a service account
Same here, looking for a solution.
Even thou in Simba ODBC driver we configured with Service and a P12 file (we would prefer a json also) when configuring the gateway, it requires user/password.