Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Any Known Issues with CDS Size?



I have a CDS Entity with a DataFlow setup to get data from Excel every 2 minutes. The excel table is 8 columns and 1300 rows.


I have a PowerApp with a ComboBox that displays the 'Customer Name' field from CDS using:

Distinct(BackendDatabases.'Customer Name', 'Customer Name')


90% of the time this works and I can see all the customer names, however periodically I can only see a few out of the 50ish customer names. I have tried adding a button to refresh the source using:


This was unsuccessful.


Has anyone experienced anything similar? Its as if they are in CDS but there's an issue between CDS and PA communications.

Thanks in advance!



Super User II
Super User II

Hi @AndyH_JSY,

Did you check that the records do existing in CDS to eliminate the Dataflow as the issue if delete rows option is enabled? Can you check that the records exists with "Advanced Find" in your CDS environment.


Hi @EricRegnier,


Thanks for your reply!


I can confirm all records are in CDS correctly and I can find them. 


This appears to be an issue with using the entity as an Item within PowerApps. It works most of the time, just quite intermittent.



Helper II
Helper II

I still seem to be getting intermittent issues with loading data in PowerApps.


Any suggestions are welcomed!

Helpful resources

News & Announcements

Community Blog

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

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Users online (19,816)