decimal number smaller than 1 in Excel is rounded to 0 after loading data to PBI

[akfir]

Hi all,
i know that is a common issue but i have not found any solution for it.

i have customers monthly sales data by products and it is common that some of them buy for example 0.5 unit of x product, but when i load this data to PBI all these decimal numbers are automatically rounded to zero and on project it seems they did not buy this x product at all which is not true and misleading.

please help me solve that,
thanks
Amit

[v-juanli-msft]

Hi 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?

If not, please feel free to let me know.

Best Regards

Maggie

[v-juanli-msft]

Hi @akfir 

As tested, this is not a problem on my side.

You could change the number of the decimal places to 2 to show expected result.

Also please check whether you download the lastest version.

https://www.microsoft.com/en-us/download/details.aspx?id=58494

Best Regards

Maggie

[Geradav]

Hi @akfir 

I am not aware of that issue and never encountered it.

I guess it depends on the data type you assign your column in Power Query before loading it to Excel Data Model. Also, if you pass by the Power Pivot, make sure to confirm the data type of that column.

If that has not helped, give us some more details, and potentially some screenshot of your query and model.

Let us know what's the status.

Best

David