Skip to main content

    Power BI

    New

    Refresh BigQuery data sources using a service account

    Vote (56) Share
    Tom Urwin's profile image

    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.

    Comments (9)
    Tom Urwin's profile image Profile Picture

    505977d9 5f6e-4533-8d81-d633a8ccecc5 on 06 Jul 2020 00:10:37

    RE: Refresh BigQuery data sources using a service account

    is there any workaround for this?

    Tom Urwin's profile image Profile Picture

    2b413f6a 3b9f-47f2-9144-70e199b3a11e on 06 Jul 2020 00:09:12

    RE: Refresh BigQuery data sources using a service account

    Totally agree

    Tom Urwin's profile image Profile Picture

    9e9f9793 f7b5-424b-9f36-a9f123700d7d on 06 Jul 2020 00:05:15

    RE: Refresh BigQuery data sources using a service account

    I agree!
    Will now explore the option to write BigQuery results to a Google (my)SQL table and fetch those from Power BI using ODBC credentials...

    Tom Urwin's profile image Profile Picture

    77a55d08 b161-482b-ab77-f2e3e7419e8e on 06 Jul 2020 00:02:22

    RE: Refresh BigQuery data sources using a service account

    Totally agree, using my user account makes no sense.

    Tom Urwin's profile image Profile Picture

    004ec2c3 d018-487d-bbb1-6e2ebd7c584d on 05 Jul 2020 23:49:01

    RE: Refresh BigQuery data sources using a service account

    I see this as a major shortfall of PowerBI. Service accounts are always better to handle access.

    Tom Urwin's profile image Profile Picture

    c8f3a129 ff7a-4b4e-92b3-61109b562dfb on 05 Jul 2020 23:48:59

    RE: Refresh BigQuery data sources using a service account

    This could be a step chance in adopting PowerBi across our corporation, but time is of essence.

    Tom Urwin's profile image Profile Picture

    2d135b22 66d9-404e-a037-5af7388625ea on 05 Jul 2020 23:48:59

    RE: Refresh BigQuery data sources using a service account

    its always better to use a service account to gain a better control

    Tom Urwin's profile image Profile Picture

    e8c7fb19 9c60-4053-8cca-c1630cb4e1b5 on 05 Jul 2020 23:48:56

    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.

    Tom Urwin's profile image Profile Picture

    c132cb96 9c16-408f-b752-456e984f7bda on 05 Jul 2020 23:27:19

    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.