GuruGroup logo
Enterprise Cloud & Big Data

D365 F&O Azure Data Lake Integration

Executive Summary & Key Architectural Takeaways
  • Near-Real-Time Data Streaming: Exporting operational D365FO tables to Azure Data Lake Storage (ADLS) Gen2 using Change Data Capture (CDC).
  • Common Data Model (CDM) Standards: Organizing enterprise entity files into structured, self-describing CDM folder hierarchies.
  • Cost-Effective Analytics: Replacing costly relational BYOD SQL databases with petabyte-scale cloud data lake storage.
  • LCS Add-In Architecture: Provisioning and managing the Export to Data Lake microservice directly via Lifecycle Services.
  • Downstream BI Enablement: Querying data lake entities seamlessly via Azure Synapse serverless SQL pools and enterprise Power BI datasets.

Overview: Enterprise Data Lake Architecture

In this post, we will review the integration between Dynamics 365 Finance & Operations and Azure Data Lake. We will explore how to configure the Data Lake feature, activate synchronization for tables and entities, understand how data is stored in Data Lake Gen2 storage, and access this data using Azure Synapse Analytics and Power BI.

Azure Data Lake Gen2 Architecture
Figure 1: Architectural pipeline linking D365FO microservices with ADLS Gen2 storage.

“Export to Azure Data Lake fundamentally decouples analytics from transactional ERP databases, enabling near-real-time Power BI reporting with zero impact on operational user performance.”

— Aamir Khan, Power Platform & Dynamics Lead

Common Data Model (CDM) Folder Structure

Data is stored in Data Lake to comply with the Common Data Model (CDM) folder standard. The hierarchical namespace organizes objects and CSV files into a structured directory tree for high-performance analytics:

CDM Folder Structure Hierarchy
Figure 2: CDM folder layout structuring entities and partitions in Azure storage.

Configuring the Data Lake Add-In in LCS

Integration with Azure Data Lake is delivered as an add-in installable from Microsoft Dynamics Lifecycle Services (LCS). Under environment management, install the Export to Data Lake add-in and bind your Azure KeyVault and Storage Account:

LCS Environment Add-ins
Figure 3: Installing the Data Lake add-in within Lifecycle Services.
Configuring KeyVault and Storage in LCS
Figure 4: Binding Azure KeyVault credentials and Data Lake storage account.

Activating Table Synchronization in D365FO

Open D365FO and navigate to System administration > Setup > Export to Data Lake. Select the database tables and data entities you wish to synchronize, and click Activate:

Export to Data Lake Form in D365FO
Figure 5: Selecting and activating database tables in the Export to Data Lake setup form.
Monitoring Table Sync Status
Figure 6: Real-time synchronization status monitoring for active tables.

Consuming Data in Azure Synapse & Power BI

Once data flows into your storage container, open Azure Synapse Analytics Studio. Serverless SQL pools allow you to query the CDM folders directly using standard T-SQL, without provisioning expensive dedicated database instances:

Querying CDM Folders in Azure Synapse
Figure 7: Executing T-SQL queries over data lake folders in Azure Synapse Studio.
Power BI Dashboard Connected to Data Lake
Figure 8: High-performance Power BI executive dashboard powered by Data Lake storage.
Ready to Move Forward?

Turn Your Business Goals into Measurable Results

Partner with Guru Group to design, deliver, and scale secure technology solutions for your organization.