Forum Discussion

pwc_ananta's avatar
pwc_ananta
Helper I
4 years ago
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...
Interesting Links
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    pwc_ananta 

     

    A similar issue has been reported internally, ICM: 263271425

     

    And this is the latest updated information from PG:

    We have a fix for this internally, which will be released in the November version of Power BI Desktop.

     

     

    Best regards
    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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)