topic Re: Refresh fails BQ - Error interacting with REST API: Not found: Job... in Service

Refresh fails BQ - Error interacting with REST API: Not found: Job...

mhar — Wed, 21 Oct 2020 07:33:42 GMT

Hi,

I receive the following issue on scheduled refresh of most datasets this morning. The few that are not affected seems to have in common that they are small, however they still connect to Big Query in the same way.

ODBC: ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Not found: Job ...

The refresh works in desktop, but fails in service. Yesterday I upgraded one of the workspaces to new experience however datasets from other workspaces fail as well (and datasets refreshed worked after the upgrade). I have seen this issue mentioned before but with no real solution. It's mentioned that the region might have something to do with it. The data in BQ is in europe-north1.

Thanks,

Martin

Re: Refresh fails BQ - Error interacting with REST API: Not found: Job...

andy_lai — Wed, 21 Oct 2020 08:33:15 GMT

Same here before this work smoothly till this morning prompt me this error.

Re: Refresh fails BQ - Error interacting with REST API: Not found: Job...

Anonymous — Thu, 22 Oct 2020 06:53:29 GMT

Me too,
Are in great trouble

Re: Refresh fails BQ - Error interacting with REST API: Not found: Job...

mhar — Thu, 22 Oct 2020 07:45:15 GMT

I received the solution to add UseStorageApi=false to the source, for example

Source = GoogleBigQuery.Database([UseStorageApi=false])

This is because Storage API is now enabled by default as data fetch method for BQ. However this did not solve my problem, but maybe it could solve it for others.

Re: Refresh fails BQ - Error interacting with REST API: Not found: Job...

andy_lai — Thu, 22 Oct 2020 08:55:18 GMT

cannot solve my issue also, same error

Re: Refresh fails BQ - Error interacting with REST API: Not found: Job...

mhar — Thu, 22 Oct 2020 09:11:38 GMT

The product team are now working on a solution for this as it is identified as a problem with the Big Query connection.

Re: Refresh fails BQ - Error interacting with REST API: Not found: Job...

hieulnt13952 — Thu, 22 Oct 2020 10:23:41 GMT

I ran into the same problems today, just found a work-around solution that using PBI dataflow to store data before loading it to visualization. This practice is not quite convenient at all but at leaset we can keep our reports updating.

Waiting for this issue to be fixed asap.

Re: Refresh fails BQ - Error interacting with REST API: Not found: Job...

quanple — Thu, 22 Oct 2020 11:06:41 GMT

I've the same issue, any update on solution ?

Re: Refresh fails BQ - Error interacting with REST API: Not found: Job...

mhar — Fri, 23 Oct 2020 06:06:44 GMT

I guess the once affected by this are fetching data from outside of US or EU in Big Query, I am in europe-north1. The query runs fine in Big Query but when PBI is to fetch the result it doesn't provide the location parameter and therefore only default multi-region locations work. At least this seems to be the educated guess as reported here: https://community.powerbi.com/t5/Issues/Latest-Power-BI-update-broke-Google-Cloud-BigQuery-connections/idc-p/1449869#M61742

So workaround is to move BQ location. For us this will have a ripple effect and not really something we want to do. It would be appriciated with a solution or a simpler workaround.

Re: Refresh fails BQ - Error interacting with REST API: Not found: Job...

andy_lai — Mon, 26 Oct 2020 03:10:36 GMT

A few days already, anybody heard any update from MS or any workaround beside manual refresh.

Re: Refresh fails BQ - Error interacting with REST API: Not found: Job...

mhar — Tue, 27 Oct 2020 14:08:37 GMT

Up on status page now:

Power BI customers using Google BigQuery as a data source may see refreshes not complete successfully with the message "ODBC: ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API". Engineers are working on a fix and expect it to be deployed by end-of-day 10/31/2020.

Re: Refresh fails BQ - Error interacting with REST API: Not found: Job...

ebozzi — Sun, 01 Nov 2020 10:50:52 GMT

Still not working, I'm afraid...

Re: Refresh fails BQ - Error interacting with REST API: Not found: Job...

v-easonf-msft — Mon, 02 Nov 2020 06:19:29 GMT

Hi, ebozzi

As a workaround ,you can try to use PBI desktop Sept refresh then do republish.

Best Regards,
Community Support Team _ Eason

Re: Refresh fails BQ - Error interacting with REST API: Not found: Job...

andy_lai — Mon, 02 Nov 2020 06:42:02 GMT

Auto-refresh still not working, need to publish manually.

Not sure MS got announce any fix date or not.

Re: Refresh fails BQ - Error interacting with REST API: Not found: Job...

v-easonf-msft — Thu, 05 Nov 2020 01:52:17 GMT

Hi, andy_lai
Engineers are working on a fix and expect it to be deployed by end-of-day 11/09/2020.
https://powerbi.microsoft.com/en-us/support/

At that time, please check your report again.

Best Regards,
Community Support Team _ Eason

Re: Refresh fails BQ - Error interacting with REST API: Not found: Job...

v-easonf-msft — Thu, 10 Dec 2020 05:50:42 GMT

Hi， mhar

The issue seems to be solved.

If so,pleaase accept the helpful answer as solution to close this thread.

Best Regards,
Community Support Team _ Eason