Skip to main content
Microsoft Idea

Power BI

Needs Votes

Connect to BigQuery via proxy

Vote (13) Share
Chris Ward's profile image

Chris Ward on 31 Oct 2018 19:31:32

The BigQuery connector within Power BI Desktop should use a proxy server to connect to BigQuery if the host machine it is running upon has a proxy server configured for Internet connections.

At present, the connector ignores the proxy setting and attempts to connect directly.

Comments (4)
Chris Ward's profile image Profile Picture

L P on 25 Apr 2022 15:16:17

RE: Connect to BigQuery via proxy

@Sandor can you give more details regarding your workaround. I’ve tried to declare the following env variables with no sucess (http_proxy and https_proxy with proxy.myorg.net:8080).

Chris Ward's profile image Profile Picture

L P on 25 Apr 2022 15:13:29

RE: Connect to BigQuery via proxy

Same as https://ideas.powerbi.com/ideas/idea/?ideaid=9fd29de4-645d-439b-9a50-ffebe04efed2

Chris Ward's profile image Profile Picture

Sandor SZALMA on 18 Jan 2022 09:34:22

RE: Connect to BigQuery via proxy

there is a workaround for the proxy (define environment variable https_proxy=your_proxy & remove TLS-interception from the Google BigQuery apis) but it is still required to be able to define parameters for the embedded Simba ODBC driver.


I have found some documentation with other drivers (not from MS) and I have tried to implement them for Google BigQuery driver but it was not successful.


This file comes with MS Power BI Desktop:

C:\Program Files\Microsoft Power BI Desktop\bin\ODBC Drivers\Simba Google BigQuery ODBC Driver.ini


I have defined some parameters in this file:

%LOCALAPPDATA%\Power BI Desktop\microsoft.googlebigqueryodbc.ini


It would be very useful to be able to work without so many workarounds and to be able to have access to all parameters of the Simba ODBC driver.


Chris Ward's profile image Profile Picture

Sandor SZALMA on 29 Jan 2021 15:15:22

RE: Connect to BigQuery via proxy

The BigQuery connector should provide a way to pass parameters to the Simba ODBC driver.

https://www.simba.com/products/BigQuery/doc/ODBC_InstallGuide/win/content/frontandbackmatter/simba/about.htm

We need especially these ones:
ProxyHost;
ProxyPort;
ProxyUid;
ProxyPwd;
TrustedCerts;