Forum Discussion
Solved
Google BigQuery - Service Account JSON file contents - what do I enter from the JSON file?
Hey guys. I am trying to connect to Google Bigquery using a Service Account instead of a personal account. I have created the JSON file on the following format: Here are some ...
Hi rubentj - did you ever resolve this? I notice the MS response did not answer your question.
The resolution is to update to the most recent Power BI version (June 2021) and edit the JSON file to have no carriage or line feeds returns (source: Solved: connect big query with service account - Microsoft Power BI Community).
Hi, rubentj
Sorry, It seems that few people know the knowledge, and we can't reproduce your scene. If you don't understand it, it is not recommended that you use this method.
Here are the steps for reference:
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Pretty sure the issue isn't getting the key, it's what to put into Power bi.