I can't connect BigQuery to Power BI using service account login

[kasidech-chu]

Hi All,

I just have a problem on getting Power BI connected with BigQuery using Service Account Login.

I have followed https://learn.microsoft.com/en-us/power-query/connectors/google-bigquery on "

• Service Account Email: must be in email format
• Service Account JSON key file contents: once this JSON key is downloaded, all new lines must be removed from the file so that the contents are in one line. Once the JSON file is in that format, the contents can be pasted into this field.". 

Somehow, it keep told me as "We couldn't authenticate with the credentials provided. Please try again.". I also validate my service account that it is able to list BigQuery table normally.

Is there any solution on this issue? It would be great to have some advice on this.

Thank you.

Best Regards,

K

[MattKnutson]

Man I banged my head on this problem for days. ChatGPT got me part of the way but this thread helped me wrap it up. 

You have to do two things. You have to convert the json you download from Big Query into a single line as suggested in this article. That was what I was not doing yet. Then you have to remove all of the indenting space and remove the \n line break indicators in the private key. 

I used Notepadd++ to do that stuff. Once I did that it finally took the darn thing! Hope that helps! 

[Zaifox]

Try to get a new JSON file.

[bhupesh-gemba]

Have you found any solution for this?

I am getting the similar error when trying to Import Data from Google BQ in Power Apps