Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Raph
Helper III
Helper III

Problem to load file data into a table

Hello

 

I am following the Microsoft learn path "Create a lakehouse" where is shows this easy step to create a table from an existing file : 

Raph_0-1685109231438.png

 

 

But I don't have this option when I click on the three dots next to the file : 

 

Raph_1-1685109349366.png

 

Do you know what am I missing?

 

Thank you

 

Raphaël

 

1 ACCEPTED SOLUTION
ce87
Helper I
Helper I

@Raph the file is a txt. Try renaming the file to a .csv and then try again. I had this issue when I walked through the turorial as well, and this solved it for me.

View solution in original post

3 REPLIES 3
germo
Advocate IV
Advocate IV

and it looks like there is a bug: the sample csv from the learning example works fine. But if I upload any Windows file, using CR LF as row delimiter, it causes an error. The "automatic" copy to table should use this as default, but doesn't. I need to manually copy csv into tables.

Raph
Helper III
Helper III

Thank you @ce87  !

ce87
Helper I
Helper I

@Raph the file is a txt. Try renaming the file to a .csv and then try again. I had this issue when I walked through the turorial as well, and this solved it for me.

Helpful resources

Announcements
Expanding the Synapse Forums

New forum boards available in Synapse

Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Update Carousel

Fabric Monthly Update - April 2024

Check out the April 2024 Fabric update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors