Microsoft Power Platform

Family of business software products

Microsoft Power Platform

Developer(s)| 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.com/power-platform/

Microsoft Power Platform is a collection of low-code development tools that allows users to build custom business applications, automate workflows, and analyze data.[1][2] It also offers integration with GitHub, Microsoft Azure, Microsoft Dynamics 365, and Microsoft 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 the Power Fx low-code programming language for expressing logic across the Power Platform.[4][5]

## Products

[edit]

The Power Platform family of products includes:[2][6]

* Power BI, a business analytics tool for visualizing data through various charts, graphs, and dashboards. It competes with tools like Tableau,[1] Spotfire 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[7]

### Microsoft Dataverse

[edit]

Not to be confused with Dataverse.

Microsoft Dataverse, formerly known as Microsoft Common Data Service until November 2020, is a relational database engine[8] offered by Microsoft as a cloud-based data management software 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 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 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. Microsoft Dataverse is also offered as a standalone service for businesses looking to build custom data solutions with integration to external systems via 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.[citation needed]

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 Microsoft Entra ID which has conditional access and multifactor authentication (MFA), and offers individual column and row-level security.

## See also

[edit]

* List of Microsoft software
* Microsoft Office

## References

[edit]

1. ^ a b Novet, Jordan (2019-05-08). "Microsoft touted something called the Power Platform at its big event this week — here's what it is". CNBC. Retrieved 2021-03-20.
2. ^ a b Foley, Mary Jo (2019-01-18). "Why Microsoft's 'Power Platform' is one of its biggest bets for 2019 and beyond". ZDNet. Retrieved 2021-03-20.
3. ^ Bishop, Todd (2020-09-22). "As 'low-code' competition grows, Microsoft integrates Power Apps with GitHub and Teams". GeekWire. Retrieved 2021-03-20.
4. ^ Anderson, Tim (2021-03-02). "Excel-lent: Microsoft debuts low-code Power Fx language... but it is not really new". The Register. Retrieved 2021-03-14.
5. ^ Melanson, Mike (2021-03-06). "This Week in Programming: Microsoft's Power Fx 'Low Code' Language". The New Stack. Retrieved 2021-03-14.
6. ^ Krill, Paul (2020-05-25). "Microsoft: Power Platform is for real developers, too". InfoWorld. Retrieved 2021-03-20.
7. ^ "Announcing Microsoft Power Pages: Build secure, low-code websites". powerpages.microsoft.com. Retrieved 2023-02-02.
8. ^ What is Microsoft Dataverse? - Power Apps | Microsoft Docs

## Further reading

[edit]

* Rybaric, Robert (2020). Microsoft Power Platform Enterprise Architecture: A guide for architects and decision makers to craft complex solutions tailored to meet business needs. Packt Publishing. ISBN 978-1800204577.
* Pearson, Mitchell; Knight, Brian; Knight, Devin; Quintana, Manuel (2020). Pro Microsoft Power Platform: Solution Building for the Citizen Developer. Apress. ISBN 978-1484260074.
* Mendoza, Eickhel (2021). Microsoft Power Apps Cookbook: Become a pro Power Apps maker by applying practical use cases to solve ever-evolving business challenges. Packt Publishing. ISBN 978-1800569553.
* Gunnarsson, Ásgeir; Johnson, Michael (2020). Pro Microsoft Power BI Administration: Creating a Consistent, Compliant, and Secure Corporate Platform for Business Intelligence. Apress. ISBN 978-1484265666.
* Guilmette, Aaron (2020). Workflow Automation with Microsoft Power Automate: Achieve digital transformation through business automation with minimal coding. Packt Publishing. ISBN 978-1839213793.

## External links

[edit]

* Official website
* Microsoft Power Platform documentation

* v
* t
* e

Microsoft development tools

Development
environments|

| Visual Studio|

* Code
* Express
* Team System Profiler
* Tools for Applications
* Tools for Office

|

Others|

* Blend
* Expression Web
* FxCop
* GW-BASIC
* MACRO-80
* Macro Assembler
* MSBuild
* Pascal
* QuickBASIC
* QBasic
* QuickC
* Robotics Developer Studio
* Roslyn
* SharePoint Designer
* FrontPage
* Small Basic
* WebMatrix
* Windows App SDK
* Windows App Studio
* Windows SDK
* CLR Profiler
* ILAsm
* Native Image Generator
* WinDiff
* XAMLPad

Languages|

* Dynamics AX
* BASIC
* Visual Basic
* legacy
* VB.NET
* VBA
* VBScript
* Bosque
* Visual C++
* C++/CX
* C++/CLI
* Managed C++
* C++/WinRT
* C#
* C/AL
* Dafny
* Dexterity
* F#
* F*
* Visual FoxPro
* Java
* J++
* J#
* JavaScript
* TypeScript
* JScript
* IronPython
* IronRuby
* Lean
* P
* Power Fx
* PowerShell
* Project Verona
* Q#
* Small Basic
* VPL
* XAML

APIs and
frameworks|

| Native|

* Windows API
* Silverlight
* XNA
* DirectX
* Managed DirectX
* UWP
* Xbox Development Kit
* Windows Installer
* WinUI

|

.NET|

* ASP.NET
* Core
* AJAX
* Dynamic Data
* MVC
* Razor
* Web Forms
* ADO.NET
* Entity Framework
* MAUI
* CardSpace
* Communication Foundation
* Identity Foundation
* LINQ
* Presentation Foundation
* Workflow Foundation

Device drivers|

* WDK
* WDF
* KMDF
* UMDF
* Windows HLK
* WDM

Database|

| SQL Server|

* Express
* Compact
* Management Studio
* MSDE

|

