Finance | Project Operations, Human Resources, ...

No Row Headers after exporting Entity Store to Azure Data Lake Gen 2

Like (0) Share

Report

Posted on 30 Oct 2019 21:39:34 by Goloknath

Hi everyone,

After successfully exported the aggregate measurements from my D365 Finance and Operations to Azure Data Lake Gen 2 i can get all the .csv files from every cubes. Unfortunatly its exported without column header names in all these csv files.

As you can see in the image below, it exported only the nummers which represent the column header names.

Any suggestions how to get the column header names?

All responses (10)

Answers (0)

Ambika 5 on 18 May 2023 at 07:45:09

Like (0)

Report

RE: No Row Headers after exporting Entity Store to Azure Data Lake Gen 2

Hi All ,

We are also facing the same issue, where the column headers are missing and we need this info for a integration with 3rd party reporting tool .Let me know if there a solution .

Thank you ,

Ambika
Rabin25 5 on 11 May 2023 at 18:16:39

Like (0)

Report

RE: No Row Headers after exporting Entity Store to Azure Data Lake Gen 2

Were you able to find any solution for this? I am trying to consume data from a csv file in ADL Gen2 using Data Factory but the file does not contain headers. There is a CDM.json file in data lake which contains headers, but does anybody know how to use the json file in a pipeline to just retrieve the headers and map them to the sink dataset?
Suggested answer

Shalaby 5 on 21 Dec 2022 at 16:08:35

Like (0)

Report

RE: No Row Headers after exporting Entity Store to Azure Data Lake Gen 2

If you want to build a PowerBI report based on these files then this described solution is for you

My objective was to create a report out of few D365 Marketing app tables.

Extract using an Azure Synapse Link was done and the data started to appear in the specified Azure Storage Gen2.

My next step was to create a Dataflow that pulls the CSV files and combine them together in one table.

When creating the Dataflow, if you used the first data view option file system view, that's when you will find the files as multiple CSV files that need to be combined and non of them posses column headers. However when you choose CDM folder view, that's when the contents of every group of CSV files belonging to the same extract will come together as one table with headers and data types correctly shown
RaoP 5 on 24 May 2022 at 11:18:23

Like (0)

Report

RE: No Row Headers after exporting Entity Store to Azure Data Lake Gen 2

Hi,Have you tried this and is it workout?

I am also facing same issue.
speedracer0101 10 on 05 Apr 2021 at 17:24:51

Like (0)

Report

RE: No Row Headers after exporting Entity Store to Azure Data Lake Gen 2

I am having the same issue here... 200+ columns with no headers... the thing is JSON file is, yes that does match what's in the csv file but the file is generated and there is no way to retain the column header info in the future generated csv file.

What was microsoft thinking to dump the files without column headers??? it's totally useless
Goloknath on 21 Feb 2021 at 15:58:24

Like (0)

Report

RE: No Row Headers after exporting Entity Store to Azure Data Lake Gen 2

Model.json is automatically created when exporting data to Data Lake, are you saying we should edit the Json file and set headercolumn to true to get the header in the next refresh?
Suggested answer

PBerg 10 on 24 Feb 2020 at 18:54:55

Like (0)

Report

RE: No Row Headers after exporting Entity Store to Azure Data Lake Gen 2

Thank you very much! This is correct!
Sergei Minozhenko 23,091 on 24 Feb 2020 at 17:57:35

Like (0)

Report

RE: No Row Headers after exporting Entity Store to Azure Data Lake Gen 2

Hi PBerg,

If i understand correctly metadata should be defined in model.json file for CDM folder.

docs.microsoft.com/.../data-lake
PBerg 10 on 24 Feb 2020 at 16:04:51

Like (0)

Report

RE: No Row Headers after exporting Entity Store to Azure Data Lake Gen 2

Did you ever find a solution for this?
Suggested answer

Rahul Mohta 21,014 on 31 Oct 2019 at 05:46:11

Like (0)

Report

RE: No Row Headers after exporting Entity Store to Azure Data Lake Gen 2

see if there is any help in this link

https://community.dynamics.com/ax/b/happyd365fo/posts/adl-for-entity-store-in-customer-owned-adl-with-microsoft-dynamics-365-finance-and-operations-one-version