Power BI hangs on "loading data to model

[rv999]

I created a connection to a SQL database in Power BI desktop. The data was loaded successfully in Power Query. When I try to load the data in to the model, Power BI gets stuck forever. 

NOTE: I am using Power BI desktop on a virtual server using Remote Desktop.

[Anonymous · Accepted solution]

Hi @rv999 ，

Firstly, You can check whether the CPU utilization of the VM is full and the load is overloaded.

Secondly , check if your desktop version is up to date.

If it's not the latest version, update your desktop and try again.

Download Power BI Desktop from Official Microsoft Download Center

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bhanu_gautam]

@rv999 , what is the size of dataset that you are pulling into Power BI

[rv999]

@bhanu_gautam approximately 50 MB

[jerichar99]

I ran into the same issue. The data was small (100 rows), using ODBC (to Informix database), and PowerBI would consistently get stuck on "loading data." After some experimentation, it turns out my virtual machine CPU count was culprit. If there was 1 CPU, it would get stuck. If 2+ CPUs, everything would work. CPU load was not significant (not 100%, maybe 80% and then drops to 1-2%)

My guess is there is a bug in PowerBI to do multi-threading, where it expects there to be more than 1 CPUs.

[Steven_LYu]

solved my problem, thanks!