Forum Discussion

georgedavis's avatar
georgedavis
Regular Visitor
4 years ago

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

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

 

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      georgedavis
      Regular Visitor
      4 years ago

      @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.