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
Super User

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

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (3,014)