Reply
Shg
Frequent Visitor

Mashup Exception Expression Error

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!

1 REPLY 1
ZhangKun
Super User
Super User

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]}
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)