Build Dataverse data models
Unlock the complete study guide.
Bundled into the existing Building Intelligent Applications premium course — no separate purchase.
14-day refund guarantee on one-time purchases and your first subscription charge.
Included in this chapter:
- Model business data as related tables
- Create and edit tables in the data workspace
- Table types and ownership
- Table properties and capabilities
- Alternate keys
- Duplicate detection rules
- Column basics: names, data types and settings
- Text and number data types
- Choice, date, lookup and file data types
- One-to-many and many-to-many relationships
- Relationship behavior: actions, behaviors and presets
- Inherited-access cleanup
- Prompt columns: setup, inputs and testing
- How prompt columns run and report status
- Row summaries
- Public and system views
- Configure Dataverse search through the Quick Find view
- Main forms
- Security roles, privileges and access levels
- Business units
- Teams
- Hierarchy security
- Column-level security
- Moving security to another environment
- Dataverse tables, columns, relationships, views and security by requirement
Dataverse table types: Standard vs Activity vs Virtual vs Elastic
| Criterion | Standard | Activity | Virtual | Elastic |
|---|---|---|---|---|
| Where the rows live | Dataverse | Dataverse | An external source, read at runtime | Dataverse, powered by Azure Cosmos DB |
| Choose it when | Most business data | Calendar-style work with a subject and time dimensions (calls, appointments) | Records must remain in the external system | Very large datasets (tens of millions of rows) at high throughput |
| Limits and contrasts | Ownership is fixed at creation, as for every table type | Owned only by a user or team; primary name column is always Subject | Importing a file instead would create a separate stored copy | Not the default: Standard is the type for most tables |
Decision tree
Cheat sheet
Unlock with Premium — includes all practice exams and the complete study guide.
References
- https://learn.microsoft.com/en-us/troubleshoot/microsoft-365-apps/access/database-normalization-description
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/create-edit-entity-relationships
- https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/ab-410
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/create-edit-entities
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/create-edit-field-solution-explorer
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/types-of-fields
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/types-of-entities
- https://learn.microsoft.com/en-us/power-platform/admin/wp-security-cds
- https://learn.microsoft.com/en-us/power-platform/admin/manage-dataverse-auditing
- https://learn.microsoft.com/en-us/power-apps/mobile/setup-mobile-offline
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-alternate-keys-reference-records
- https://learn.microsoft.com/en-us/power-platform/admin/set-up-duplicate-detection-rules-keep-data-clean
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/create-edit-field-portal
- https://learn.microsoft.com/en-us/power-apps/user/advanced-find
- https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/rich-text-editor-control
- https://learn.microsoft.com/en-us/dotnet/api/microsoft.xrm.sdk.metadata.memoformatname
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/autonumber-fields
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-entity-lookup
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/create-edit-nn-relationships
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/create-edit-nn-relationships-portal
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/prompt-column
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/configure-form-row-summary
- https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/create-edit-views
- https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/specify-default-views
- https://learn.microsoft.com/en-us/power-platform/admin/configure-relevance-search-organization
- https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/create-and-edit-forms
- https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/design-considerations-main-forms
- https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/add-move-or-delete-tabs-on-form
- https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/add-move-or-delete-fields-on-form
- https://learn.microsoft.com/en-us/power-platform/admin/security-roles-privileges
- https://learn.microsoft.com/en-us/power-platform/admin/database-security
- https://learn.microsoft.com/en-us/power-apps/developer/data-platform/businessunit-entity
- https://learn.microsoft.com/en-us/power-platform/admin/manage-teams
- https://learn.microsoft.com/en-us/power-platform/admin/about-team-templates
- https://learn.microsoft.com/en-us/power-platform/admin/hierarchy-security
- https://learn.microsoft.com/en-us/power-platform/admin/field-level-security
- https://learn.microsoft.com/en-us/power-platform/alm/overview-alm