topic Error message during my Fabric exercise in Data Engineering

Error message during my Fabric exercise

SofieW — Mon, 29 Jul 2024 13:47:06 GMT

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

Re: Error message during my Fabric exercise

Anonymous — Tue, 30 Jul 2024 01:41:22 GMT

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

Re: Error message during my Fabric exercise

SofieW — Tue, 30 Jul 2024 06:29:56 GMT

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

Re: Error message during my Fabric exercise

JeromeN_talan — Tue, 30 Jul 2024 07:31:04 GMT

Hi,

Same problem here.

I cant import any csv.

Re: Error message during my Fabric exercise

ReynaldoZuazo — Wed, 31 Jul 2024 04:06:14 GMT

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.

Re: Error message during my Fabric exercise

Srisakthi — Wed, 31 Jul 2024 06:07:04 GMT

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.

Re: Error message during my Fabric exercise

SofieW — Wed, 31 Jul 2024 06:36:29 GMT

Hi,

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

Re: Error message during my Fabric exercise

Srisakthi — Wed, 31 Jul 2024 06:41:50 GMT

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.

Re: Error message during my Fabric exercise

SofieW — Wed, 31 Jul 2024 07:02:30 GMT

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.

Re: Error message during my Fabric exercise

Anonymous — Thu, 01 Aug 2024 07:07:28 GMT

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

Re: Error message during my Fabric exercise

SofieW — Thu, 01 Aug 2024 07:24:50 GMT

YES! Thank you so much.