Showing results for 
Search instead for 
Did you mean: 
New Member

Error Code: Mashup Exception Error

Hi All, 


I am trying to get data from one table to another table within my power query in my dataflow. When I use the necessary code in the "Add Column" the data appears on the Power Query display but when I publish the data I get this error:


Error Code: Mashup Exception Error, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Expression.Error: The key didn't match any rows in the table.


The code I am using is this:
if [#"2022-23 EmpNo"] is null
then null
Record.Field(cr047_all_employee{[cr047_empno=[#"2022-23 EmpNo"]]},"cr047_allemployeekey")


My power query looks like this:
Screenshot 2022-04-06 101341.png








The data from cr047_all_employee needs to match to the 2022-23 EmpNo .. Which is currently what is happening - EmpPick comes from the cr047_all_employee table. Though when I publish this data and expect it to pull through correctly, I get this error: 


Screenshot 2022-04-06 1019451.png










Is anyone able to assist me and tell me where I am going wrong?


Kind regards, 



Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,286)