Expression.Evaluate returns an error

[danextian]

Hi All,

I need help in understanding why Expression.Evaluate in this query returns an error.

let
    Source = OData.Feed("http://services.odata.org/AdventureWorksV3/AdventureWorks.svc"),
    CompanySales_table = Source{[Name="CompanySales",Signature="table"]}[Data],
    Custom1 = Table.Schema(CompanySales_table),
    Custom2 = List.Transform(Custom1[TypeName],Expression.Evaluate)
in
    Custom2

Typename column contains a more specific data type of columns in the table (Int64, currecy, etc). I'm Expression.Evaluate to convert the values in this column as type type instead of type text but the conversion returns an error.  Aren't these valid data types?

TypeName

Text.Type

Text.Type

Int32.Type

Text.Type

Currency.Type

Int64.Type

[v-juanli-msft]

Hello

I hope this case  similar to the issue and solved alreadly may offer you some ideas,  i am still seeking for the reason deeply all the time.

Best Regards

Maggie

[danextian]

Hi @v-juanli-msft

Thanks for the reply. The solution in the link works if I am simply trying to re-apply the same data types from a previous step but what I am trying to understand why Expression.Evaluate returns an error when those are valid data types.