Import decimal number trunched off

Luca72
Posts: 1
Joined: Wed Aug 26, 2020 10:33 pm

Import decimal number trunched off

Postby Luca72 » Wed Aug 26, 2020 10:37 pm

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

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 2 guests