Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Loading delta tables into a lakehouse

Hi All,   Please HELP, I am new to fabric and struggling to load my files to delta tables in a lakehouse. once uploading my data file (in CSV.) format and then Load to tables it gives an error reg...
data engineering
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for the help, how do I ensure that my headers are UTF-8 encoded Unicode word characters? I am so lost, thank you for the explanation above.

  • BartStens's avatar
    BartStens
    2 years ago

    Dear Anonymous ,

     

    I was also struggling with exact same error msg. My headers followed requirements exactly as UTF-8 demands, but still got the error msg.

     

    Turns out I had to specify my column-seperator a.k.a. delimiter in the prompt when selecting the three dots near the file > "Load file in new table" then enter de correct delimiter used in your .csv-file, in my case a comma (,) was pre-filled in the prompt, but my .csv-file used (;) so had to adjust that one and load was succesfull!

     

    See below screencap (sorry it's in Dutch-UI)

BartStens's avatar
BartStens
New Member
2 years ago

Dear Anonymous ,

 

I was also struggling with exact same error msg. My headers followed requirements exactly as UTF-8 demands, but still got the error msg.

 

Turns out I had to specify my column-seperator a.k.a. delimiter in the prompt when selecting the three dots near the file > "Load file in new table" then enter de correct delimiter used in your .csv-file, in my case a comma (,) was pre-filled in the prompt, but my .csv-file used (;) so had to adjust that one and load was succesfull!

 

See below screencap (sorry it's in Dutch-UI)