This one has got me completely stumped. I have a SQLite database (1st pic) with column marketCap which has correct values. When I connect Power BI via ODBC to the database, every column is correct EXCEPT marketCap (2nd pic) which shows the same value repeated. I have refreshed views, refreshed data, cleared caches, restarted computer, dropped table and nothing works. What could this possibly be? Please help. Thanks,
