Import decimal number trunched off

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?


Posts: 1125
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Import decimal number trunched off

Postby MattAllington » Tue Oct 13, 2020 4:10 pm

What is your data source?

Can you post your PQ code here and advise which column name is of concern?
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 2 guests