Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |