web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

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
    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard