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 app.powerbi.com.
Does anyone actually have a working solution for a PowerBI app connecting to Big Query using a service account?
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: https://www.simba.com/products/BigQuery/doc/v2/ODBC_InstallGuide/win/content/odbc/bq/strings.htm
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.
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!
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.
Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!