Azure Data Flow utf-8 bom is wrong.

CHEN XIAOJIE 96

User's image

I want to export a csv file with BOM like above. But I get the file without BOM like below. Using hexdump to check:

% head -c3 ../2023-04-09.csv | hexdump -C
00000000  64 61 74                                          |dat|
00000003

Using SubLime to check:

enter image description here

KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2023-04-26T06:31:15.18+00:00

Hi @CHEN XIAOJIE , Thanks for using Microsoft Q&A forum and posting your query.

I was able to reproduce the issue and noticed the same behavior. Looks like the issue is only with dataflow and not copy activity. I just tested with both copy activity and dataflow to ensure if the issue with dataset level or the issue with dataflow. And my tests confirmed the issue is with dataflow.

I'm escalating this to respective product owners and will keep you posted as I hear back from the team.

We appreciate your patience. Thank you
KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2023-04-29T01:28:52.37+00:00

@CHEN XIAOJIE Wanted to let you know that I have already escalated this to our internal team and waiting to hear back from them. Will keep you posted as soon as I hear back from them.

Thank you