Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

SSAS Tabular exponential column data mismatch

Hi team, I am facing data mismatch in SSAS tabular model cube beacuse of exponential data in column. refer screenshot for sample data. DAX: Calculate(sum(Table[Amount])) when i compare data ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , Change Data type in SSAS, so that power BI does not get Value like E-16 . They try

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak 

    even i change data from General to Decimal number no luck, below are the details

    row data contains more than 18 digits, when we add table in SSAS cube from SQL DB, column data contains scientific notation which cause in data mismatch. 

    1.96E+16

     we have to bring data as is from SQL into cube with out scientific notation to get accurate sum.

    SQL column data type is Amount Decimal(38,2)

    would you please help 🙂

    below is the screenshot.