Microsoft Dataverse is the central data platform of the Microsoft Power Platform and forms the backbone of modern business applications. For Swiss companies, Dataverse offers a secure, scalable, and compliance-compliant solution for data management.
What is Dataverse?
Dataverse is a cloud-based, relational database specifically designed for business applications. Unlike traditional SQL databases, Dataverse operates with a flexible data model consisting of tables, columns, and relationships that can be adjusted without programming knowledge. Standard tables such as contacts, companies, and activities are pre-configured and can be supplemented with custom tables. Relationships between tables—whether 1:n or n:n—are visually created in the Dataverse designer, allowing for complex data structures.
Integration with Power Apps and Power Automate
Dataverse is seamlessly integrated into the entire Power Platform. Power Apps directly accesses Dataverse tables and automatically generates forms and views. Power Automate uses Dataverse triggers to initiate workflows upon data changes—such as an approval for new entries. Dynamics 365 applications are also based on Dataverse, creating a unified data foundation for CRM, ERP, and custom apps.
Security Model and Permissions
The security model of Dataverse is particularly relevant for companies. It is based on business units, security roles, and column-level security. Administrators can granularly control which employees have access to which records. Row-level security ensures that users only see their own data or that of their department—a crucial advantage for compliance requirements.
Swiss Data Residency
For Swiss companies, data residency is a central issue. Microsoft operates two Azure data centers in Switzerland (Zurich and Geneva), where Dataverse data can be stored. This allows organizations to meet the requirements of the Swiss Data Protection Act (DSG) and industry-specific regulations. The data does not leave Switzerland—a clear advantage over international cloud providers without a local presence.
Conclusion
Dataverse is the ideal data foundation for Swiss companies that rely on the Power Platform. The combination of a flexible data model, granular security, and Swiss data residency makes Dataverse the first choice for compliance-critical business applications.