none
Change encoding for import csv file in power query RRS feed

Answers

  • Is this file free of any sensitive data? Can it be trimmed down to something which doesn't contain sensitive data but which still reproduces the problem? If so, please use the "Send a Frown" feature to report this problem and attach the file the causes it.
    Thursday, May 7, 2015 11:54 AM

All replies

  • This works for me; what error are you getting?
    Wednesday, May 6, 2015 1:08 PM
  • Error is

    Expression.Error: The column 'Классификация заявки [list]' of the table was not found.
    Details:
        Классификация заявки [list]

    I change the encoding in advanced editor

    Wednesday, May 6, 2015 8:35 PM
  • Is this file free of any sensitive data? Can it be trimmed down to something which doesn't contain sensitive data but which still reproduces the problem? If so, please use the "Send a Frown" feature to report this problem and attach the file the causes it.
    Thursday, May 7, 2015 11:54 AM
  • One or more of the headers have characters that differ in the two encoding types, you need to change those after "Table.TransformColumnTypes" to match with the way the text is presented in utf-8 so that the power query can find them in your csv file.
    Sunday, April 10, 2016 1:11 AM