Data Mapping and Integration from D365

(0) Share

Report

Posted on by AB-27040918-1

Hi,

I have my data in a CSV file and my column names corresponding to my data are inside the JSON file (Both are in D365 FnO). I need to map the column names along with the data, so that I can utilize in Microsoft Fabric.

Any assistance on this will be highly helpful.

Can I also get some assistance on Data Entity Framework regarding the same, to work on it.

I have the same question (0)

All responses (3)

Answers (0)

Sort by

André Arnaud de Cal... 304,580 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Ashwath,

Can you explain more about this scenario? Why do you have a CSV and JSON file in Dynamics 365 if you need it for reporting? Why don't you have the files in e.g. OneLake? What exact assistance do you need here?

Was this reply helpful? Yes No
Kevin Xia Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi,

You can use the Data Entity Framework for data mapping and integration. Here is a possible approach:

First, create a data entity framework that describes the data structure in the CSV file along with the corresponding column names.

Create a data entity framework mapping that maps the column names from the JSON file to fields in the data entity framework.

Import the CSV file and use the data entity framework mapping to automatically match the column names with the data.

In Microsoft Fabric, you can then access and utilize the data using the mapped data entity framework.

Best regards,

Kevin

Was this reply helpful? Yes No
AB-27040918-1 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can I get some assistance on Data Entity Framework regarding the same, to work on it.

Was this reply helpful? Yes No