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 in a device in bytes. The problem is, any machine with at least 3GB is showing with the value 2,147,483,647, but since whole number in power BI is 64 bits, why is this happening?
I'm using SQLite 64-bits ODBC Driver and Power BI 64 Bits. If I do the ODBC connection to import the data to a excel spreadsheet, it gets the right value for everyone.
Any help is welcome, thanks!
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?
There is a Binary option under data type list, are you able to convert the imported data to this format?
I am having the same issue. Have you determined a work round or a solution to this problem?
It seems to be very much a Power BI issue as if I use other tools to view the data (eg SQLLite SPY) then it is displayed in its correct format (a 19 digit number).
Have you found a workround or a solution to this problem? I am having the asame issue with a field containing a 19 digit number.
Using tools such as SQLite SPY shows the data correctly - so it definitely seems to be associated with Power BI.