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

Community site session details

Session Id : qRfhPgvWBO/OcWD04053fH
Power Apps - Microsoft Dataverse
Answered

Issues with import export data, 0x80040203 error

Like (1) ShareShare
ReportReport
Posted on 20 Jul 2021 18:25:47 by 42

Hey all, 

 

So I've been stuck for a few days attempting to import data from one environment to another. I've tried using dataflows (OAuth and Excel), one time imports through a number of spreadsheet formats, doing it from within the app, doing it from the environment editor, using the new and legacy tools, pretty much everything. Consistently, it always looks like it is going to work (I get to the part where I can assign mappings, and everything looks like it is where it should be) but then fails with the same{"error":{"code":"0x80040203","message":"Changing security attributes is not allowed in stage 20 plugins."}}. I'm not sure what I am doing wrong here, I have imported spreadsheets to dataverse before and it was not difficult. I can't think of any major changes made to our organization that would suddenly make data imports impossible. 

 

All I can think of is there is some setting buried in a menu somewhere that is simply preventing any and all imports, maybe security roles, etc. I have myself checked as System Administrator, System Customizer, and Environment Maker. The import is to a table that is a carbon copy or the source (same solution). 

 

Also, the Export to Excel option within the environment editor is also not working for me: 

Export failed: There was an error adding a table to the project. 
 
Any and all help is appreciated, I'm getting nowhere trying to figure this out.

 

  • Verified answer
    ferris Profile Picture
    42 on 30 Nov 2021 at 18:13:10
    Re: Issues with import export data, 0x80040203 error

    I apologize, I completely forgot to update here.

     

    MS support did help me. There was an errant business rule that was attempting to fire when importing data. Specifically, this rule was related to another issue I was having: assigning a record owner to "Administration" rather than the user who created the record. In short, I first attempted to reassign the record owner through a business rule, which will throw an error. I did figure out how to do this with code, but somehow this inactive rule was copied to my new environment (was supposed to be removed). Oddly enough, this seemed to affect ALL entities, not just the one with the rule. In general, I would say my experience with business rules has been rather poor, and I usually end up just writing code every time I try to use them.

     

    I cannot say why this issue would prevent exports, but I can confirm that I no longer receive export errors since fixing it. halifaxious, I believe your issue may have a different solution, as I was always able to view data in excel (I just could not save edits). Maybe you are having a firewall issue? When I view data in excel from PA, it initially opens in Protected Mode, and will only display the data if I enable editing. If you are not receiving this prompt, I would start there with the troubleshooting.

  • EricRegnier Profile Picture
    8,714 Most Valuable Professional on 27 Nov 2021 at 18:54:48
    Re: Issues with import export data, 0x80040203 error

    @ferris sorry for my late reply, did you resolve this finally? If not let me know what progress made and happy to help

  • halifaxious Profile Picture
    217 on 27 Oct 2021 at 13:42:01
    Re: Issues with import export data, 0x80040203 error

    I just started having the same export issue last night. 

    Export failed: There was an error adding a table to the project.

    It is happening in at least 2 environments on the same tenant. Since I can't export, I haven't been able to determine if I also have a similar import problem.

     

    Things I've done that have made no difference:

    • update all plugins with updates (only Powerapps Checker). My plugins only include the default set
    • completely log out of everything, reboot and re-login
    • check another environment on the same tenant. (same problem there)
    • try exporting from Default solution (same problem there)
    • try 'Edit data in Excel' option on Data tab, which produced a file with correct column headers but no data

    Things that continue to work:

    • I can run fetch queries from XrmToolBox with no difficulty. So it doesn't appear to be a data problem
    • I can export to Excel from my application's UI (one would think this would fail the same way the 'Edit data in Excel' function in the backend fails)

    @ferris did you ever come to a solution?

  • ferris Profile Picture
    42 on 04 Aug 2021 at 15:37:18
    Re: Issues with import export data, 0x80040203 error

    Thanks I figured it was that. Everything looked normal there, but I decided to just hit install on Powerapps checker to see what happened (already said it was enabled). List completely refreshed with different items, one with update available so I will look into this and let you know how it goes.

  • cchannon Profile Picture
    4,702 Moderator on 04 Aug 2021 at 12:37:04
    Re: Issues with import export data, 0x80040203 error

    Sure, from the admin.powerplatform.com UI, go to your environments and pick the one that's giving you trouble. In the lower Right, you will see a Resources panel. This will have various stuff in it, depending on the specifics of your environment, but you will probably see a "Dynamics 365 Apps" item in that list:

    cchannon_2-1628080342859.png

     

    Click it and you will see a list of the first-party apps installed in your environment. If you are on vanilla Dataverse, this list will be small but if you are on a D365 org, it will be longer.

     

    See if any of these apps are showing as "Update Available" or "Installation Failed" and if so, click on them to install the latest version of that app:

    cchannon_3-1628080516650.png

  • ferris Profile Picture
    42 on 03 Aug 2021 at 21:25:08
    Re: Issues with import export data, 0x80040203 error

    I want to try your idea but I'm a little lost. Are you referring to something in the power platform admin center or Microsoft.PowerApps.Administration.PowerShell, or maybe something else I haven't stumbled across?

     

    Sorry I constantly find I'm learning something new with this platform every time I think I've got it.

  • ferris Profile Picture
    42 on 03 Aug 2021 at 21:21:49
    Re: Issues with import export data, 0x80040203 error

    Thanks for the help guys. I will follow up with the support ticket this week and see where it's at. Fortunately I have plenty of other work to do around here.  

  • EricRegnier Profile Picture
    8,714 Most Valuable Professional on 03 Aug 2021 at 21:15:58
    Re: Issues with import export data, 0x80040203 error

    if the ticket is not set as urgent Microsoft Support can take some time to respond. Try getting in touch or open a new urgent ticket. They’re pretty quick to response on urgent, but you always need to keep following up.

  • cchannon Profile Picture
    4,702 Moderator on 02 Aug 2021 at 18:39:05
    Re: Issues with import export data, 0x80040203 error

    I don't have any good reason to think this will help, but since you're dead in the water there's no reason not to try...

     

    Look at your installed first-party solutions from the admin.powerapps console. From there, see if any of them have pending updates and install every update out there. Maybe you got a bad update at some point and just haven't updated it away? 

  • ferris Profile Picture
    42 on 02 Aug 2021 at 15:25:05
    Re: Issues with import export data, 0x80040203 error

    Well still stuck here, haven't heard back from Microsoft after the first support meeting. Once again, any kind of data import activity, whether it be through a dataflow, and import through the legacy Dynamics interface, through the new Unified Interface, or even just manually editing data in Excel, all will always return the same error: "Changing security attributes is not allowed in stage 20 plugins." If anyone out there has seen this issue and resolved it please let me know what you did, my app progress has been dead in the water for weeks because of this. 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Featured topics

Loading complete