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

CDS Data export error

Dear Team,

 

I dont know why Im not able to export my data from a custom entity

I wento to Entitites-->CustomEntity-->Data--Export Data.. and it shows the following error.

 

 

Sin título.png

 

Please I need the data because I want to see the data via power BI.

Thanks in advnace!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
coolo0220
Level: Powered On

Re: CDS Data export error

Hi all, 

 

I've got the response from the microsoft support and here is the message: 

 

"Dev checked in changes to the backend service and introduced some new url actions to be called from the portal.  It looks like these changes have not propagated to all environments.  Import/export from the portal is failing on some environments because it cannot find the new url.  
and this doesn’t happen very often for sure."

 

Hopefully everyone's CDS is back to service! Smiley Happy

 

 

View solution in original post

15 REPLIES 15
Community Support Team
Community Support Team

Re: CDS Data export error

Hi @cperia,

 

Thanks for the feedback.

I just tried to export the data from a custom entity, it works from my side:

In addition to the Export Data, have you tried the Open in Excel option?

 

9.PNG

 

Regards,

Michael

 

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

Re: CDS Data export error

I have the same issue as well. And I've tried with other entities, which all have the same issue. Since my work computer doesn't allow office to access the data from another source due to administration restriction. Is there other way to resolve this issue? 

 

Thanks,

 

Mike

Anonymous
Not applicable

Re: CDS Data export error

This has been happening to me over the last week or so as well. I cannot export or import CDS data. I also just get a blank table when I open the entity in Excel. The only way I have been able to do data manipulation is manually through a PowerApp but this doesn't really work very well for what I need to accomplish.

Anonymous
Not applicable

Re: CDS Data export error

Same for me....

 

I get the same '! Export Failed' message for the template or the data.

 

I also tried exporting the table as Environment resources in the Admin Center and imported the resources in to a new environment and still got the Export Failed error when exporting the template from the new environment.

 

I tried opening in Excel too, it doesn't work.

 

Please let me know when there's a work around or fix.

 

FYI... This is becoming widespread I saw the same issue in the PowerApps main forum under

"export of CDM entity template failing"

 

Thanks

Highlighted
aandrade
Level: Powered On

Re: CDS Data export error

I have been experiencing the same issue and started a couple of weeks ago. Checked in the community boards and they are investigating.

 

Your help is greatly appreciated!

 

Anonymous
Not applicable

Re: CDS Data export error

Hi cperia,

 

I did manage to make a work around to export entity data:

  1. Create an excel file with your entity fields
    1. Select the column headers and insert a table
    2. Leave the default table name alone (Table1) - do not change it
    3. Save it on OneDrive
  2. Make sure you are in your correct environment
  3. Create a PowerApps Flow
    1. Start with a blank flow (in the PowerApps site not the Flow site)
    2. PowerApps will be the 1st trigger - you cannot edit this
    3. Add a New Step (ANS) then Add An Action (AAA)
    4. Search "common" in the dialogue box
    5. Pick Common Data Service - Get List of Records
      1. Pick default from the database dropdown
      2. Pick your Entity from the Entity dropdown
    6. ANS & AAA
    7. Search "Excel" in the dialogue box
    8. Pick Insert Row
      1. For the File Name use the folder button to find your Excel file on One Drive (or other repositories)
      2. For the Table Name use the drop down to select "Table1" (you created in step 1)
      3. A field mapping matrix will appear, if you have spaces in the Excel field names they will look funky but you should be able to complete the mapping between your entity and Excel
      4. Complete the mapping
    9. ANS
      1. When you add new step the Excel Insert Row step should convert to an Apply to Each loop and you should get prompted the firt time - say yes/ok. This will copy the entity data record by record to Excel
    10. You can cancel the ANS here but my preference is to add an ANS & AAA for Office Outlook 365 - Send an email
      1. This is straight forwards just setup an email with a relevant subject and body so you know when the copy is complete (for about 20 columns per row it takes about 2 seconds each record so it's not fast)
    11. You can run the flow from here or attach it to a button in a PowerApp (I think I will make a Utilities App with flows like this until CDS gets some fixes)
  4. Done

Hope this helps you out Smiley Happy

coolo0220
Level: Powered On

Re: CDS Data export error

This workaround was part of my plan if the issue cannot be fixed. However, this wasn't the intension of the app itself. Hopefully Microsoft can resolve this issue and regain the function it is intend to do. 

Anonymous
Not applicable

Re: CDS Data export error

FYI... having the same issue when importing using the CDS import interface - "! Import Failed".

 

I'm going to make a flow for the workaround but this sucks.

 

Thanks

 

cperia
Level: Powered On

Re: CDS Data export error

Hello, Thnaks Peter for the workaround, that solved my issue in meantime.

yes agree with you! this sucks!!

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 277 members 3,269 guests
Please welcome our newest community members: