Showing results for 
Search instead for 
Did you mean: 
Not applicable

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!




Accepted Solutions
Regular Visitor

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



View solution in original post

Community Support
Community Support

Hi @Anonymous,


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?







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.
Regular Visitor

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? 





Not applicable

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.

Not applicable

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"



Frequent Visitor

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!


Not applicable

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 🙂

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. 

Not applicable

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.




Not applicable

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

yes agree with you! this sucks!!

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (3,531)