Error message during my Fabric exercise

[SofieW]

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 have no idea how to solve it. I uploaded a csv as instructed, and when I want to turn it into a table, it won't work.

This is the message: error {"name":"TypeError","message":"Cannot read properties of undefined (reading 'indexOf')"}

I tried other csv's with the same result. When I try to delete the data file to try again, I get the message "An exception occurred. Please refresh the page and try again." I have to delete the whole lakehouse. 

I have absolutely no idea what I'm doing wrong. Please help

[ReynaldoZuazo]

In my case, I followed all the instructions in the tutorial and I got the same error. The steps were to download the sales.csv file, and I tried other csv files and couldn't load it into a table.

[JeromeN_talan]

Hi,

Same problem here.

I cant import any csv.

[Anonymous]

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]

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 · Accepted solution]

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]

YES! Thank you so much.

[Srisakthi]

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]

Hi,

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

[Srisakthi]

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]

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.