Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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.

Anonymous
Not applicable

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.