Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

Error Code: Mashup Exception Error

Like (1) ShareShare
ReportReport
Posted on 6 Apr 2022 08:21:58 by 33

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
else
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, 

Sam

  • abohassan Profile Picture
    2 on 26 Aug 2023 at 08:11:17
    Re: Error Code: Mashup Exception Error

    i have same problem do you have solution ?  

  • Community Power Platform Member Profile Picture
    on 06 Mar 2023 at 20:18:46
    Re: Error Code: Mashup Exception Error

    Hi Sam,

     

    Were you ever able to figure this out?

     

    Thank you,

    Zach

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 28

#2
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#3
LA-30040116-0 Profile Picture

LA-30040116-0 21

Overall leaderboard

Featured topics

Loading started