SQL services|

* Analysis
* Reporting
* Integration
* Notification

Other|

* Visual FoxPro
* Microsoft Access
* Access Database Engine
* Extensible Storage Engine

Source control|

* Visual SourceSafe
* Team Foundation Version Control

Testing and
debugging|

* CodeView
* OneFuzz
* Playwright
* Script Debugger
* WinDbg
* xUnit.net

Delivery|

* Active Setup
* ClickOnce
* npm
* NuGet
* vcpkg
* Web Platform Installer
* Windows Installer
* WiX
* Windows Package Manager
* Microsoft Store

Category

* v
* t
* e

Microsoft Corporation

* History
* Outline

People|

| Founders|

* Bill Gates
* Paul Allen

|

Board of directors|

* Satya Nadella (Chairman and CEO)
* Reid Hoffman
* Hugh Johnston
* Teri List
* Catherine MacGregor
* Mark Mason
* Sandi Peterson
* Penny Pritzker
* Carlos A. Rodriguez
* Charles Scharf
* John W. Stanton
* Emma Walmsley

Senior leadership team|

* Satya Nadella (CEO)
* Takeshi Numoto (CMO)
* Scott Guthrie
* Carolina Dybeck Happe (COO)
* Amy Hood (CFO)
* Kevin Scott (CTO)
* Brad Smith (CLO)
* Harry Shum
* Phil Spencer
* Kathleen Hogan (CPO)

Corporate VPs|

* Joe Belfiore
* Richard Rashid (SVP)
* César Cernuda

Employee groups|

* Global LGBTQIA+ Employee & Allies at Microsoft
* Microsoft and unions

Products|

| Hardware|

* Azure Kinect
* HoloLens
* LifeCam
* Surface
* Duo
* Go
* Hub
* Laptop
* Laptop Go
* Neo
* Pro
* Studio
* Xbox

|

Software|

* Clipchamp
* Dynamics 365
* Havok
* Microsoft 365
* Office
* Teams
* Open source software
* Power Platform
* Servers
* Start
* Tay
* List of video games
* Visual Studio
* Visual Studio Code
* Windows
* Xbox OS

Programming
languages|

* BASIC
* VB.NET
* VBA
* VBScript
* Visual Basic
* C#
* C/AL a.k.a. Navision Attain
* F#
* MVPL
* Power Fx
* PowerShell
* Q#
* Transact-SQL
* TypeScript
* Visual J++
* Visual J#

Web properties|

* Azure
* Bing
* Copilot
* GitHub
* Learn
* Channel 9
* Developer Network
* TechNet
* LinkedIn
* LinkedIn Learning
* MSN
* Outlook.com
* Store
* Translator

Company|

| Conferences|

* Build
* Ignite
* Inspire
* MIX
* PDC
* WinHEC

|

Divisions|

* .NET Foundation
* Digital Crimes Unit
* Engineering groups
* Mobile
* Skype unit
* Gaming
* Activision Blizzard
* Xbox Game Studios
* ZeniMax Media
* Garage
* Outercurve Foundation
* Press
* Research
* Retail stores

Estates|

* Microsoft campus
* Microsoft India
* Microsoft Japan

Campaigns|

* "Where do you want to go today?" (1994)
* "Champagne" (2002)
* "Mojave Experiment" (2006)
* "I'm a PC" (2008)
* "Scroogled" (2012)

Criticism|

* Bundling of Microsoft Windows
* Clippy
* iLoo
* Internet Explorer
* Microsoft Bob
* _NSAKEY
* Windows
* XP
* Vista
* 10

Litigation|

* Apple v. Microsoft (1994)
* United States v. Microsoft (2001)
* Microsoft v. Lindows (2004)
* Microsoft v. MikeRoweSoft (2004)
* Microsoft v. Commission (2007)
* Alcatel-Lucent v. Microsoft (2009)
* Microsoft v. Shah (2011)
* Microsoft v. United States (2018)
* FTC v. Microsoft (2022)

Acquisitions|

* 6Wunderkinder
* Access Software
* Acompli
* Activision Blizzard
* acquisition
* Altamira Software
* AltspaceVR
* aQuantive
* Azyxxi
* Beam
* The Blue Ribbon SoundWorks
* Bungie
* Clipchamp
* Colloquis
* Compulsion Games
* Connectix
* Consumers Software
* Danger
* Double Fine
* Farecast
* FASA Studio
* Fast Search & Transfer
* Firefly
* Forethought
* GIANT Company Software
* GitHub
* Great Plains Software
* GreenButton
* Groove Networks
* Havok Group
* High Heat Major League Baseball
* Hotmail
* inXile Entertainment
* Jellyfish.com
* LinkedIn
* LinkExchange
* Lionhead Studios
* Maluuba
* Massive Incorporated
* Metaswitch
* Mobile Data Labs
* Mojang Studios
* Ninja Theory
* Nokia Devices and Services
* npm
* Nuance Communications
* Obsidian Entertainment
* Onfolio
* Pando Networks
* Perceptive Pixel
* PlaceWare
* Playground Games
* Powerset
* Press Play
* ProClarity
* Rare
* Revolution Analytics
* RiskIQ
* Simplygon
* Skype
* Sunrise Atelier
* SwiftKey
* TakeLessons
* Teleo
* Tellme Networks
* Twisted Pixel Games
* Undead Labs
* Vermeer Technologies
* Visio Corporation
* Vivaty
* VoloMetrix
* VXtreme
* WebTV Networks
* Winternals Software
* Xamarin
* Xandr
* AppNexus
* Yammer
* Yupi
* ZeniMax Media

* Category

*[v]: View this template
*[t]: Discuss this template
*[e]: Edit this template