Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 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!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
38 | |
25 | |
23 | |
21 | |
21 |
User | Count |
---|---|
56 | |
31 | |
23 | |
22 | |
20 |