Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us at the 2025 Microsoft Fabric Community Conference. March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for $400 discount. Register now

Reply
ShivaniTyagi01
Frequent Visitor

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

‎11-22-2024 06:26 AM

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

 

Dataflows Gen2  

Labels:
Message 1 of 2
926 Views
0
1 ACCEPTED SOLUTION
NandanHegde
Super User
Super User

‎11-22-2024 06:52 AM

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




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

View solution in original post

Message 2 of 2
908 Views
1 REPLY 1
NandanHegde
Super User
Super User

‎11-22-2024 06:52 AM

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




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com
Message 2 of 2
909 Views

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebFBC_Carousel

Fabric Monthly Update - February 2025

Check out the February 2025 Fabric update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

View All
Top Solution Authors
View All