Forum Discussion

evandroportugal's avatar
evandroportugal
New Member
8 years ago

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...
evandroportugal's avatar
evandroportugal
New Member
8 years ago

Hi,

I'm trying to use Power BI to create better reports for spiceworks, but I got a strange problem.

While trying to import the devices tables, there's a column named 'memory', which values represent the amount of RAM installed in each machine (value in bytes, 10 digits for anything above 1GB). This way, any machine with more than 2GB is getting the same value on Power BI, which is 2147483647, since the whole number data type in Power BI is 64-bits, this wasn't supposed to happen.

I'm using 64-bits version of Power BI and SQLite ODBC driver.

Anyone have a light on this issue?

Thanks