Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

Import/Export excel files in dataverse tables

Posted on 26 Nov 2024 10:28:14 by 30

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 30 on 29 Nov 2024 at 13:09:24
    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,196 on 27 Nov 2024 at 14:38:00
    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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,168

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,851

Leaderboard

Featured topics