Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
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
I see there an extra comma after text {""ACTIVE"", ""ACTIVE""}})
Please remove one.
Regards,
Ruslan
i have tried removing it {""ACTIVE"", ""ACTIVE""}}),, but the editor wont accept it. Before i removed the editor showed no syntax error.
After doing this the error that showed earlier was convertered to token comma expected.
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
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
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |