Bigquery Data Refresh fail due to Rest API Interaction Error

[Anonymous]

Hi All,

Since yesterday, we are facing refresh issues in many of our PowerBI dashboards (from Google Bigquery).

Following is the error:

Processing errorODBC: ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Not found: Job bnb-merchant:job_URKbOfdE8vPSRBDPwm1AvO2L7P

When I check the job at BQ end, the job has run successfully. Please help in resolving this issue. 

Thanks in Advance

[mhar]

Hi,

See this thread for cause and work around:

https://community.powerbi.com/t5/Service/Refresh-fails-BQ-Error-interacting-with-REST-API-Not-found-...

And also this (you can vote as well): https://community.powerbi.com/t5/Issues/Latest-Power-BI-update-broke-Google-Cloud-BigQuery-connectio...

/Martin

[v-deddai1-msft]

Hi @Anonymous ,

Would you please use the built-in Google BigQuery connector to get data? For more details, please refer to https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-bigquery  And please refer to the similar post: https://community.powerbi.com/t5/Issues/connecting-Bigquery-to-Power-BI-Desktop-Error-Job-Not-Found/idi-p/552174

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[ebozzi]

Hi Dedmon.

I'm facing the very same issue, using the built-in connector, specifying the billing project in the M source code, as suggested here, but above all, my scheduled refresh just started throwing errors last Wednesday, October 21st, and I didn't changed nothing on the Google big Query side, nor on the Power BI side.

Plus, I can refresh data using Power BI desktop, but I need these reports to be visible to others and I can't do that if the scheduled refresh isn't working.

Can you please investigate if some changes have been made to the ODBC driver that it is used by the scheduling service?

Many thanks in advance.

EB