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 / Error trying Export da...
Power Apps
Unanswered

Error trying Export data from CDS

(0) ShareShare
ReportReport
Posted on by 110

Hello,

 

I'm attempting to export data from one CDS environment (production) to another (development).
When attempting to export  a built-in CDS column (Accounts) I'm getting this error:

 

The powerquery job failed with error: Challenge ChallengeType:Resource, ChallengeDataSource:{'Kind':'Web','Path':'https://accuflo.crm3.dynamics.com/api/data/v9.0/accounts?$select=accountid,%20name,%20accountnumber,%20accountratingcode,%20address1_composite,%20address1_addresstypecode,%20address1_city,%20address1_country,%20address1_county,%20address1_fax,%20address1_latitude,%20address1_longitude,%20address1_postofficebox,%20address1_primarycontactname,%20address1_stateorprovince,%20address1_line1,%20address1_line2,%20address1_line3,%20address1_telephone2,%20address1_telephone3,%20address1_postalcode,%20address2_composite,%20address2_addresstypecode,%20address2_city,%20address2_country,%20address2_county,%20address2_fax,%20address2_latitude,%20address2_longitude,%20address2_postofficebox,%20address2_primarycontactname,%20address2_stateorprovince,%20address2_line1,%20address2_line2,%20address2_line3,%20address2_telephone1,%20address2_telephone2,%20address2_telephone3,%20address2_postalcode,%20address1_telephone1,%20aging30,%20aging30_base,%20aging60,%20aging60_base,%20aging90,%20aging90_base,%20revenue,%20revenue_base,%20businesstypecode,%20accountcategorycode,%20accountclassificationcode,%20createdon,%20creditonhold,%20creditlimit,%20creditlimit_base,%20customersizecode,%20entityimage,%20description,%20donotbulkemail,%20donotbulkpostalmail,%20donotemail,%20donotfax,%20donotpostalmail,%20donotphone,%20emailaddress1,%20emailaddress2,%20emailaddress3,%20entityimageid,%20exchangerate,%20fax,%20followemail,%20ftpsiteurl,%20importsequencenumber,%20industrycode,%20lastusedincampaign,%20lastonholdtime,%20telephone1,%20marketcap,%20marketcap_base,%20marketingonly,%20merged,%20modifiedon,%20numberofemployees,%20onholdtime,%20telephone2,%20ownershipcode,%20participatesinworkflow,%20paymenttermscode,%20preferredappointmentdaycode,%20preferredcontactmethodcode,%20preferredappointmenttimecode,%20primarysatoriid,%20primarytwitterid,%20processid,%20stageid,%20overriddencreatedon,%20customertypecode,%20donotsendmm,%20sharesoutstanding,%20shippingmethodcode,%20sic,%20statuscode,%20statecode,%20stockexchange,%20telephone3,%20territorycode,%20tickersymbol,%20timespentbymeonemailandmeetings,%20timezoneruleversionnumber,%20traversedpath,%20utcconversiontimezonecode,%20versionnumber,%20websiteurl,%20yominame,%20_createdonbehalfby_value,%20_createdbyexternalparty_value,%20_createdby_value,%20_transactioncurrencyid_value,%20_slainvokedid_value,%20_masterid_value,%20_modifiedonbehalfby_value,%20_modifiedbyexternalparty_value,%20_modifiedby_value,%20_owningbusinessunit_value,%20_parentaccountid_value,%20_preferredsystemuserid_value,%20_primarycontactid_value,%20_slaid_value&$orderby=versionnumber%20desc','NormalizedPath':'https://accuflo.crm3.dynamics.com/api/data/v9.0/accounts','IsDefaultForKind':false}

I can't find much on what this is, I'm assuming it's a bug on MS end?

I have the same question (0)
  • v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @AccuFloDev,

    Could you please share a bit more about the error message within your CDS environment?

    How do you export data from your CDS environment? Via click the "Export data" option within your Accounts Entity?

    I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:1.JPG

    Please take a try to clear cache of your browser, and then export your CDS data again, then check if the issue is solved.

    In addition, as an alternative solution, you could consider take a try to create a new solution within your PowerApps, then click "Add existing" -> Entity option to add your Accounts Entity into this solution, after that, export this solution from your Production environment, and import it into your Development environment. Then then CDS entity would be imported into your Development environment.

    More details about exporting, importing solution within PowerApps, please check the following article:

    https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/import-update-export-solutions

     

    Best regards,

    Kris

     

  • AccuFloDev Profile Picture
    110 on at

    Hey @v-xida-msft,

     

    Here's the process I used to attempt an export:

     

    1.  Sign into web.powerapps.com
    2. Click on Data --> Entities --> Account
    3. On the top ribbon click "Export Data"
    4. Screen says 'Exporting' for a few seconds, then error message.

    I was able to work around this by using export-to-excel.

     

    I attempted the export again this morning and the error is still occuring:

    Output.PNG

     

    Please let me know if you need anything from me to diagnose.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 103

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
wolenberg_ Profile Picture

wolenberg_ 67 Super User 2026 Season 1

Last 30 days Overall leaderboard