Forum Discussion

silavmisli's avatar
silavmisli
Regular Visitor
5 years ago
Solved

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
  • silavmisli's avatar
    5 years ago

    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.