cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zapppsr
Kudo Collector
Kudo Collector

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

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!



 

1 ACCEPTED SOLUTION
v-angzheng-msft
Community Support
Community Support

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:

 

 

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.

View solution in original post

2 REPLIES 2
v-angzheng-msft
Community Support
Community Support

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:

 

 

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.

View solution in original post

amitchandak
Super User
Super User

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

 

Check any solution given on similar issue for sep-2021

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.