Forum Discussion

SofieW's avatar
SofieW
Regular Visitor
2 years ago
Solved

Error message during my Fabric exercise

Hi,  I'm just learning to work with Fabric. I'm following this exercise: mslearn-fabric (microsoftlearning.github.io) When I'm on step "Load file data into a table" I get an error message, and I ha...
data engineering
  • Anonymous's avatar
    Anonymous
    2 years ago

    HI SofieW,

    I success reproduce this issue on my side, it should be related to the display languages.
    After I change the display language to 'Nederlands', the same issue appeared and I confirm these works well before change language.

    Change language to Nederlands:

    Change language to English:

    Regards,

    Xiaoxin Sheng

SofieW's avatar
SofieW
Regular Visitor
2 years ago

Hi

I did it exactly as described in the tutorial:

download of the sales.csv to my downloads:

upload to my lakehouse in Fabric and then load to table:

And then I get the error. 

I have no idea what went wrong

Srisakthi's avatar
Srisakthi
Super User
2 years ago

Hi,

Try copy the entire rows , paste it in notepad and then save it as csv file. Then try to upload to files folder and load to tables it should work.

  • SofieW's avatar
    SofieW
    Regular Visitor
    2 years ago

    Hi,

     

    I did as you said and copied some rows to notepad and saved it as a csv. I got the same error. 

    • Srisakthi's avatar
      Srisakthi
      Super User
      2 years ago

      Hi Sofie,

      Try to copy entire content and paste it. Make sure to select "Use header for column names". Also check if you are able to preview the file in fabric portal itself. 

       

       

      If issue persist plz paste screenshot of it.

      • SofieW's avatar
        SofieW
        Regular Visitor
        2 years ago

        Hi Srisakthi

         

        I made a csv of the complete dataset, and saved it as sales2:

         

        then i loaded it. I can see a preview, and I tried to make te table. Same error.