Dell and PowerBi

Xino_sam

Expert Member
Joined
Aug 22, 2012
Messages
1,798
Reaction score
173
Location
Wild West
I have a Dell i7 Laptop with 16GB RAM. I am experiencing data ingestion issues when using ODBC & Treasure Data into Power Bi. Max number of rows it ingests is about 16K and then it gives error messages - after about 45min (some databases have up to 300k rows). I am using a VPN connection as well. The strangest thing is I have another desktop I have built myself, no issues 300k rows in a few seconds (almost the same spec as the laptop), I have also tested my scripts on a Lenovo i7 - no issues at all, I am only experiencing issues on the Dell - purchased it about 1yr ago.

Does anyone have a solution?? I am so close to buying another laptop - a totally unnecessary expenditure, not that I have R15K begging to be used.
 
Feels like you have some issues (security software or something) that is slowing something down on your Dell. No experience of the ODBC or specific endpoint that you referring too.

I have a 4 year old Dell precision that was recently just upgraded from 16GB to 32GB, only because I am now dealing with tables that even aggregated, return 30 million lines in PowerBI, but haven't had any issues . Unaggregated - it's 180 million lines for the time period we report on.
 
Ps. Maybe reinstall the ODBC driver for your data source? Just an idea or reinstall PowerBI (who knows)
 
Maybe try reinstalling your drivers/pbi desktop as suggested above. 300k rows is really nothing for PBI and it should be able to process that easily.
 
Thanks @TedLasso, I have uninstalled and re-installed PowerBI a couple of times. I have also uninstalled Norton, thinking perhaps it could be the culprit - but still success, but then the desktop has Norton installed.
 
Thanks @TedLasso, I have uninstalled and re-installed PowerBI a couple of times. I have also uninstalled Norton, thinking perhaps it could be the culprit - but still success, but then the desktop has Norton installed.

I see you mention laptop vs. desktop...could it be a networking issue (wifi vs. lan) ?
 
Top
Sign up to the MyBroadband newsletter
X