Forum Discussion

MaartenH's avatar
MaartenH
Frequent Visitor
10 years ago
Solved

Power BI doesn't use decimals

Hi,   Been trying all afternoon to get a dashboard together. Problem is that when I upload data with amounts like 2.5 & 3.6,  the dasboard adds these up in a graph/table etc. as 2 + 3 = 5 instead ...
Need Help
  • MaartenH's avatar
    MaartenH
    10 years ago

    Never mind, 

    In the edit query I found that in the "applied steps" window i made 2 (historic) alterations for the data, first I made it a "whole numer" then a couple steps later a "decimal"....deleted the first step and the data came through ok. 

     

    Solved, -1 kudo for meself!

     

    thanx for the input though!

Anonymous's avatar
Anonymous
Not applicable
10 years ago

I believe the reason for the csv recommendation is that excel carries a bunch of formatting baggage that can hide little surprises (numbers that come in as text perhaps). A csv file is an unformatted text file. The fewer moving parts in the machine, the fewer places you have to look when there's a problem. Is that about right sdjensen?

sdjensen's avatar
sdjensen
Icon for Solution Sage rankSolution Sage
10 years ago
Anonymous wrote:

I believe the reason for the csv recommendation is that excel carries a bunch of formatting baggage that can hide little surprises (numbers that come in as text perhaps). A csv file is an unformatted text file. The fewer moving parts in the machine, the fewer places you have to look when there's a problem. Is that about right sdjensen?

Anonymous - yes that is right. Many years since I stopped using Excel as source in SSIS packages, but I don't know if there is any similar issues with importing from Excel in Power BI, so it was just an suggestion (a long shot) to try to find the problem here.