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 :
Customer experience | Sales, Customer Insights,...
Suggested answer

Data Import - Error Log Export and 5000 Row Limit

(0) ShareShare
ReportReport
Posted on by 1,788

As per subject, I need to export a record of all failed imports which exceed 5000 records. How can I do this please?

I have the same question (0)
  • Suggested answer
    AJ-22040756-0 Profile Picture
    on at
    RE: Data Import - Error Log Export and 5000 Row Limit

    HI Partner

    Yes there is a limit of 5000 records and this seems to be by design for now, so you will have to export with a batch of 5000 records

    You can raise an idea here for this issue https://experience.dynamics.com/ideas/ 

  • MDS Profile Picture
    1,788 on at
    RE: Data Import - Error Log Export and 5000 Row Limit

    Hi Akash,

    How can I export in batches of 5000 though?

  • Suggested answer
    MehranBre Profile Picture
    732 on at
    RE: Data Import - Error Log Export and 5000 Row Limit

    hi,

    if you use OnPermise version, run this code on PowerShell:

    param(#optional params
        [string]$ConfigurationEntityName,
        [string]$SettingName,
        [object]$SettingValue,
        [Guid]$Id
    )
     
    $ConfigurationEntityName = "Deployment"
    $SettingName = "AggregateQueryRecordLimit"
    $SettingValue = 50000
     
     
    $RemoveSnapInWhenDone = $False
     
    if (-not (Get-PSSnapin -Name Microsoft.Crm.PowerShell -ErrorAction SilentlyContinue))
    {
        Add-PSSnapin Microsoft.Crm.PowerShell
        $RemoveSnapInWhenDone = $True
    }
     
    $setting = New-Object "Microsoft.Xrm.Sdk.Deployment.ConfigurationEntity"
    $setting.LogicalName = $ConfigurationEntityName
    if($Id) { $setting.Id = $Id }
     
    $setting.Attributes = New-Object "Microsoft.Xrm.Sdk.Deployment.AttributeCollection"
    $keypair = New-Object "System.Collections.Generic.KeyValuePair[String, Object]" ($SettingName, $SettingValue)
    $setting.Attributes.Add($keypair)
     
    Set-CrmAdvancedSetting -Entity $setting
     
    if($RemoveSnapInWhenDone)
    {
        Remove-PSSnapin Microsoft.Crm.PowerShell
    }

    Best Regards.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 127

#1
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 127

#3
Tom_Gioielli Profile Picture

Tom_Gioielli 125 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans