Forum Discussion
Google BigQuery - Service Account JSON file contents - what do I enter from the JSON file?
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).
This worked for me:
So basically I dont remove anything from the file, I open it in a texteditor and then I minify it.
-Go to your service account in Bigquery and grab the email for the service account you want to add to Power BI
-Download the key in JSON format.
-Open the file in a texteditor, copy the whole thing inc. curly brackets. Dont remove anything!
-paste it into https://jsonformatter.org/json-minify since the contents need to be in one line
-copy the result and paste into the correct input field.
hope it works for you!