Forum Discussion

PierreL69's avatar
PierreL69
Helper IV
1 year ago
Solved

Import correctly CSV into power query

Hello everyone, I am contacting you because I am having trouble importing a CSV file into Power Query, but without success... I can't seem to find the right method to do this. What drives me even c...
  • Anonymous's avatar
    Anonymous
    1 year ago

    I can import the file using this MCode:

    = Csv.Document(File.Contents("Z:\test.csv"),[Delimiter=";", Encoding=1201, QuoteStyle=QuoteStyle.Csv])

     

    Or do I miss something?

  • PierreL69's avatar
    PierreL69
    1 year ago

    Victory it works, so what differ between what I did and what you did is the encoding number you used "1201"

    Could you explain me how you selected this "encoding system" ?