Solved: Connection ODBC Sqlite decimal size limit

gcyr · ‎08-08-2017

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!

gcyr · ‎08-10-2017

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!

View solution in original post

Anonymous · ‎08-09-2017

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 · ‎08-10-2017

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!