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).
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).
You may have already found the solution, but here is my 2 cents.
Use the client email, and for the 2nd cell, you first need to take the entire content of your JSON file (curly brackets included)
and convert them into a single line.
You can use the following online tool to convert the JSON code:
https://tools.knowledgewalls.com/online-multiline-to-single-line-converter