Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to 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!
Hi @gcyr,
Can you share some detailed information about this, I test on my side and can't reproduce your issue.
Regards,
Xiaoxin Sheng
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!
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |