The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
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]}