Error connecting to Google BigQuery

[alndellazari]

I'm connecting Power BI with Google BigQuery through using the DirectQuery option and I'm often getting the error below:

Feedback Type:
Frown (Error)

Timestamp:
2018-10-11T23:02:20.4099852Z

Local Time:
2018-10-12T10:02:20.4099852+11:00

Release:
September 2018

Product Version:
2.62.5222.761 (18.09) (x64)

Error Message:
OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Couldn't connect to server
ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Couldn't connect to server.

OS Version:
Microsoft Windows NT 10.0.16299.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 461308]

Workbook Package Info:
1* - en-AU, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
DirectQuery

section Section1;

shared AggrCosts = let
Source = GoogleBigQuery.Database([BillingProject="billing_project_id"]),
#"billing_project_id" = Source{[Name="billing_project_id"]}[Data],
CTS_Test_Schema = #"billing_project_id"{[Name="CTS_Test",Kind="Schema"]}[Data],
AggrCosts_Table = CTS_Test_Schema{[Name="AggrCosts",Kind="Table"]}[Data]
in
AggrCosts_Table;

Any ideas on solving this issue?

[v-qiuyu-msft]

Hi @alndellazari,

Please change the connect mode to Import to see if the same issue occurs. From the error message, it looks like the issue is related to BigQuery rest API. I would suggest you test the BigQuery rest API to ensure it's working fine on BigQuery side: https://cloud.google.com/bigquery/support

Best Regards,
Qiuyun Yu 

[alndellazari]

Hi @v-qiuyu-msft,

I do need it as a DirectQuery, but I'll try your suggestion to check if the error persists.

Thanks for your reply!

Regards,

Allison

[v-qiuyu-msft]

Hi @alndellazari,

As I can't reproduce the issue on my side, if only DirectQuery has this issue on your side. I would suggest you create a support ticket to get dedicated support. 

Best Regards,
Qiuyun Yu