Microsoft Dataverse is the foundational data platform that powers Power Platform. It provides:
Enterprise data platform
- Managed database: Secure, cloud-based relational database with automatic backups
- Standard & custom tables: Pre-built business entities and custom table creation
- Relationships: One-to-many, many-to-one, and many-to-many relationships
- Business logic: Business rules, formula, calculated and rollup columns
- Data types: Rich data types including currency, datetime, file, and image
Integration capabilities
- Connectors: 1,000+ prebuilt connectors for popular services
- Custom connectors: Build connectors for any REST API
- Virtual tables: Access external data without replication
- Dual-write: Real-time synchronization with Finance & Operations apps
Security & governance
The same table looks different for every user: security roles decide which rows they see, column security decides which fields.
One table, three security roles
OpportunityOwnerBusiness unitValueMargin
Fleet renewalLien · BeneluxLienBenelux€ 120k ••
Service contractLien · BeneluxLienBenelux€ 45k ••
CRM rolloutTom · BeneluxTomBenelux€ 210k ••
Field devicesTom · BeneluxTomBenelux€ 78k ••
Portal upgradeClaire · FranceClaireFrance€ 95k ••
Copilot pilotClaire · FranceClaireFrance€ 38k ••
Rows visible to this user: 2/6Illustrative example
- Role-based security: Granular control at table, record, and field level
- Business units: Hierarchical data segmentation
- Auditing: Comprehensive change tracking and compliance reporting
- Data loss prevention: Policies to prevent data exfiltration
- Encryption: Data encryption at rest and in transit