"Creating connection in model" - Doesn't show rows being downloaded anymore.

[zapppsr]

Hi!

Since September 2021 Update, when refreshing data using Power BI Desktop connected to Azure SQL Server, it goes like:
Evaluating - OK
Waiting for other queries - OK

Creating connection in model ... (Stays here until all data is loaded)

I have more than 100 Power BI files in my organization, all of the connected to Azure, so it is not a specific file that has this behaviour. Every file I try is the same.

At first I thought it was stuck there, but If the file is big, lets say 4 Million rows, it takes sometime and eventually loads the data. But it doesn't show the amount of rows being downloaded anymore. And believe me, this is my daily routine, importing, updating and building reports.

This is misleading because you can't differentiate if the process is stuck or going all right anymore. You just have to have faith that is working, but when it takes too long it is complicated to be waiting without knowing that it is going to load correctly.

I was hoping that this would be fixed in October 2021 release but had no luck.

Anyone else experiencing this?

Thanks in advance!

[v-angzheng-msft · Accepted solution]

Hi, @zapppsr 

A similar issue has been reported internally.(ICM: 263271425)

And this is the latest updated information from the pg:

We have a fix for this internally, which will be released in the November version of Power BI Desktop.

More discussion on this issue:

Stuck at Creating Connection Model

Creating connection in model" - Doesn't show rows being downloaded anymore

An alternative solution is to temporarily downgrade to the August version until the November version update.

You can download previous versions from here, scroll to the bottom of the month you want and the link is there
Previous monthly updates to Power BI Desktop and the Power BI service

Here are the links for the August version:

Select the following links to download this earlier version:

• August 2021 version of Power BI Desktop - 32-bit
• August 2021 version of Power BI Desktop - 64-bit

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@zapppsr , Please log an issue - https://community.powerbi.com/t5/Issues/idb-p/Issues

Check any solution given on similar issue for sep-2021