Data gateway Connection to Big Query

[zausten]

Hi 

Trying to create a connection in Data Gaeway to Big Query . In desktop this is straightfoward using a service account.  however on Data Gateway, there are no options to add service account key contents.  This link suggests to use Cloud to Cloud, but do not know what this connection type is.  Edit connections gives no option to add key file.

thanks!

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-bigquery

[collinq · Accepted solution]

Hi @zausten ,

I believe that Google Big Query turned off the ability to use Oauth.  I can't find any documentation on it at the moment but I think you have to use a Google Service Account.  I did find this though:

A Complete Guide for Google BigQuery Authentication Tutorial (progress.com)

[collinq · Accepted solution]

Hi @zausten ,

I believe that Google Big Query turned off the ability to use Oauth.  I can't find any documentation on it at the moment but I think you have to use a Google Service Account.  I did find this though:

A Complete Guide for Google BigQuery Authentication Tutorial (progress.com)

[zausten]

HI @collinq 

Thanks for reply.

Re Oauth - this is still available and I can configure data gateway connection using this.  However I wouldnt want to set up a production data gateway using a personnel account.

We have created a service account and can connect using this service account via PBI desktop and using key.  The issue is there doesn't seem to be an option on Data Gateway to use the service account though.   As per link I shared they suggest to use a Cloud to Cloud Connector.  however I dont know what this is, any thoughts?

thanks!

[collinq · Accepted solution]

Hi @zausten ,

here is a similar thread whre the step are outlined by @silavmisli :

Solved: Re: Don't auth with auth2 to Bigquery - Microsoft Power BI Community

If that doesn't help, take a look at this: Creating and managing service account keys  |  Cloud IAM Documentation (google.com) 

[zausten]

thanks @collinq 

As simple as that.  It's now connected using SA and key file contents

thanks again!