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,

 

Can you provide code of your M (PowerQuery) script here? Go to Advanced editor and copy it?

It will be easier to help you.

 

Regards,

Ruslan

  • TAUSEEF's avatar
    TAUSEEF
    New Member
    8 years ago

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

    • zoloturu's avatar
      zoloturu
      Memorable Member
      8 years ago

      TAUSEEF,

       

      I see there an extra comma after text {""ACTIVE"", ""ACTIVE""}})

      Please remove one.

       

      Regards,

      Ruslan

      • TAUSEEF's avatar
        TAUSEEF
        New Member
        8 years ago

        i have tried removing it {""ACTIVE"", ""ACTIVE""}}),, but the editor wont accept it. Before i removed the editor showed no syntax error.