Exporting D365 F&O Data Directly to Azure Data Lake Gen2 Without Dataverse

(3) Share

Report

Posted on by H.Hassan

Hi Everyone,

I’m currently working on exporting all tables/entities from Dynamics 365 Finance and Operations (Tier 2 environment) directly to Azure Data Lake Gen2. I don’t want to use Dataverse in between.

I’ve already created a Storage Account in Azure (StorageV2 with Hierarchical namespace enabled), but I’m running into confusion about what options to enable and how to proceed, especially since the older "Export to Data Lake" feature has been deprecated as of March 2025.

My Questions:

1 Is it still possible to export D365 F&O tables/entities directly to Azure Data Lake Gen2 without using Dataverse?
If yes, what is the current Microsoft-supported method to do this?
So far, I see that the new "Azure Synapse Link" only shows Dataverse tables, not F&O entities. How can I configure it for F&O?

Uploaded image: No description set. image.png

2 Is it possible to export data in a different format like Parquet instead of CSV?
Right now, the default output seems to be CSV with headers defined in a model.json.

Can I choose Parquet format specifically for certain tables?
Does Synapse Link or another option support exporting D365 F&O data in Parquet format or Delta Lake format in a structured schema?

3 Can we customize the folder structure created in Azure Data Lake Gen2?
The folder hierarchy seems to be predefined (e.g., Year/Month/Day/TableName).

Is this folder structure fixed by Microsoft?
If not, where and how can I customize it?

Any guidance or latest best practices would be highly appreciated!

Thanks in advance

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (0)

André Arnaud de Cal... 303,716 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Moved the question from the Dynamics 365 General to the Dynamics 365 Finance forum.

Was this reply helpful? Yes No
André Arnaud de Cal... 303,716 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi H.Hassan,

I will try to answer your questions

1. F&O tables should be visible in case this Power Platform environment is linked to your F&O instance. There is another pre-requisite that the data lake should be freshly created and not have other data already.

2. Using spark pool, you can enable parquet, but this will also have additional costs involved.

3. Not sure if this is possible or not. Have you checked the Synapse workspace settings?

Was this reply helpful? Yes No
H.Hassan 85 on at

Like (1)

Report
Copy link

Link copied!
André Arnaud Thanks for your reply

1: Yes, the Power Platform environment is linked to this Finance and Operations (F&O) instance, and the Data Lake was newly created.

I can now see the F&O tables that part is working as expected.

I’m now looking into whether it’s possible to access all data entities (not just tables) in the same way. Just like how the F&O tables are currently appearing, I was wondering if data entities can also be made available,

When I click on Azure Synapse Link in Power Apps, it first prompts me to configure Dataverse in this environment.
so, I’m looking to clarify:
Is it now a mandatory requirement to configure Dataverse first in order to send F&O tables to Azure Data Lake?
Specifically:

Do the tables/entities from F&O need to be sent to Dataverse first (possibly using Dual-write)?

And only then does Azure Synapse Link work to export the data to Azure Data Lake?

I’m looking for an official Microsoft statement or documentation that clearly states whether this is now required.
In short, I want to send F&O tables directly to Azure Data Lake without using Dataverse in between.
Previously, there was an “Export to Data Lake” feature available in D365 F&O, but since that has been deprecated, I want to know:
What is now the official and recommended approach to send F&O data directly to Azure Data Lake, without Dataverse?

2: Okay, thanks. I’ll look into it. Using a Spark pool, I understand that Parquet format can be enabled.

3: Yes, I have added the Synapse workspace settings, but when I try to link an F&O table, I receive the following error:

Was this reply helpful? Yes No