Close and apply loading process stops at certain point

[Robin9700]

Hi all,

I'm working with a dataset of approx. 15 tables of different sizes. In Power Query Editor I made some changes (added a column etc.) and now I want to 'Close and apply' those changes. However, loading them into the datamodel seems to take forever. 
I have already restarted Power BI Desktop as well as my whole PC, but nothing seems to work. The loading process always stops at the same point (the same amount of loaded data).

How to resolve this issue?

[amitchandak · Accepted solution]

@Robin9700 , One way is to load the tables one by one. Just copy from one file to another in Power Query, one by one, and check which table is taking the most time.

Also, it's not preferable to load all the data on the desktop. Follow the approach from Guy in a Cube to load less data.

https://www.youtube.com/watch?v=qZOEDBedATA