Forum Discussion
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 load the tables. The load stuck at 'Creating connection in model...' . Screenshot attached.
I am using Power BI Version: 2.97.921.0 64-bit (September 2021).
Any fix to this delay?
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.
20 Replies
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.Hello,
On the latest May'22 release and still having the issue.
Regards
August 2024 and not sure if Microsoft fixed this bug... I've applied every fix listed in this thread or another forum and am still failing to get past "Creating connection in model..." in the power query load screen. If the connection is between established, it would be nice to see some sort of progress count, percentage, or bar instead of just the rotating loading icon. As a last resort, will try to leave this on overnight and hope I wake up to a miracle.
pwc_ananta What are the sources?
Please make sure you get the version released on 10/29 (the current one in the Store). They fixed this bug.
Pat
Hi Member123456 - I have the same error and I am using that version. Its like two hours or more everytime i update some pretty simple queries just forever at creating connections in model
I am also experimenting this problem and it prevents me from saving my document. Is there a workaround to save my file without this refreshing?
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)
Still have similar challenge ,
My version is : Version: 2.109.782.0 64-bit (September 2022)
How can it be fixed ?
Hi,
I understand your frustrations, really I do, as I will explain below.
My answer has 2 parts:
1. I did not get the issue fixed on the day. I got impatient and stressed, might have missed one or 2 of the suggested actions. Then decided to remove all my big tables from the pbix (it contained all my data sources as I used a shared model). PAINFUL!!! Many of my reports then failed and I had to fix it one by one. What frustrated me the most was that many of the relationships was gone. Yes the tables that I did not touch, also lost their relationships. TIP - make a backup of the pbix so you can refer back when you have to rebuild the relationships.
2. Since then - I have implemented all the suggestions above (refresh off etc) for all new reports and my experience has been positive.
To summarize - Stay calm, if it does not work today, come back tomorrow and try again. I do believe that the suggestions proposed all have a positive impact. So implement asap, hopefully it will also resolve your issue.
Hope this helps.
I am experiencing this issue. I have the data connected to the Web, experiencing this issue since yesterday on the Power BI Desktop. Tried checking the data source settings along with the permissions. The data is not so large, while the file on the Web is just about 20 MB and the Power Still experiencing the same issue. I also have tried uninstalling and reinstalling the Power BI Desktop. Any suggestions are appreciated.
