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 / How do I migrate table...
Power Apps
Answered

How do I migrate table data to PowerApps for Teams from PowerApps for Web?

(0) ShareShare
ReportReport
Posted on by 831 Moderator

I ran into issue with my PowerApps for Web app that I was developing. This was due to Premium features that were previously available to me with the last app I built in PowerApps for Teams. As a solution, I tried importing my web app into Teams. After having to clear up some dependency issues it looked like I finally succeeded. Only problem is all of my Dataverse tables are empty. How do I restore those with the data from my web app?

  • Verified answer
    Ami K Profile Picture
    15,689 Super User 2024 Season 1 on at

    [moved to the correct forum]

     

    @futr_vision - does not work that way. Importing a solution will include the table metadata but not the data inside those tables. You will need to perform a data import exercise using the Import, Import from Excel, Dataflows, or the Dynamics 365 wizard (the latter I have written a blog on here: 

     

    https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Bulk-update-Dataverse-LookUp-column-using-Dynamics/ba-p/2300886

     

    There also third party tools like XRMToolBox: https://www.xrmtoolbox.com/plugins/Colso.Xrm.DataTransporter/ 

  • futr_vision Profile Picture
    831 Moderator on at

    Thanks. I'll look this over. I've used the Import from Excel functionality before but haven't worked with Dynamics 365. wouldn't mind learning something new.

  • futr_vision Profile Picture
    831 Moderator on at

    I'm having a bit of a struggle exporting any data form a Dataverse table. I get the following error

     

    "Connection to dataverse failed . Please check the link below on how to fix this issue."

     

    This is the article and the specific section: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-import-export#troubleshoot-connection-issues

     

    Here is my problem. I don't have the Microsoft Dataverse (legacy) connector in my list of connectors. I do have the new one but when I look at the "Apps using this connection" there are no apps listed. My app does have Dataverse tables in it and it does function. 

     

    Next, I took a look at security roles for myself. I have both Basic User and System Administrator roles. Maybe this is not enough?

     

    The other odd thing is that I have exported tables to Excel before. I recall it being an option in the menu at the top of the table page. That option is no longer available for some reason. I only get the "Export data" option. Any ideas what is going on here? 

  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    HI @futr_vision,

    System Admin role is enough and is the highest level of role for an environment. How are you trying to export?

    The dependencies issue are not related to the data so exporting the data and importing to the target wouldn't solve your issue. What do you mean by web app, is it a Power App? Some screenshots would help to understand better your issue. Thanks

     

     

  • futr_vision Profile Picture
    831 Moderator on at

    Turns out asking a question in these forums, usually fixes the issue shortly after posting. I couldn't export all day and right after I posed the export worked. 

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 432 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 347

#3
WarrenBelz Profile Picture

WarrenBelz 254 Most Valuable Professional

Last 30 days Overall leaderboard