Don't auth with auth2 to Bigquery

[silavmisli]

Hello

I can't authorize to BigQuery with Oauth2 for periodic replication.

Video YouTube with problem
https://youtu.be/7xaHGqw6V0Y

[silavmisli · Accepted solution]

Solution:

1. Create service account google cloud platform (GCP). I choose role "editor".
https://console.cloud.google.com/iam-admin/serviceaccounts
 
2. Go to service account and create key (json file)
a) In the Cloud Console, go to the Service Accounts page.
b) Go to Service accounts
c) Select a project.
d) Click the email address of the service account that you want to create a key for.
e) Click the Keys tab.
f) Click the Add key drop-down menu, then select Create new key.
h) Select JSON as the Key type and click Create.

3. From json-file delete symbol "enter" (#10#13)  - This is password.

4. In Power BI Service authentication method change to "basic" and  write email and password(json).

PS: Power BI Desktop have autorization about service account GCP too.

I take solution in telegram chat about Power BI.

[pyicarus]

I'm sorry, but for bullet #3 what do you mean by "from json-file delete symbol 'enter' (#10#13) - This is password"?

[v-angzheng-msft]

Hi, @silavmisli 

Here are some references that may be helpful:

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

https://docs.microsoft.com/en-us/power-query/connectors/googlebigquery

https://community.powerbi.com/t5/Service/Direct-Query-with-BigQuery-Authentication-error-on-PowerBI/...

https://community.powerbi.com/t5/Issues/Authentication-with-BigQuery-dataset-refresh-not-working/idi...

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.