Citizen AI with the Power Platform

Machine Learning
Microsoft Power Platform
Power Apps
Power Automate
Power BI

The architecture below extends on the Analytics end-to-end with Azure Synapse scenario. It allows for a custom ML model to be trained in Azure Machine Learning, and implemented with a custom application built using Microsoft Power Platform.


A diagram that demonstrates the architecture for citizen AI with Microsoft Power Platform.

Download a Visio file of this architecture.


1 - Ingest: Use Azure Synapse pipelines to pull batch data from a wide variety of sources, both on-premises and in the cloud. This is a Lambda Architecture with two data ingestion flows (streaming and batch).

  • Streaming: At the top of the architecture diagram is presented the streaming data flows (e.g. Big data streams and IoT Devices).
    • You can use Azure Event Hubs or Azure IoT Hub to ingest data streams generated by client applications or IoT devices. Event Hubs or IoT Hub ingests and stores streaming data, preserving the sequence of events received. Consumers can connect to hub endpoints to retrieve messages for processing.
  • Batch: At the lower half of this architecture, there is a variety of data being ingested and processed in batches such as:
    • Unstructured data (e.g. video, images, audio, free text)

    • Semi-structured data (e.g. json, xml, csv, logs)

    • Structured data (e.g. relational databases, Azure Data Services)

      Azure Synapse Link creates a tight seamless integration between Azure Cosmos DB and Azure Synapse Analytics. Azure Synapse Pipelines can be triggered based on a pre-defined schedule or in response to an event. They can also be invoked by calling REST APIs.

2 - Store: Ingested data can be landed directly in raw format and then transformed on the Azure Data Lake. Data once curated and transformed to relational structures can be presented for consumption in Azure Synapse Analytics.

3,4 - Train and deploy model: Azure Machine Learning provides an enterprise-grade ML service for building and deploying models faster. It provides users at all skill levels with a low-code designer, automated ML, and a hosted Jupyter notebook environment. Models can be deployed either as real-time endpoints on Azure Kubernetes Service, or as a Machine Learning managed endpoint. For batch inferencing of ML models, you can use Machine Learning pipelines.

5,6 - Consume: A model—either batch or real-time—published in Machine Learning can generate a REST endpoint that can be consumed in a custom application built using the low-code Power Apps platform. You can also call a real-time Machine Learning endpoint from a Power BI report to present predictions in business reports.


Both Machine Learning and Power Platform stack have a range of built-in connectors to help ingest data directly. These may be useful for a one-off minimum viable product (MVP). However, the Ingest and Store sections of the architecture advise on the role of standardized data pipelines for the sourcing and storage of data from different sources at scale – patterns that are typically implemented and maintained by the enterprise data platform teams.


Power Platform services

  • Microsoft Power Platform: A set of tools for analyzing data, building solutions, automating processes, and creating virtual agents. It includes Power App, Power Automate, Power BI, and Power Virtual Agents.
  • Microsoft Power Apps: A suite of apps, services, connectors, and data platform. It provides a rapid application development environment to build custom apps for your business needs.
  • Microsoft Power Automate: A service that helps you create automated workflows between your favorite apps and services. Use it to synchronize files, get notifications, collect data, and so on.
  • Microsoft Power BI: A collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights.

Azure services

  • Azure Machine Learning: An enterprise-grade ML service for building and deploying models quickly. It provides users at all skill levels with a low-code designer, automated ML, and a hosted Jupyter notebook environment to support your own preferred IDE of choice.
  • Machine Learning managed endpoints: Online endpoints that enable you to deploy your model without having to create and manage the underlying infrastructure.
  • Azure Kubernetes Service: Machine Learning has varying support across different compute targets. Azure Kubernetes Service is one such target, which is a great fit for enterprise grade real-time model endpoints.
  • Azure Data Lake: A Hadoop compatible file system. It has an integrated hierarchical namespace and the massive scale and economy of Azure Blob Storage.
  • Azure Synapse Analytics: A limitless analytics service that brings together data integration, enterprise data warehousing, and big data analytics.
  • Azure Event Hubs and Azure IOT Hub: Both services ingest data streams generated by client applications or IoT devices. They then ingest and store streaming data, preserving the sequence of events received. Consumers can connect to the hub endpoints to retrieve messages for processing.

Platform services

To improve the quality of your Azure solutions, follow the recommendations and guidelines in the Azure Well-Architected Framework. The framework consists of five pillars of architectural excellence:

  • Cost Optimization
  • Operational Excellence
  • Performance Efficiency
  • Reliability
  • Security

To create a design that respects these recommendations, consider the following services:

  • Azure Active Directory: Identity services, single sign-on, and multifactor authentication across Azure workloads.
  • Azure Cost Management and Billing: Financial governance over your Azure workloads.
  • Azure Key Vault: Secure credential and certificate management.
  • Azure Monitor: Collection, analysis, and display of telemetry from your Azure resources. Use Monitor to proactively identify problems, to maximize performance and reliability.
  • Microsoft Defender for Cloud: Strengthen and monitor the security posture of your Azure workloads.
  • Azure DevOps & GitHub: Implement DevOps practices to enforce automation and compliance of your workload development and deployment pipelines for Azure Synapse and Machine Learning.
  • Azure Policy: Implement organizational standards and governance for resource consistency, regulatory compliance, security, cost, and management.


An ML minimum viable product (MVP) benefits from speed to outcome. In some cases, the needs of a custom model can be met by pre-trained Azure Cognitive Services or Azure Applied AI Services. In others, Power Apps AI Builder may provide a fit for purpose model.

Scenario details

A general technology trend is the growing popularity of citizen AI roles. Such roles are business practitioners looking to improve business processes through the application of machine learning (ML) and AI technologies. A significant contributor to this trend is the growing maturity and availability of low-code tools to develop ML models.

With a well-known high failure rate to such initiatives, the ability to rapidly prototype and validate an AI application in a real-world setting becomes a key enabler to a fail fast approach. There are two key tools for developing models that modernize processes and drive transformative outcomes:

  • An ML toolkit for all skill levels
    • Supports no-code to fully-coded ML development
    • Has a flexible, low-code GUI
    • Enables users to rapidly source and prep data
    • Enables users to rapidly build and deploy models
    • Has advanced, automated ML capabilities for ML algorithm development
  • A low-code application development toolkit
    • Enables users to build custom applications and automation workflows
    • Creates workflows so that consumers and business processes can interact with an ML model

Azure Machine Learning fulfills the role of a low-code GUI for ML development. It has automated ML, and deployment to batch or real-time endpoints. Microsoft Power Platform, which includes Microsoft Power Apps and Microsoft Power Automate, provides the toolkits to rapidly build a custom application and workflow that implements your ML algorithm. End business users can now build production grade ML applications to transform legacy business processes.

Potential use cases

These toolkits minimize the time and effort needed to prototype the benefits of an ML model on a business process. You can easily extend a prototype to a production grade application. The uses for these techniques include:

  • Manufacturing Ops with legacy applications that use outdated deterministic predictions. Such situations can benefit from the improved accuracy of an ML model. Proving improved accuracy requires both a model and development effort to integrate with legacy systems on-premises.
  • Call Center Ops with legacy applications that don't adjust when data drifts. Models that automatically retrain may provide a significant uplift in churn prediction or risk profiling accuracy. Validation requires integration with existing customer relationship management and ticket management systems, and integration could prove expensive.


When you use these services to create a proof of concept or MVP, you're not done. There's more work to make a production solution. Frameworks such as the Azure Well-Architected Framework provide reference guidance and best practices to apply to your architecture.


Most of the components used in this example scenario are managed services that will automatically scale. The availability of the services used in this example varies by region.

Apps based on ML typically require one set of resources for training and another for serving. Resources required for training generally don't need high availability, as live production requests don't directly hit these resources. Resources required for serving requests need high availability.


DevOps practices are used to orchestrate the end-to-end approach used in this example. If your organization is new to DevOps, the DevOps Checklist can help you get started.

The Machine Learning DevOps Guide presents best practices and learnings on adopting ML operations (MLOps) in the enterprise with Machine Learning.

DevOps automation can be applied to the Power Platform solution provided in this example. For more information about Power Platform DevOps, see Microsoft Power Platform Build Tools for Azure DevOps - Power Platform.

Cost optimization

Cost optimization is about looking at ways to reduce unnecessary expenses and improve operational efficiencies. For more information, see Overview of the cost optimization pillar.

Azure pricing: First party Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS) services on Azure use a consumption-based pricing model. They don't require a license or subscription fee. In general, use the Azure pricing calculator to estimate costs. For other considerations, see Cost Optimization in the Well-Architected Framework.

Power Platform pricing: Power Apps, Power Automate and Power BI are software-as-a-service (SaaS) applications and have their own pricing models, including per app plan, and per user.

Deploy this scenario

Consider this business scenario: a field agent uses an app that estimates a car's market price. You can use Machine Learning to quickly prototype an ML model of this app. You use a low-code designer and ML features to create the model, and then deploy it as a real-time REST endpoint.

The model may prove the concept, but a user has no easy way to consume a model implemented as a REST API. Power Platform can help close this last mile, as represented below.

Screenshot showing an ML model that's created in Machine Learning. The model obtains car data from Azure Data Lake, and it provides inferences to an endpoint.

Here's a user interface for the app, created in Power Apps by using the low-code interface that Power Apps provides.

A UI screenshot that shows various controls, such as buttons and drop-down lists, for the user to enter car data. The app predicts a price and displays it when the user selects the Predict button.

You can use Power Automate to build a low-code workflow to parse the user's input, pass it to the Machine Learning endpoint, and retrieve the prediction. You can also use Power BI to interact with the Machine Learning model and create custom business reports and dashboards.

Architecture showing schematic of the workflow.

To deploy this end-to-end example, follow step by step instructions using this sample Power App.

Extended scenarios

Deploy to Microsoft Teams

The sample app provided in the example above can also be deployed to Microsoft Teams. Teams provides a great distribution channel for your apps and provides your users with a collaborative app experience. For more information about deploying a Power Apps to Teams, see Publish your app using Power Apps app in Teams - Power Apps.

Consume the API from multiple apps and automations

In this example, we configure a Power Automate cloud flow to consume the REST endpoint as an HTTP action. We can instead set up a custom connector for the REST endpoint and consume it directly from Power Apps or from Power Automate. This approach is useful when we want multiple apps to consume the same endpoint. It also provides governance by using the connector DLP policy in Power Platform admin center. To create a custom connector, see Use a custom connector from a Power Apps app. For more information on Power Platform connector DLP, see Data loss prevention policies - Power Platform.


This article is maintained by Microsoft. It was originally written by the following contributors.

Principal author:

Next steps