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
You can check the steps to get email and key:
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.
As I wrote, I have already created the JSON-file, so that is not the issue here. The issue is that it isn't clear what part of the file I should paste into the connector-field in Power BI desktop.
If you follow the steps, you should get information.
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.
Yes, as mentioned in both posts, I have the Json file. What do I do with the Json-file? There is no information regarding what I do with the 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).