Forum Discussion
Data gateway Connection to Big Query
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
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)
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)
4 Replies
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)
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!
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)
