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 trunc...
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!

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!