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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi SofieW,

How did you do these steps? Have you check if file is broken during download? Please share some more detail about these operations then we can clarify your scenario and test to troubleshoot.

The tutorial steps should be: download the sample csv file, upload it to the Lakehouse files level. Then right-click on the uploaded csv files and choose ‘load data to tables’.

Notice: the orange underline 'sales' table is generated from these operations.

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    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

      YES! Thank you so much.

  • 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.