Forum Discussion
Power Query Load is Stuck at Creating connection in model - Loading Data from Oracle DB
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.
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.