Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Exporting table data t...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Exporting table data to excel fails without clear reason

(1) ShareShare
ReportReport
Posted on by Junius01 49

Hello everyone

I've encountered an annoying problem. When I try to export the data from my custom entity, named country, I get the following error message:

pastedimage1670847814873v1.png

The error itself doesn't say much, and when I google the error message I receive, I don't find a clear reason or solution to my problem.
Does anyone here know how I can fix this issue, or how I can get more information about this error? 

I have tried exporting this data from Dataverse as well as from the solution the table is created in. Both places have given me the same error.

The entity does not have any plugins, or business rules associated with it. It does have a relation to both the contact and account entities.

Thanks in advance

Kind regards

Junius

  • Suggested answer
    dasabate72 Profile Picture
    dasabate72 on at
    Exporting table data to excel fails without clear reason
    Had the same issue and got it working after I re-authenticated the Dataverse connection. Navigate to the maker portal - Connections and search for Dataverse connections. If any show the "Can't sign in. Reconnect" message, go ahead and re-authenticate it, then try the export again. Also be aware that if the process takes more than 12 minutes, it will also fail.
  • Craig Day Profile Picture
    Craig Day 55 on at
    RE: Exporting table data to excel fails without clear reason

    Hi Junius,

    Have you tried disabling any Business Rules against the Contact table before exporting? I got the same error trying to export data from the Contact table itself which was part of my Solution. After disabling the default Business Rule on the table, it worked. Because your table is related to Contact, that may be the cause.

    This was also preventing me from Importing. 

    Best,

    Craig 

  • Suggested answer
    Leco Lv Profile Picture
    Leco Lv on at
    RE: Exporting table data to excel fails without clear reason

    Hi partner，

    Could you provide your error log？ This might be a known issue：The system is always trying to use a connection set that doesn't exist in the system anymore. 

    "{"messageCode":"","message":"[Not Found], [{\"status\":404,\"source\":\":443/token//exchange\",\"message\":\"Error from token exchange: The connection () is not found. Please create new connection and change your application to use the new connection.\"}], The remote server returned an error: (404) Not Found."}"

     or the following:

    ERROR: {"error":{"code":"0x80060429","message":"Number of calculated fields in query exceeded maximum limit of 50."}}
    The above error tells you that it is a CRM limitation and why are you are not able to export. While exporting we send the same query to Data verse, and it is rejected due to the same issue. 

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,622 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans