topic Re: MashupException.Error: The value is not updatable. in Dataflow

MashupException.Error: The value is not updatable.

m_cherriman — Wed, 08 Nov 2023 10:02:00 GMT

I have a Dataflow in Fabric that connects to an on premise SQL Server and last week it was working and this week I am getting this error: Error Code: 999999, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: The value is not updatable.

I got this error yesterday morning and had the data gateway updated yesterday afternoon in case this was the issue, but I still get the error. The previous version of the gateway was only installed 2 weeks ago. The current version of the gateway is 3000.198.9.

When I view the output in Dataflow it looks ok and is able to refresh. Also there are no errors in the data.

Re: MashupException.Error: The value is not updatable.

Anonymous — Wed, 08 Nov 2023 11:52:32 GMT

Hi m_cherriman ,

Thanks for using Fabric Community and reporting this,

At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.
Appreciate your patience.

Re: MashupException.Error: The value is not updatable.

miguel — Wed, 08 Nov 2023 15:07:16 GMT

Hi!

Could you please raise a support ticket so an engineer can take a closer look into this?

Here's the link to raise the support ticket --> https://support.fabric.microsoft.com/support

Re: MashupException.Error: The value is not updatable.

Anonymous — Wed, 08 Nov 2023 16:17:06 GMT

Hi m_cherriman ,

We'd like to check if it's our issue or hit the error by design.

You can send us the information through email to AzCommunity[at]Microsoft[dot]com with the below details :

Workspace id
Workspace name
Artifact id

Subject of the email: ATTN: PRADEEP - MashupException.Error: The value is not updatable.

Thanks.

Re: MashupException.Error: The value is not updatable.

knaidoo13 — Wed, 08 Nov 2023 21:37:15 GMT

I am getting the exact same error. My data flows were running smoothly, and now they are all failing since we updated out paower bi gateway version to the latest.

Re: MashupException.Error: The value is not updatable.

GuillaumeBer — Thu, 09 Nov 2023 13:04:30 GMT

Hi Anonymous , I'm getting the same Error Code: 999999, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: The value is not updatable.
as knaidoo13 , yesterday we just updated our OnPremise DataGateway to the latest version 3000.182.4

PS : The Fabric documentation here explicitely talks about similar error and mention the upgrade to the latest OnPrem Gateway Version

Re: MashupException.Error: The value is not updatable.

gazsam2 — Thu, 09 Nov 2023 10:33:29 GMT

Experiencing same issue with an on-prem SQL Server, also running 3000.198.9

Re: MashupException.Error: The value is not updatable.

Anonymous — Thu, 09 Nov 2023 11:51:03 GMT

Hi gazsam2 , GuillaumeBer , knaidoo13

Apologies for the issue you people are facing. At this time, we are reaching out to the internal team to get some help on this . We will update you once we hear back from them.

Re: MashupException.Error: The value is not updatable.

daamruth — Fri, 10 Nov 2023 09:07:03 GMT

Hi,

is there a problem filed already? We are having the same issue after updating the Gateway to 3000.198.9

Daniel

Re: MashupException.Error: The value is not updatable.

Anonymous — Sun, 12 Nov 2023 08:58:33 GMT

I encountered the same issue after updating the gateway to version 3000.198.9. However, I was able to resolve it by downgrading to the September version, 3000.190.17, which restored functionality.

There is also an October version available that you might consider. However, I opted for version 3000.190.17 as I had prior experience with its successful operation.

Re: MashupException.Error: The value is not updatable.

annemari — Wed, 15 Nov 2023 11:06:35 GMT

Same issue here, same error messages. Also on gateway version 3000.198.9

Re: MashupException.Error: The value is not updatable.

gthill — Wed, 15 Nov 2023 14:24:54 GMT

We are getting this same error - our On-Premise Data Gateway is also 3000.198.9 (November 2023)

Error Code: 999999, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: The value is not updatable. Details: Reason = Expression.Error;Detail = #table({"Name", "Id", "Data", "Schema", "ItemKind", "ItemName", "IsLeaf"}, {});Microsoft.Data.Mashup.Error.Context = System GatewayObjectId: XXX (Request ID: XXX).

Re: MashupException.Error: The value is not updatable.

Ultimx — Wed, 15 Nov 2023 15:36:57 GMT

Same issue here, can not refresh the dataflow gen2 with the last version of gateway 3000.198.9
In fact, we can refresh the power bi dataset with this gateway.

Re: MashupException.Error: The value is not updatable.

carlosgeovany — Wed, 15 Nov 2023 16:33:25 GMT

Issue started two days ago. Same error messages. But with gateway version 3000.190.19

Re: MashupException.Error: The value is not updatable.

Ultimx — Wed, 15 Nov 2023 17:02:13 GMT

works fine with the september gateway guys, just downgrade it and be waiting for new version...

Re: MashupException.Error: The value is not updatable.

Bosse__ — Thu, 16 Nov 2023 19:55:21 GMT

+1. Reinstall the gateway (september 2023) and it just works...
https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-monthly-updates#september-2023-update-300019017

Re: MashupException.Error: The value is not updatable.

webchris — Fri, 17 Nov 2023 16:12:20 GMT

That is no that easy in bigger companies... 🙄

Re: MashupException.Error: The value is not updatable.

gazsam2 — Fri, 17 Nov 2023 16:16:02 GMT

Yep, makes the hard sell of Fabric that much more challenging internally too. We're turning back some of our ambitions based on the gateway:Dataflow Gen2 challenge here.

Re: MashupException.Error: The value is not updatable.

jberkers — Mon, 20 Nov 2023 01:02:19 GMT

Us too.

We upgraded our On-Premise Data Gateway from 3000.190.19 to 3000.198.9 last Wednesday, and all of our DataFlow Refreshes have failed since then.

We've been having some intermittent capacity issues for the past couple of months, with no corresponding increase in actual data flows, so was trying to stay ahead of this issue by pro-actively upgrading the Data Gateway, but got this issue instead.

Hopefully this issue is sorted out soon, downgrading back to the previous version seems to have resolved the issue for us as well.

Re: MashupException.Error: The value is not updatable.

GuillaumeBer — Thu, 23 Nov 2023 09:19:34 GMT

Hi Anonymous we didn't get any feedback from you on that matter so I created the support case 2311230050001043 ; please let me know if in the meantime you got any insight how to fix this issue so I can close my case. Thanks