|Business intelligence, app development, app connectivity, robotic process automation
Microsoft Power Platform is a line of business intelligence, app development, and app connectivity software applications. Microsoft developed the Power Fx low-code programming language for expressing logic across the Power Platform. It also provides integrations with GitHub and Microsoft Teams among other apps.
The Power Platform family of products includes:
Not to be confused with Dataverse.
Microsoft Dataverse, formerly known as Microsoft Common Data Service until November 2020, is a relational database engine offered by Microsoft as a cloud-based data management software as a service for storing business data. It is mainly a database with associated functionalities, and separates itself from on-premises solutions (for example Microsoft Access) in that a developer needs internet access to connect to Dataverse. It is mainly a tool for managing and storing data, and allows for creation and management of datasets through a single user interface.
Dataverse is marketed for use with other Microsoft products such as Power Apps and Microsoft Dynamics 365 applications, and has data connectors to other Microsoft products like Azure Event Hub, Azure Service Bus, Microsoft SQL and Azure Data Lake. One example of use could be to use Dataverse as a form of data lake together with Microsoft Power Apps. Dataverse is also available as a separate service for companies who want to develop their own solutions, and has integration capabilities to other systems through webhooks. Dataverse has APIs so that the data can be consumed by other services, like for example Power Platform services like Power BI or Power Apps, or by custom services designed in for example Visual Studio.
In addition to relational data, Dataverse also has support for file and blob storage, data lakes and semi-structured data. Dataverse is based on Microsoft's Common Data Model as its common data model and is built on Microsoft Azure SQL, where its physical data also is stored.
Dataverse has the possibility to apply business logic like duplicate detection, calculated fields, rollup fields and business rules. It can be used to discover, validate and report data, and has the possibility to use Microsoft's proprietary common data model. Access in MS Dataverse is handled with Azure Active Directory which has conditional access and multifactor authentication (MFA), and offers individual column and row level security.