Page 1 of 1

Import decimal number trunched off

Posted: Wed Aug 26, 2020 10:37 pm
by Luca72
Dear all
I am importing two columns from an excel file, import via folder as are from a set of files.
The data in those two columns in excel are formated as decimal number with 4 decimals., however when I import in Power Pivot, even forcing the decimal data type in the "Transform" section of Power Query, the result is an integer.

did you experienced similar issues, any thoughts?