Create a Common Data Service database
You can create a database and build apps by using Common Data Service as a data store. You can either create your own custom entities or use the predefined entities. To create a database, you first need to either create an environment, or be assigned to an existing environment as an Environment Admin. In addition, you must be assigned the appropriate license. For information on purchasing a plan for using Common Data Service, see Pricing info.
There are various ways to create a database:
- In the Power Apps Admin center
- In the Entities pane of powerapps.com
For security reasons, we do not support creating a copy of the database for local use.
Create a database in the admin center
In the admin center, in the left navigation pane, click Environments.
Select the environment in which you want to create the database.
On the Details tab, click Create a database.
Choose currency and language to proceed with database creation.
Create a database in the Entities pane of Power Apps
On powerapps.com, expand the Data section and click or tap Entities in the left navigation pane.
Click Create Database to create the database.
Security model for the databases
When a database is created, the users who have environment roles assigned to them, will continue to maintain those privileges.
Users with Environment Admin role are now assigned to System Administrator role. Users with Environment Maker continue to possess the same role.
On creating the database, any security group assigned to Environment Admin or Environment Maker role will not be honored any more. Currently, assigning permissions in database, do not support Azure AD security group.
License and security permissions
To create a database, you must be an administrator in the selected environment, and the appropriate license must be assigned to you. From the environment, you can further configure security permissions for other users by using the Security tab. For more information, see Configure database security.
With the Microsoft Power Apps Common Data Model we collect and store custom entity and field names in our diagnostic systems. We use this knowledge to improve the Common Data Model for our customers. The entity and field names that Creators create help us understand scenarios that are common across the Microsoft Power Apps community and ascertain gaps in the service’s standard entity coverage, such as schemas related to organizations. The data in the database tables associated with these entities is not accessed or used by Microsoft or replicated outside of the region in which the database is provisioned. Note, however, the custom entity and field names may be replicated across regions and are deleted in accordance with our data retention policies. Microsoft is committed to your privacy as described further in our Trust Center.