AX Diary | D365 F&O

Real business use cases and end-to-end solution designs combining D365 F&O with Power Platform and AI · 12 min read TL;DR: Connect Copilot Studio agents directly to Dynamics 365 SCM using the new dynamic Model Context Protocol (MCP) server to automate heavy machinery diagnostics, inventory checks, and maintenance order creation. D365 F&O Copilot & AI Supply Chain Integration Architecture Maintaining heavy industrial machinery demands rapid dispatch, immediate spare-parts availability checks, and strict maintenance order logging without forcing technicians into dense ERP client forms. By bridging Microsoft Copilot Studio agents with Dynamics 365 Supply Chain Management using the dynamic ERP Model Context Protocol (MCP) server and Microsoft Dataverse, you can empower field engineers to triage equipment faults, query serialized asset telemetry, and post maintenance requests conversationally. In this guide, you will learn how to architect and implement an autonomous hea...

Reporting and analytics · 12 min read TL;DR: Bridge Dynamics 365 Finance with Power BI using Direct Lake and the Model Context Protocol (MCP) to automate semantic model generation and deliver governed natural language financial reporting via Fabric IQ. D365 F&O Finance Power BI Reporting Architecture Enterprise finance teams running Dynamics 365 Finance often face a critical bottleneck: extracting millions of general ledger records into external reporting tools without crippling ERP transactional performance or introducing stale data silos. Traditional approaches—such as periodic Data Management Framework (DMF) exports, Bring Your Own Database (BYOD), or heavy OData feeds—introduce data lag and rigid modeling overhead. By combining the Dataverse Link to Microsoft Fabric with the latest Power BI Model Context Protocol (MCP) servers and Fabric IQ, architects can now deploy a Direct Lake financial reporting engine that automates semantic modeling and empowers conversational AI...

Architecture, integration and automation · 14 min read TL;DR: Combine Dynamics 365 Finance ledger data in OneLake with Microsoft Fabric User Data Functions to run serverless Python logic and statistical models directly from T-SQL stored procedures without external orchestration pipelines. D365 F&O Finance Architecture Integration Reporting Extracting real-time, non-linear financial intelligence from Dynamics 365 Finance often forces architecture teams to choose between inflexible T-SQL calculations and complex external ETL orchestration. By combining D365 F&O data landed in OneLake with Microsoft Fabric items and Fabric User Data Functions (preview), you can execute Python-driven algorithms across pipelines, notebooks, and REST endpoints. This guide demonstrates how to architect serverless, in-engine statistical analysis, currency anomaly detection, and automated alerting without provisioning external Azure Functions or Azure Data Factory pipelines. 📖 In this article ...