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.
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 |
Proud to be a Super User!
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
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.
Proud to be a Super User!
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |