Skip to main content

Notifications

Community site session details

Community site session details

Session Id : EvzAvKixUd49AebXv7XLGz
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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

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

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 15

#2
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#3
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

Overall leaderboard

Featured topics

Loading started