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)
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).
RE: Connect to BigQuery via proxy
Same as https://ideas.powerbi.com/ideas/idea/?ideaid=9fd29de4-645d-439b-9a50-ffebe04efed2
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.iniI have defined some parameters in this file:%LOCALAPPDATA%\Power BI Desktop\microsoft.googlebigqueryodbc.iniIt 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.
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;