Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

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


Super User
Super User

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

If needed go to datasource setting and enter Datasource credentials again

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

i have same problem , anyone help???

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors