Our solution demonstrates how multiple Microsoft Cloud APIs can be combined into a single, event-driven architecture, with Dynamics 365 Finance & Operations (FO) acting as the production system of record.

The flow starts when a production order is created in D365 FO. FO exposes the order through its OData / Business Events APIs, which are consumed by an Azure Function. This serverless component validates and transforms the data, ensuring the core ERP system remains isolated from downstream processing.

From the Azure Function (dataverse API), the production event is published to Azure Event Hub, using Azure’s native messaging APIs. Event Hub enables reliable, scalable streaming and decouples FO from consumers, allowing the architecture to grow without impacting the ERP system.

The streamed events are then ingested by Microsoft Fabric, where data pipelines process the production data in near real time. Fabric acts as the central data and analytics layer, feeding insights to Power BI dashboards and triggering actions in the Power Platform. In some scenarios, enriched data can also be written back to D365 FO through its APIs, closing the loop.

By combining 1) Dynamics 365 FO APIs, 2) Dataverse API and Event Hub APIs, and 3) Microsoft Fabric and Power BI APIs, this architecture shows how Microsoft cloud services can work together. earning its place on the Stairway to Heaven.