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?
3 Comments
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 YuHi 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
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
