topic Re: Resource constraints error in Dataflow

Resource constraints error

ebjim — Thu, 17 Aug 2023 13:20:21 GMT

Lately, I have been receiving this message when refreshing dataflows:

Mashup Exception Error Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Microsoft SQL: This query cannot be executed due to current resource constraints. Statement ID: {278714F5-E313-4928-817D-C55F00858044} | Query hash: 0xB0D531E9223EB235 | Distributed request ID: {2180867E-A46E-4510-A384-F4C64B8E57D0} Details: DataSourceKind = Lakehouse;DataSourcePath = Lakehouse;Message = This query cannot be executed due to current resource constraints.

My dataflows are not complicated or dealing with large datasets. I also hit this error at different times of the day. What gives?

Re: Resource constraints error

HimanshuS-msft — Fri, 18 Aug 2023 20:32:16 GMT

Hello ebjim

Thanks for using the Fabric community.
The error message does not seem to very helpful , at this time I am reaching out to the interal to get more help on this
Thanks
HImanshu

Re: Resource constraints error

landregw — Wed, 23 Aug 2023 17:42:11 GMT

Hi Himanshu -
We are having a similar issue. Any update on what causes the resource constraints? we were basically locked out of our lakehouse for several hours yesterday while this was sorting itself out.

Thanks!
Greg

Re: Resource constraints error

aymantm — Mon, 04 Sep 2023 21:08:30 GMT

I am sharing the same interst in searching for a solution to this error