topic Re: Convert .cns file read from sharepoint to .csv file extension in dataflow gen2 in Dataflow

Convert .cns file read from sharepoint to .csv file extension in dataflow gen2

ShivaniTyagi01 — Fri, 22 Nov 2024 14:26:31 GMT

Hi,

I am new to MS fabric. I have a requirement where I have got the data from my sharepoint folder and the files are in .cns format which is actually .csv format if you open the file. But the query is not reading the file . How should I convert the file from .cns to .csv in dataflow gen2 ?

Thanks,

Shivani Tyagi

Re: Convert .cns file read from sharepoint to .csv file extension in dataflow gen2

NandanHegde — Fri, 22 Nov 2024 14:52:44 GMT

Unfortunately, based on my understanding, Fabric Dataflow Gen 2 doesnt support this file extension to be read directly (so it wont be possible to convert it) via dataflow Gen 2.

You would have to do some custom coding for that conversion which you can achive via Fabric notebooks