Announcements
No record found.
Hi,
Does the EntityKey under a data entity in VS affect the retrieval time of certain records in a 3rd party application (e.g., PowerApps) which uses this entity?
For example, if it takes too long to retrieve records which use an data entity field as a filter in PowerApps, should I add that entity field to the existing EntityKey to reduce the retrieval time?
Thank you.
EntityKey defines the unique key for the entity. The combination of the fields in EntityKey always link to exactly one record in the underlying data source table.
In general, when you search data in a database, you need to have proper indexes in the tables to correspond with the fields that you use as search criteria. So you should check if your entity data source table has indexes that correspond to your filter fields in PowerApps.
This is a high level description, details would depend on the details of your situation.
Hi Shawn
I'd like to add on to Nikolaos. The postLoad() method adds a considerable amount of processing time (it will execute for every record). If it has been overriden, try to replace the logic with computed columns or maybe some nifty joins.
Then do not use the OData group functionality. It's terrible. If you need to group you are calling the wrong DE. Create a new one if the required one does not yet exist.
You can simulate an OData GET with a select statement of the DE. Which should set some light on any possible causes of the slowness you describe.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 637
André Arnaud de Cal... 594 Super User 2026 Season 1
CP04-islander 356
