Notifications
Announcements
No record found.
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.
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 660 Most Valuable Professional
André Arnaud de Cal... 549 Super User 2025 Season 2
Sohaib Cheema 307 User Group Leader