Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Did anyone connect Power BI to BigQuery using a service account? (with refresh of data working?)

Hi everyone.


I have a working Power BI app in desktop that uses the simba ODBC driver to authenticate against BigQuery using a service account.


It does not work in


Does anyone actually have a working solution for a PowerBI app connecting to Big Query using a service account?



Frequent Visitor

Hi Alex, 


I am able to (Up until yesterday anyway -- weird new issues today) 


When you set up the ODBC connector you gotta use a connection string . See here:


Let me know if this helps

Hi @janinebp ! 


You give me hope! Would you mind sharing your setup for this? Do you use the gateway --> and how does your connection-string look like?


Hey! Yes I use a (personal) data gateway. My connnection string looks like this



And then set up the ODBC data source as usual



hope this helps!

I think the problem might be the personal data gateway. I'm using the non-personal gateway, and here it does not work. Might be because I don't have the Authentication method called "WindowsWithoutImpersonation". I also had a rather long support case with Microsoft, where they gave up on making it work 🤔


😞 That sucks. I guess I am going to run into your issue eventually... I'll have a look at the normal gateway and will let you know if I find any workaround.

Hi @alexbjorlig 

In case you're not aware (I just recently found out, the official BigQuery connector now allows for Service Account authentication also. This might help you!

Good luck!


I will give it a spin - thanks for keeping the post updated 🙂 

Super User
Super User

Hi @alexbjorlig ,


Were you able to make sure that the setup was as designed in this article Connect to a Google BigQuery database in Power BI Desktop - Power BI | Microsoft Docs ?  The article states that this works in Desktop and Service.

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.

The linked article is only about user authentication, and not service accounts.

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!