Best practices and guidance for working with data in Microsoft Dataverse

The following list contains best practices and guidance for integrating data by using code with Dataverse.

Best practice	Description
Service protection API limits (Dataverse)	Understand the limits for API requests.
Optimize performance for bulk operations	Choose the best strategy to create and update large numbers of records in the least amount of time.
Manage invalid characters	Manage invalid characters
Retrieve specific columns for a table via query APIs	Queries submitted to retrieve data should include specific columns in the ColumnSet instance associated to the query rather than All Columns.

See also

Work with data using code in Dataverse (Power Apps)