Expression.syntaxerror: token indetified expected

[TAUSEEF]

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 imported from excel file as excel content.

Thanks.

[zoloturu]

@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]

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]

@TAUSEEF,

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

Please remove one.

Regards,

Ruslan

[TAUSEEF]

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

[zoloturu]

@TAUSEEF,

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

extra comma

Regards,

Ruslan

[Interkoubess]

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]

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

[v-yulgu-msft · Accepted solution]

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

[Interkoubess]

Hi @TAUSEEF,

Could you please the right side ( drag the bar on the right side) because we cannot see this part in order to find wich token is really missing.

Show the whole image and I can assist.

Ninter

[TAUSEEF]