Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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 "
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
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!
Try to get a new JSON file.
Have you found any solution for this?
I am getting the similar error when trying to Import Data from Google BQ in Power Apps
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 27 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 73 | |
| 66 | |
| 65 |