Forum Discussion

TAUSEEF's avatar
TAUSEEF
New Member
8 years ago
Solved

Expression.syntaxerror: token indetified expected

  Plz help me, how to tackle this issue that i get when i try to edit a table imported as excel content from powerpivot. The same error shows up when i hit refresh on the table which is impor...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi TAUSEEF,

     

    Based on my assumption, your Power Query should be like below, please directly paste it to the Advanced Editor.

    let
    Source = Teradata.Database("HODB", [Query="SELECT ""AC_RNK"".""CHART"".*   FROM ""AC_RNK"".""CHART"""]),
    #"Renamed Columns" = Table.RenameColumns(Source, {{"ACODE", "ACODE"}, {"DESCRIPTION", "DESCRIPTION"}, {"ACODE_TYPE", "ACODE_TYPE"}, {"ACTIVE", "ACTIVE"}}),    
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns", {{"ACODE", Int64.Type}, {"DESCRIPTION", type text}, {"ACODE_TYPE", type text}, {"ACTIVE", type text}})
   
in
    #"Changed Type"

    Regards,

    Yuliana Gu

TAUSEEF's avatar
TAUSEEF
New Member
8 years ago

After doing this the error that showed earlier was convertered to token comma expected.

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi TAUSEEF,

 

Based on my assumption, your Power Query should be like below, please directly paste it to the Advanced Editor.

let
    Source = Teradata.Database("HODB", [Query="SELECT ""AC_RNK"".""CHART"".*   FROM ""AC_RNK"".""CHART"""]),
    #"Renamed Columns" = Table.RenameColumns(Source, {{"ACODE", "ACODE"}, {"DESCRIPTION", "DESCRIPTION"}, {"ACODE_TYPE", "ACODE_TYPE"}, {"ACTIVE", "ACTIVE"}}),    
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns", {{"ACODE", Int64.Type}, {"DESCRIPTION", type text}, {"ACODE_TYPE", type text}, {"ACTIVE", type text}})
   
in
    #"Changed Type"

Regards,

Yuliana Gu