Dataflows should have parity with Power Query when it comes to data types. Currently, dates are converted to datetime and fixed decimal numbers are converted to decimal numbers. Time does not work a...
Additionally there is a problem with the display of Whole Numbers. They have a data type of Int64.Type, and they are stored internally correctly, but they are displayed rounded as if they are doubles (i.e. to 15 significant figures), as can be seen by the following which uses the maximum permissible value of an Int64: let Source = Table.FromRecords({[LargeInteger = 9223372036854775807]}, {"LargeInteger"}), ToInteger = Table.TransformColumnTypes(Source,{{"LargeInteger", Int64.Type}}), ToText = Table.TransformColumnTypes(ToInteger,{{"LargeInteger", type text}}) in ToText The "ToInteger" and "ToText" steps show different values when used in Power BI dataflows.
