Microsoft Power Platform is a collection of low-code development tools that allows users to build custom business applications, automate workflows, and analyze data. It also offers integration with

GitHub GitHub () is a Proprietary software, proprietary developer platform that allows developers to create, store, manage, and share their code. It uses Git to provide distributed version control and GitHub itself provides access control, bug trackin ...

Microsoft Azure Microsoft Azure, or just Azure ( /ˈæʒər, ˈeɪʒər/ ''AZH-ər, AY-zhər'', UK also /ˈæzjʊər, ˈeɪzjʊər/ ''AZ-ure, AY-zure''), is the cloud computing platform developed by Microsoft. It has management, access and development of ...

Microsoft Dynamics 365 Microsoft Dynamics 365 is a set of enterprise accounting and sales software products offered by Microsoft. Its flagship product, Dynamics GP, was founded in 1981. Applications Microsoft Dynamics is largely made up of products developed by co ...

, and

Microsoft Teams Microsoft Teams is a team collaboration platform developed by Microsoft as part of the Microsoft 365 suite. It offers features such as workspace chat, video conferencing, file storage, and integration with both Microsoft and third-party applicat ...

, amongst other Microsoft and third-party applications. 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 the Power Fx low-code

programming language A programming language is a system of notation for writing computer programs. Programming languages are described in terms of their Syntax (programming languages), syntax (form) and semantics (computer science), semantics (meaning), usually def ...

for expressing logic across the Power Platform.

Products

The Power Platform family of products includes: * Power BI, a business analytics tool for visualizing data through various charts, graphs, and dashboards. It competes with tools like

Tableau Tableau (French for 'little table' literally, also used to mean 'picture'; : tableaux or, rarely, tableaus) may refer to: Arts * ''Tableau'', a series of four paintings by Piet Mondrian titled '' Tableau I'' through to ''Tableau IV'' * '' Tableau ...

Spotfire TIBCO Spotfire is an artificial intelligence (AI)-based analytics platform. Before being acquired by TIBCO in 2007, Spotfire was a business intelligence company based in Somerville, Massachusetts. History Spotfire was co-founded by Christophe ...

or Qlikview. * Power Apps for low code custom business applications. * Power Automate ''(formerly Microsoft Flow)'' for business process automation and optimization. * Copilot Studio ''(formerly Power Virtual Agents)'' provides tools for customizing or building copilot, or AI-powered chatbot, experiences. * Power Pages, graphical software for making low-code websites. Formerly part of Power Apps as "Power Apps Portals" until 2022

Microsoft Dataverse

Microsoft Dataverse, formerly known as Microsoft Common Data Service until November 2020, is a

relational database A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A Relational Database Management System (RDBMS) is a type of database management system that stores data in a structured for ...

engine An engine or motor is a machine designed to convert one or more forms of energy into mechanical energy. Available energy sources include potential energy (e.g. energy of the Earth's gravitational field as exploited in hydroelectric power ge ...

What is Microsoft Dataverse? - Power Apps , Microsoft Docs
/ref> offered by Microsoft as a

cloud In meteorology, a cloud is an aerosol consisting of a visible mass of miniature liquid droplets, frozen crystals, or other particles, suspended in the atmosphere of a planetary body or similar space. Water or various other chemicals may ...

-based

data management Data management comprises all disciplines related to handling data as a valuable resource, it is the practice of managing an organization's data so it can be analyzed for decision making. Concept The concept of data management emerged alongsi ...

software as a service Software as a service (SaaS ) is a cloud computing service model where the provider offers use of application software to a client and manages all needed physical and software resources. SaaS is usually accessed via a web application. Unlike o ...

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 on Common Data Model principles and includes security features and productivity tools. Data could be imported, managed and exported out of Dataverse. Dataverse is built on Microsoft 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 and

applications, and has data connectors to other Microsoft products like Azure Event Hub, Azure Service Bus, Microsoft SQL and

Azure Data Lake Azure Data Lake is a scalable data storage and analytics service. The service is hosted in Azure, Microsoft's public cloud. History Azure Data Lake service was released on November 16, 2016. It is based on COSMOS, which is used to store and p ...

. One example of use could be to use Dataverse as a form of

data lake A data lake is a system or data repository, repository of data stored in its natural/raw format, usually object binary large object, blobs or files. A data lake is usually a single store of data including raw copies of source system data, sensor ...

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 via

webhook In web development, a webhook is a method of augmenting or altering the behavior of a web page or web application with custom callbacks. These callbacks may be maintained, modified, and managed by third-party users who need not be affiliated with ...

s. Dataverse has

API An application programming interface (API) is a connection between computers or between computer programs. It is a type of software interface, offering a service to other pieces of software. A document or standard that describes how to build ...

s 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 A common data model (CDM) can refer to any standardised data model which allows for data and information exchange between different applications and data sources. Common data models aim to standardise logical infrastructure so that related applica ...

as its

common data model A common data model (CDM) can refer to any standardised data model which allows for data and information exchange between different applications and data sources. Common data models aim to standardise logical infrastructure so that related applica ...

and is built on

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 rule A business rule defines or constrains some aspect of a business. It may be expressed to specify an action to be taken when certain conditions are true or may be phrased so it can only resolve to either true or false. Business rules are intended to a ...

s. It can be used to discover, validate and report data, and has the possibility to use Microsoft's proprietary

. Access in MS Dataverse is handled with

Microsoft Entra ID Microsoft Entra ID (formerly known as Microsoft Azure Active Directory or Azure AD) is a cloud-based identity and access management (IAM) solution. It is a directory and identity management service that operates in the cloud and offers authen ...

which has conditional access and multifactor authentication (MFA), and offers individual

column A column or pillar in architecture and structural engineering is a structural element that transmits, through compression, the weight of the structure above to other structural elements below. In other words, a column is a compression member ...

and

row-level security A data control language (DCL) is a syntax similar to a computer programming language used to control access to data stored in a database (authorization). In particular, it is a component of Structured Query Language (SQL). Data Control Language is ...

References

External links

*
Microsoft Power Platform documentation
{{Microsoft Power Platform Bundled products or services Business software Power Platform 2018 software Low Code Application Platform

Products

Microsoft Dataverse

See also

References

Further reading

External links