Forum Discussion
Stuck at loading data to model for mySQL
It was working perfectly fine. Then today it stuck with the following window. I left it for hours, but nothing happened. Please help.
I accidentally stumbled across a fix for my problem. My Power Query was a Web.contents() Get api request and it simply could not get past the Enable Load into model and I was getting the same in progress timer indefinitely.
It turns out, the API response was returning a nested json which is equivalent to table of tables and I think each table, however small, is loaded by a thread.
Fix for me was to navigate under home file menu Option & Settings -> Global Options and set the Maximum Number of Simultaneous Evaluations to more than 1 (which it was by default)