Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

Import/Export excel files in dataverse tables

(0) ShareShare
ReportReport
Posted on by 34

Hello all,

I'm trying to test the import and export functionality of tables from Dataverse, but when I try to export, I get this screen (1st image) and when I try to import I get this error while login (2nd image). Have this happened to any of you? Do you know how to solve it?

Thanks in advance!!

  • einfante Profile Picture
    einfante 34 on at
    Import/Export excel files in dataverse tables
    Hello @SaiRT14
     
    Thank you for your response, but I havent used powershell before, where should I execute the code you share? 
     
    Regards
    Eugenio 
  • SaiRT14 Profile Picture
    SaiRT14 1,931 on at
    Import/Export excel files in dataverse tables
    try following powershell way:
     
    Export and import data using PowerShell Dataverse tools to bypass UI issues. 
    Export-CrmData -ConnectionString "your_connection_string" -OutputFilePath "path_to_file"
     
    import
    Import-CrmData -ConnectionString "your_connection_string" -InputFilePath "path_to_file"
     
    if you need details, pls let me know.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics