Forum Discussion
Advocate IIPower BI Dataflow ADLS 2 storage and csv header
Hi,
Just checking with those who have enabled ADLS 2 storage for their dataflows. Do the csv snapshot file have the headers with column names in the first row?
For the dataflows stored by Microsoft in their internal storage, the csv files do not contain column headers. So, if the csv needs to be shared with other tools like data factory we need to provide the column headers separately.
Hi prathyoo ,
According to Step 9 in the official document , after the file is automatically detected as CSV, the column names are changed as "Column1 ,Column2,...."
In this case, you need to manually change names by double-clicking the headers.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi prathyoo ,
According to Step 9 in the official document , after the file is automatically detected as CSV, the column names are changed as "Column1 ,Column2,...."
In this case, you need to manually change names by double-clicking the headers.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.