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.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Hi,

 

just want to add another possible cause for this issue as it has happened to me a couple of times now. If you import data from an excel sheet make sure to delete any empty columns on the right of the table you're loading (just mark the columns and press delete). It seems like PBI is trying to create connections to all the empty columns as well and then it takes forever to refresh.

 

//Benny