power bi import data taking forever

Question

I usually work with power bi and all go well on my computer. Yesturday I downloaded it on a virtual machine itself on a Windows server 2019 machine that I connect on using "distant desktop" or whatever you call it to create a dashboard to visualize some data.

The problem I'm having is that it is taking forever (over 10 hours by now) on the " creating connexions in model".

Image is in french but it is pretty usual content:

precisions:

• I already have optimized the data, and can not reshape the tables more,
• The only big table (>100 rows) have a count of around 800k rows,
• I do have internet and can ping whatever I want,

Any idea where it can come from? Thanks for your help!

Answer 1

Ok, I've found my problem this morning while hanging in the options of the virtual machine.

I had only 1 virtual processor that was always used by other applications and so powerBi could not get nearly as much processing power as needed.

I just changed it and it loaded in seconds...

Conclusion: powerBi speed is based on your processing power, so when working on it, close as much windows as possible on your computer.