web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Dynamics 365 data in A...

Finance | Project Operations, Human Resources, ...

Unanswered

Dynamics 365 data in ALDS to parquet format and Delta tables in Databricks

(1) Share

Report

Report

Posted on by MJ-24090752-0

6

Hi.

We need to pull the incremental data from dynamics 365 FnO to azure data lake. As per the MS documents we identified Synapse link for Dataverse is one of the option to push the incremental data into azure data lake.

We tried this option, however it push the data in csv format for data and for metadata it creates json files.

Also it creates different folders for each incremental loads.

Now problem is the reading the json and csv files using data factory will be challenging.

Therefore, I we are looking for a best option to read the D364 exported data from ADLS and convert them into delta tables or other tablular formats

All responses Img

All responses (1)

Answers Img

Answers (0)

Martin Dráb 240,815 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Using Parquet rather than CSV is not only supported by Synapse Link for Dataverse, but it's even recommended. Look for details in documentation, e.g. Export Dataverse data in Delta Lake format.

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 475 Most Valuable Professional

#2

André Arnaud de Cal... 399 Super User 2026 Season 2

#3

CU10121822-0 374

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans