| Microsoft Power Platform | |
|---|---|
 | |
| Developer | Microsoft |
| Initial release | 2018; 7 years ago (2018) |
| Operating system | Microsoft Windows |
| Type | Business intelligence,app development,app connectivity,robotic process automation |
| License | Proprietary software |
| Website | microsoft |
Microsoft Power Platform is a collection oflow-code development tools that allows users to build custom business applications, automate workflows, and analyze data.[1][2] It also offers integration withGitHub,Microsoft Azure,Microsoft Dynamics 365, andMicrosoft Teams, amongst other Microsoft and third-party applications.[3]
Microsoft Power Platform enables users to streamline processes, gain insights from their data, and build custom solutions to meet their business needs. It is designed to be accessible to users with varying levels of technical expertise, making it easier for organizations to create custom applications and automate workflows.
Microsoft developed thePower Fxlow-codeprogramming language for expressing logic across the Power Platform.[4][5]
The Power Platform family of products includes:[2][6]
Microsoft Dataverse, formerly known asMicrosoft Common Data Service until November 2020, is arelational databaseengine[8] offered by Microsoft as acloud-baseddata managementsoftware as a service for storing business data. Dataverse is a data storage and management engine serving as a foundation for Microsoft’s Power Platform,Office 365 and Dynamics 365 apps. It decouples the data from the application, allowing an administrator to analyze and report on data in a centralized manner. It is based onCommon Data Model principles and includes security features and productivity tools. Data could be imported, managed and exported out of Dataverse. Dataverse is built onMicrosoft Azure. 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 andMicrosoft Dynamics 365 applications, and has data connectors to other Microsoft products like Azure Event Hub, Azure Service Bus,Microsoft SQL andAzure Data Lake. One example of use could be to use Dataverse as a form ofdata lake together with Microsoft Power Apps. Microsoft Dataverse is also offered as a standalone service for businesses looking to build custom data solutions with integration to external systems viawebhooks. Dataverse hasAPIs 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 exampleVisual Studio.
In addition to relational data, Dataverse also has support forfile andblob storage, data lakes andsemi-structured data. Dataverse is based on Microsoft'sCommon Data Model as itscommon data model and is built onMicrosoft Azure SQL, where its physical data also is stored.[citation needed]
Dataverse has the possibility to apply business logic like duplicate detection,calculated fields, rollup fields andbusiness rules. It can be used todiscover, validate and report data, and has the possibility to use Microsoft's proprietarycommon data model. Access in MS Dataverse is handled withMicrosoft Entra ID which hasconditional access andmultifactor authentication (MFA), and offers individualcolumn androw-level security.
Microsoft development tools | |||||||
|---|---|---|---|---|---|---|---|
| Development environments |
| ||||||
| Languages | |||||||
| APIs and frameworks |
| ||||||
| Database |
| ||||||
| Source control | |||||||
| Testing and debugging | |||||||
| Delivery | |||||||
