Mashup Exception Expression Error

Shg — Wed, 30 Oct 2024 10:27:56 GMT

Hi,

I have a Dataflow Gen2 that sources several tables from Dataflow Gen1, and both dataflows were running successfully through a pipeline and load tables into my lakehouse as data destination.

I recently decided to delete one of the tables from both dataflows. I simply removed it from the queries list and my lakehouse. However, since doing so, my Dataflow Gen2 has failed to run, and I am now getting the following mashup error:

Mashup Exception Expression Error: Couldn't refresh the entity due to an issue with the mashup document. MashupException.Error: Expression.Error: The key didn't match any rows in the table.

Since the table no longer appears in my Dataflow sources and lakehouse, I’m unsure how to resolve this issue. Any guidance would be greatly appreciated!

Thank you in advance!

Re: Mashup Exception Expression Error

ZhangKun — Wed, 30 Oct 2024 13:44:56 GMT

This error usually (but not necessarily) comes from performing a specific index condition on a table, as shown in the following code:

// error #table({"a", "b"}, {{1, 2}, {3, 4}}){[a = 1, b = 3]} // ok #table({"a", "b"}, {{1, 2}, {3, 4}}){[a = 1, b = 2]}

topic Mashup Exception Expression Error in Power Query

Mashup Exception Expression Error

Re: Mashup Exception Expression Error