topic ApiResponseError when opening any Dataflow in Dataflow

ApiResponseError when opening any Dataflow

rvp_ordix — Fri, 23 Aug 2024 07:13:04 GMT

When opening any of my dataflows I get the following error message:

ApiResponseError: Unable to complete the request. Please retry again later, and if this issue recurs, check your network, proxy, vpn, or firewall configuration or contact your network administrator.
at p.handleErrorEvent (https://europe.prod.powerquery.microsoft.com/MashupEditor/scripts/p.h.a.1a2d53f96433b2ddd292.bundle.js:2:34343)
at XMLHttpRequest.<anonymous> (https://europe.prod.powerquery.microsoft.com/MashupEditor/scripts/p.h.a.1a2d53f96433b2ddd292.bundle.js:2:36075)

Most of the other forum posts about this point towards Gateways and on-prem data storages as the culprit but I use neither. All my tables are either on an Azure SQL Server in the cloud or in a Fabric Lakehouse. The message suddenly appeared one day without my having changed something.

Re: ApiResponseError when opening any Dataflow

lbendlin — Fri, 23 Aug 2024 22:14:57 GMT

Dataflow Gen 2?

Re: ApiResponseError when opening any Dataflow

pqian_MSFT — Sat, 24 Aug 2024 01:28:54 GMT

Do you by any chance have the ublock chrome extension? There's been an update on that extension which blocks some APIs Dataflow Editor uses. Can you disable the extension and try again?

Re: ApiResponseError when opening any Dataflow

Joshrodgers123 — Mon, 26 Aug 2024 01:41:35 GMT

That was it! I had the same issue and disabling ublock fixed it.

Re: ApiResponseError when opening any Dataflow

rvp_ordix — Mon, 26 Aug 2024 12:57:26 GMT

It was the Edge Version of that extension, but yeah, that worked. Somewhat strange, though, that this only became a problem recently. I've been using uBlock on Edge for months now without trouble. No matter. Thank you!