Forum Discussion

Raph's avatar
Raph
Helper III
3 years ago
Solved

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 : 

 

 

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

 

 

Do you know what am I missing?

 

Thank you

 

Raphaël

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

    • carterslade_29's avatar
      carterslade_29
      New Member

      I have it named as sales.csv itself. 

      Still "load to tables" isn't working. I'm using the Fabric free trial, is that the cause?

  • germo's avatar
    germo
    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.