Forum Discussion

Allegro's avatar
Allegro
Icon for Helper I rankHelper I
4 years ago

ODBC:ERROR [HY000] [Microsoft][BigQuery] (8701) Error interacting with REST API: Timeout was reached

Hi,

Im having an issue in Power BI Desktop i cant load or refresh data, i can still publish my report and refresh the dataset in the Power BI Service but i need to load new tables to work with, after a while of loading this error appear at random tables each time:

 

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

it occured to me i could use a dataflow to load the tables as a workaround but as of now June 22th 2022 the data flow is having an issue also, earlier this moth i had to disable my dataflows because my dataset kept getting stucked in refresh mode:

 

 

i found a similiar issue in the power bi formun but the issue was on the Power BI Service and mine is in the Power BI Desktop:

https://community.powerbi.com/t5/Service/Error-interacting-with-REST-API-Timeout-was-reached/m-p/1716609

 

i use a premium per user account and the size of my data model is not that big, i had worked with files 7 times larger,

i already tried to clear and re enter my data source credentials and tried different wifi spots and computers.

 

im sure the issue lies in my data source (Google Big Query)  but i couldnt found the rooth cause of the issue or a solution in the forums nor what i am supposed to look for in the Data source so i can contact my data source provider. i would apretiate it if you lend me a hand.

 

Thanks for your help!

Javier.

 

 

 

4 Replies