Forum Discussion
Sqlite - Wrong integer imports
Hello. I'm trying to import a spiceworks database to Power BI, but I got a strange issue. While importing the devices table, there's a column named memory, which represents the amount of memory i...
5 years later and ran in to the same problem, so here's my workaround for anyone else coming across this thread...
In your query, use the SQLlite CAST function to change the integer column's datatype to text:
cast(my_column as text)This should load the number in to PowerBI exactly as-is. You can then convert it back to number format in Power Query if needed.