cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

CDS export data not working

I built a customized entity and I now want to export the data to an Excel file. The entity has 86K records. When I go to the export data option I only get an excel file with the name of each of the fields in the entity - no records exported. 

Is there any way to get the data?

6 REPLIES 6
Highlighted
Power Apps
Power Apps

Re: CDS export data not working

Adding @sabinn from the Data Integration team

Thanks,
Clay.
Highlighted
Anonymous
Not applicable

Re: CDS export data not working

I am having similar issues with about 44,000 records, have they found an answer for this?

Highlighted
Anonymous
Not applicable

Re: CDS export data not working

When exporting data I found that selecting export to CSV instead of Excel works. there is a dropdown on the upper right of the page where you can change to CSV. I tried it and it worked with 40,000 records.

Highlighted
Microsoft
Microsoft

Re: CDS export data not working

Thanks for reporting this issue.

When you say it doesn't work, can you elaborate more.

For Excel, can you try chunking the data, smaller pieces - Ex: three files of 30k rows or 4 of 20k?

 

Much thanks

sabinn
Highlighted
Anonymous
Not applicable

Re: CDS export data not working

sabinn, when exporting it ot a "xlsx" file it does not work, when selecting a "CSV" for export it does work.

Highlighted
Microsoft
Microsoft

Re: CDS export data not working

Thanks for feedback.

Does it fail without any error? Do you see anything under 'notifications'?

We will look into this problem. I am also hoping you are not blocked since .csv works. thanks

sabinn

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,474)