cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AccuFloDev
Level: Powered On

Error trying Export data from CDS

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?

2 REPLIES 2
Community Support Team
Community Support Team

Re: Error trying Export data from CDS

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

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AccuFloDev
Level: Powered On

Re: Error trying Export data from CDS

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.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Users Online
Currently online: 283 members 6,666 guests
Please welcome our newest community members: