topic Re: Import hangs after upgrading to Sept 21 in Report Server

Import hangs after upgrading to Sept 21

wellf100 — Tue, 19 Oct 2021 09:15:31 GMT

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?

Re: Import hangs after upgrading to Sept 21

v-janeyg-msft — Fri, 22 Oct 2021 02:20:15 GMT

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

Re: Import hangs after upgrading to Sept 21

wellf100 — Fri, 22 Oct 2021 08:19:47 GMT

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.

Re: Import hangs after upgrading to Sept 21

v-janeyg-msft — Fri, 22 Oct 2021 10:06:45 GMT

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

Re: Import hangs after upgrading to Sept 21

wellf100 — Tue, 02 Nov 2021 14:47:23 GMT

hi, it is the same on other computers

Re: Import hangs after upgrading to Sept 21

wellf100 — Tue, 02 Nov 2021 14:50:33 GMT

looks like the same issue as here:

Stuck at Creating Connection Model - Page 7 - Microsoft Power BI Community

Re: Import hangs after upgrading to Sept 21

josef78 — Tue, 02 Nov 2021 19:27:32 GMT

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

Re: Import hangs after upgrading to Sept 21

v-janeyg-msft — Fri, 05 Nov 2021 09:55:27 GMT

Hi， wellf100 josef78

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 _ Janey

Re: Import hangs after upgrading to Sept 21

wellf100 — Fri, 05 Nov 2021 16:23:12 GMT

Hi, 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.

Re: Import hangs after upgrading to Sept 21

wellf100 — Fri, 05 Nov 2021 16:45:30 GMT

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.

Re: Import hangs after upgrading to Sept 21

v-janeyg-msft — Mon, 08 Nov 2021 08:42:20 GMT

wellf100

RS desktop was indeed updated a few days ago.

Re: Import hangs after upgrading to Sept 21

wellf100 — Mon, 08 Nov 2021 09:09:14 GMT

hello janey, yes on the 4th Nov, and i tried downloading and installing but it hasn't solved our problems. Still the same.

Direct connection works fine
Any existing report refreshed hangs at "Creating Connection in Model"
Any new import mode connection hangs at "Creating Connection in Model"
I can create the query and view preview results in Query Editor but when applying and the full import runs it hangs.
Same for others in my company
Sometimes when i cancel the import after waiting for ages for ages on the creating connection in model window, it runs an "SQLDUMPER.exe" program.
I uninstalled and tried to reinstall May21 RS version. After install when i try to open May21 RS version it gives an error and crashes so we have no choice but to use one of the PBI Desktop standard versions.

Thanks

Richard

Re: Import hangs after upgrading to Sept 21

v-janeyg-msft — Mon, 08 Nov 2021 10:12:05 GMT

Hi, wellf100

I test in my machine and use the below version, connect a excel file and no problems occurred. Are you connected to a database?

Re: Import hangs after upgrading to Sept 21

wellf100 — Mon, 08 Nov 2021 10:29:43 GMT

i've tried excel, SQL db and Analysis Services cube connections and it's the same for all. I can connect to all through Power Query in Excel fine. So it's definately a PBI problem but i can't tell if it's something specifically to do with the windows/laptop set up in our environment or a PBI bug. But it is ok in standard PBI dektop, Aug, Sept, Oct versions so seems something specific to RS version.

Re: Import hangs after upgrading to Sept 21

v-janeyg-msft — Mon, 08 Nov 2021 10:38:06 GMT

wellf100

Forum support has limitations, because I can’t reproduce your problem, so I can’t report the issue.

I think the best course of action is to follow up with support since it will require environment specific information and I don't want you to have to publically disclose that here on the community section.

Best Regards,
Community Support Team _ Janey

Re: Import hangs after upgrading to Sept 21

josef78 — Mon, 08 Nov 2021 12:25:59 GMT

Still same problem...
What more, installation binnary is not changed, there no any change (description on download page is updated, but downloaded installation file is unchanged...

Re: Import hangs after upgrading to Sept 21

josef78 — Mon, 08 Nov 2021 13:32:17 GMT

Hi v-janeyg-msft ,

yes, this issues is present for database connection (for me).

Support link is not usable, it is for cloud Power BI (there is similar issue already solved), this issue is related to Power BI Desktop optimized for Report Server (onpremise)

Re: Import hangs after upgrading to Sept 21

wellf100 — Mon, 08 Nov 2021 14:01:40 GMT

good to know it's not just us!

Re: Import hangs after upgrading to Sept 21

pabeader — Mon, 08 Nov 2021 16:12:25 GMT

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.

Re: Import hangs after upgrading to Sept 21

v-janeyg-msft — Wed, 08 Dec 2021 05:50:33 GMT

Hi, wellf100 pabeader josef78

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