Connection ODBC Sqlite decimal size limit

[gcyr]

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!

[v-shex-msft]

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 · Accepted solution]

Hi @v-shex-msft

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!