Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello
I can't authorize to BigQuery with Oauth2 for periodic replication.
Video YouTube with problem
https://youtu.be/7xaHGqw6V0Y
Solved! Go to 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.
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"?
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
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
48 | |
28 | |
20 | |
20 | |
19 |
User | Count |
---|---|
51 | |
51 | |
26 | |
25 | |
20 |