SQLite and Excel truncating decimals RRS feed

  • Question

  • I'm using ODBC to pull data from an SQLite view.  When I use MSQuery everything is fine, but when I use PowerQuery the numbers have their decimal values truncated.  Yes I can round the numbers first in my query, but I'd rather not have to do that.

    I've tried changing the number type in PowerQuery but nothing is working so far.  What am I missing?!

    • Edited by Den TC Monday, November 11, 2019 12:50 PM typo
    Monday, November 11, 2019 12:22 PM

All replies