Skip to main content

    Power BI

    Completed

    Refresh BigQuery data sources using a service account

    Vote (64) 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.

    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)
    Tom Urwin's profile image Profile Picture

    Max B on 26 Jun 2021 09:42:58

    RE: Refresh BigQuery data sources using a service account

    This is now available. Small trick: when setting up "Service Account Login" for GoogleBigQuery in Power BI there is a parameter "Service Account JSON key file contents". You shall paste the full contents of a service account *.json file formatted in 1 line (line breaks would not be understood)

    Tom Urwin's profile image Profile Picture

    Zhantao Fang on 15 Mar 2021 11:48:37

    RE: Refresh BigQuery data sources using a service account

    This is very much needed. Connecting to Big Query using a user account is not as secure as a service account and very difficult to manage.

    Tom Urwin's profile image Profile Picture

    Oscar Bocking on 15 Mar 2021 11:33:51

    RE: Refresh BigQuery data sources using a service account

    This would be great for security reasons too.

    Tom Urwin's profile image Profile Picture

    Michael Burns on 05 Oct 2020 19:25:40

    RE: Refresh BigQuery data sources using a service account

    Any recent updates on this issue? or possible workarounds in the meantime?
    This seems like an important auth option that is missing for the GCP BigQuery connection.

    Tom Urwin's profile image Profile Picture

    Power BI User 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

    Nicolas 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

    Arend 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

    Doug 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

    Gaurav Tiwari 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

    Miguel Munoz 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.