Forum Discussion

danextian's avatar
danextian
Super User
8 years ago

Expression.Evaluate returns an error

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
Need Help

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    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's avatar
      danextian
      Super User
      8 years ago

      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.