Forum Discussion

catleen's avatar
catleen
Frequent Visitor
5 years ago

Connect to BigQuery using service account

Hi! 

According to June 2021 update it should now be possible to connect to BigQuery using a service account. https://powerbi.microsoft.com/en-us/blog/power-bi-june-2021-feature-summary/#post-16112-_Toc74044973

Can anyone instruct me how to do it? I have the JSON from Google, but I am struggling to understand what should be the password during the authentication, since the private key is too long.

Thanks!

Need Help

2 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, catleen ;

    Step 1. Generating service account keys

    1. On the Service accounts page (IAM & Admin | Service accounts), click the configuration icon in the Actions column and select Manage keys.

       
       

    2. Click the Add key list and select Create new key.

    3. In the Create private key dialog, select JSON and click Create.

      The private key download is started automatically.

      https://www.jetbrains.com/help/datagrip/connect-to-bigquery.html#connecting-to-bigquery-with-a-google-service-account

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi v-yalanwu-msft 

     

    Any idea when the use of Service Accounts will be supported in the Power BI Service, i.e. for Dataflows?

     

    Thanks

     

    Mark