cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
silavmisli
Regular Visitor

Don't auth with auth2 to Bigquery

Hello

 

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

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

1 ACCEPTED SOLUTION
silavmisli
Regular Visitor

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.

View solution in original post

3 REPLIES 3
silavmisli
Regular Visitor

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.

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
Community Support
Community Support

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Top Solution Authors
Top Kudoed Authors