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?


Thanks
Luca