DataSource.Error: ODBC: ERROR [HY000] [Microsoft][BigQuery] (8701) Error interacting with REST API:

[georgedavis]

Hi, each morning I manually refresh my file (I know probably not the best way to do it) but it works fine until this morning when I received this error:

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][BigQuery] (8701) Error interacting with REST API: Timeout was reached ERROR [HY000] [Microsoft][BigQuery] (8701) Error interacting with REST API: Timeout was reached Details: DataSourceKind=GoogleBigQuery DataSourcePath=GoogleBigQuery OdbcErrors=[Table]

Can anyone please explain what this issue is? And how it can be resolved so my report can be updated?

Thanks, George

[amitchandak]

@georgedavis , Seem like source was not reachable at that time. Try again manually.

If needed go to datasource setting and enter Datasource credentials again

[georgedavis]

@amitchandak I have tried all these options but it doesn't work and I am unable to update my file again this morning. I am not sure why source isn't reachable, it pulls from Google Big Query and I have no issues connecting to it. Do you know how else I could fix? Please note I can connect and refresh some tables from Big Query but it seems to fail when refreshing the largest table.

[CTITTEAM]

i have same problem , anyone help???