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 with SQL and SSAS cube data not matching. i have to fix this exponential in cube to match data with SQL DB and SSAS Cube. 

would someone can please help me in this regards

 

regards

SNKM

 

Need Help

3 Replies

  • 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.

  • idp6134's avatar
    idp6134
    New Member
    2 years ago

    I have a similar issue.  The keys I use are defined as 18,0 and they are unique.  They are the PK in the SQL Server DB I use, so I know they are unique.  But when I bring the table into SSAS Tabular it is displayed in scientific notation.  Even if I change the data type to whole number I am not allowed to set the value to unique because SSAS see the numbers as duplicates but they are not.

     

    This needs to be fixed.