Forum Discussion

gcyr's avatar
gcyr
Frequent Visitor
9 years ago
Solved

Connection ODBC Sqlite decimal size limit

Hi all,

 

I am trying to connect a Sqlite DB through a ODBC driver. I was able to do all of this but when I load by DSN in Power BI, all the values in my DB that had more than 2 decimals were truncated to the integer. 

 

Here is what the data look like in my DB

 

Here is what the same data look like in Power BI.

 

How can I correct this?

 

Thanks!

 

Need Help
  • gcyr's avatar
    gcyr
    9 years ago

    Hi Anonymous

     

    I think I may have the found the problem. The datatypes in my DB (except the Primary Key Column) are all Float(53). I thought maybe it was the datatype the problem so I changed it to Decimal(20,10) and it worked. I now see the all the decimals of the data in my DB.

     

    Thanks!

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi gcyr,

     

    Can you share some detailed information about this, I test on my side and can't reproduce your issue.

     

    Regards,

    Xiaoxin Sheng

    • gcyr's avatar
      gcyr
      Frequent Visitor
      9 years ago

      Hi Anonymous

       

      I think I may have the found the problem. The datatypes in my DB (except the Primary Key Column) are all Float(53). I thought maybe it was the datatype the problem so I changed it to Decimal(20,10) and it worked. I now see the all the decimals of the data in my DB.

       

      Thanks!