Forum Discussion
Solved
Power Query Load is Stuck at Creating connection in model - Loading Data from Oracle DB
Hi, I am creating Power BI Report from Oracle Database. When I transform data (filtering the data for better performance), and Apply and Close the Power Query Editor. It takes hours and hours to lo...
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)