web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / DataFlow Error "The Va...
Power Apps
Unanswered

DataFlow Error "The Value is not Updatable"

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I am trying to use a dataflow to move data from SQL to Dataverse but I am getting this error.  I can't figure out what the problem is.  Any ideas?

 

Error Code: Mashup Exception Error, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: The value is not updatable.

  • AhmedSalih Profile Picture
    6,680 Moderator on at

    Hello, @Anonymous, first thing to try to track the cause of this issue is to make sure that your Dataverse table columns data types are matching the data types of your SQL table columns.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    They do match.  This is even happening on a table that was created by the Datatflow.  It created the table but won't add any data to it.

  • AhmedSalih Profile Picture
    6,680 Moderator on at

    @Anonymous, one more thing to also check is your SQL columns names don't have spaces specially tailing or trailing spaces. 

  • Fubar Profile Picture
    17 Super User 2026 Season 1 on at

    Make sure that you are not trying to directly create/update System fields that are read only - like the Created On  date (in that specific case there is a Created On Override field that is used instead)

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I am testing it with just a single text field.  I have an identical dataflow that works fine where Excel is the data source.  Only the dataflow with SQL as the data  source will not update.

  • kggg Profile Picture
    4 on at

    Did you ever find a solution? I have the same issue with a new dataflow in a development environment. 

  • AlexisG59 Profile Picture
    3 on at

    I have the same issue

     

  • HK Profile Picture
    6 on at

    Experiencing the same issue here and also failing when creating a new table and bringing limited rows in. 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 396 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 323

#3
WarrenBelz Profile Picture

WarrenBelz 193 Most Valuable Professional

Last 30 days Overall leaderboard