Forum Discussion
Import hangs after upgrading to Sept 21
Hi, I've upgraded to Sept 21 desktop 64bit RS version and now I cannot refresh any of my data sources. It hangs on the "Creating Connection in Model" screen.
I've tried to uninstall and reinstall the May 21 version but this won't even open.....it gives an error on the splash screen. Same for both 64bit and 32 bit version. I've tried deleting the Power BI Desktop folder in AppData folder but it doesn't help.
So i am completely stuck. Any suggestions?
I have communicated with the Product Team, and this issue is working on a fix. Please wait patiently and I will post any updates here in time. Thanks for your understanding!
Update:Fix released ,Please download the latest version.
Download Microsoft Power BI Report Server- September 2021 from Official Microsoft Download Center
Best Regards,
Community Support Team _ Janey
40 Replies
Hi, wellf100
Can you try to open and refresh your pbix file with the September version on another device? This can rule out whether it is a computer problem.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If problem still persists, pls let me know.Best Regards,
Community Support Team _ Janey
hi, it is the same on other computers
looks like the same issue as here:
Stuck at Creating Connection Model - Page 7 - Microsoft Power BI Community
hi, it's the same for other users across the company. I believe it's a bug in the Sept Report Server version.
I'm able to use the Aug 21 standard version but this isn't optimized for Report Server.
Hi, wellf100
Please refer to this link, we have reported similar issues, but they are desktop version, not report server desktop version. You can check for updates at any time.
Stuck at Creating Connection Model - Page 5 - Microsoft Power BI Community
Since I can't reproduce your scene on my device, if you can share the screenshot of the error message, I will help you report the issue of report server.
Best Regards,
Community Support Team _ Janey
I have probably same issue, described here https://community.powerbi.com/t5/Report-Server/When-refreshing-a-report-it-doesn-t-show-the-number-of-rows/m-p/2140771#M21373
Good news! The issue has been fixed in the latest version of pbi rs desktop, you can download it:
Download Microsoft Power BI Report Server- September 2021 from Official Microsoft Download Center
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ JaneyHi, there's no improvement for me. I'm able to refresh the query preview in the Query editor and I'm able to import in Excel using Power Query but in PBI it just hangs at the Creating Connection in model window.
i can also confirm that Aug 21, Sept 21 and Oct 21 standard Desktop latest versions work fine. it's just Report Server version thats still doesn't.
I too have had no luck with the 'updated' PBIRS client. One comment I might add...
Have you let it sit for a 'long' time at the "Creating Connection" message? What I found was that if you waited long enough, about the amount of time it would normally take to refresh, the message would go away and the data would be refreshed. It's like it's actually doing it, just not showing the progress on the dialog message.
The two issues you raised in October are fixed in the latest version, please check.
Best Regards,
Community Support Team _ Janeymorning janey, well i've installed the latest version and i can see that the last refresh date/time is back. However when i try to refresh an existing dashboard it gets past the Creating Connection window but now hangs at the "loading data to model" window.....
I have the same problem on the las version Desktop RS, 2.97.2222.0, it fails on load data to de model. Even with an empty pbix the most siple query ( a constant o parameter ) fail on load and get stuck.
Was the server updated also? I had that issue until the server was updated to the September update. Also, what does it days in the dialog that it seems to be stuck on?
The load never finish, till I cancel.
It happens in some machines, the same version of Desktop works in my PC, but when I try on a server 2016 it fails.
Maybe is a problem related to updates of other software, for example .Net Framework...
Hi,
I'm facing the same issue since September 2021. Installing newer versions hasn't helped.
I wonder if checking the PBI Desktop settings could help.
I'm constrained to work with 2 machines: one for design, the other for importation because, curiously, the refresh is working in the latter machine.
Thanks
HI all, i created this ticket and despite the updated Sept 21 and Jan 2022 versions being released, I was still unable to solve the problem. This was until i was issued with a new pc a few weeks ago. Now everything refreshes normally. I believe the issue was something related specifically to the config of my old laptop. Maybe .Net version or something similar causing the problem. Other users in my company had the same issue but the updated Sept 21 versions released fixed their issues but not mine.....further evidence that something on my laptop was causing the problem.
Maybe not much help to those who still have the issue.
Hi wellf100
Glad to know that you're no longer having this issue.
Could you please share your PBI Desktop settings related to data loading? I suspect there's a link between the settings and the issue. Here's mine
In add: when I cancel the loading, a SQLDUMPER.EXE screen flashes.
Thanks
