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

zoloturu's avatar
zoloturu
Memorable Member
8 years ago

TAUSEEF,

 

Did you remove only one comma via Advanced Editor? See on the picture:

 

extra comma

Regards,

Ruslan

 

Interkoubess's avatar
Interkoubess
Solution Sage
8 years ago

Hi TAUSEEF,

 

As zoloturu explained, please remove only one comma.

 

Not both but only one.

 

Let us know if it did not work.

 

Ninter

  • 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