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

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users


We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Users online (38,843)