Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

hamzashafiq

Stuck at Creating Connection Model

Submitted by Kudo Collector on ‎09-27-2021 02:31 AM

I am stuck at this point when I click on the Refresh button. Looks like there is a problem in September 2021 update, I've downgraded to August and it's working fine.

image.png

 

Status: Accepted
See more ideas labeled with:
69 Comments (69 New)
Comments
NeimadB
Helper II
Helper II
‎10-27-2021 02:27 AM

Any idea to fix this issue ?

 

I have imported a SQL Server table with 6k rows, no problem.

 

But with a table with thousands and thousands of rows I'm stucked at "Creationg connection in model".

 

I've downgraded to the August 2021 version, but my pbix are not compatible.

 

I'm currently using the latest version of October 2021

 

Version: 2.98.882.0 64-bit (Oktober 2021)

Anonymous
Not applicable
‎10-27-2021 04:12 AM

The app continued to appear to be stuck at "Creating Connection in Model" after reverting to Aug 2021 version, but it wasn't.  It simply wasn't providing the status indications I was used to.  The refresh completed in the normal time - transitioned directly from "Creating Connection in Model" to "Success" when it finished.

 

It will be nice to get normal indications back when this is finally fixed.

zapppsr
Kudo Collector
Kudo Collector
‎10-27-2021 04:56 AM

I hope they take the opportuniy to improve the status dialog box, evolving it into a more detailed update window, with more information on what is going on during the update.

Lets hope for November update.

Kos
Regular Visitor
‎10-27-2021 06:14 AM

Hi everyone,

 

had the same problem only with one pbix file. I couldn't load data from excel file on local drive.

So, in addition to mentioned actions, i.e.

  1. roll back to august version,
  2. remained only one option checked on Options - Current File - Data load tab - "Auto date/ime" (otherwise my model ruins) - solution published here

Kos_0-1635340755457.png

 

The above actions did not helped, but next action made my day:

3. Just disable autorecovery for current file

Kos_0-1635340258056.png

 

Then, save file, closed it and open again!

Try to import data into model.

 

 

PS: May be first 2 action unnecessary at all.

zapppsr
Kudo Collector
Kudo Collector
‎10-28-2021 07:02 PM

Apparently fixed in today's version: 2.98.1004.0

Anonymous
Not applicable
‎10-29-2021 06:40 AM

So much better!!!

PierreL
Frequent Visitor
‎10-31-2021 08:22 PM

Confirming the issue is solved with version 2.98.1004.0

jason_jackson
Regular Visitor
‎11-01-2021 02:12 AM

Yep, now fixed for me.  I can now see progress is being made which is much better for reports which take a while to refresh.  Thanks.

vnl3
Frequent Visitor
‎11-01-2021 12:46 PM

Downloaded the newest version and still unable to import data into the model.

zapppsr
Kudo Collector
Kudo Collector
‎11-01-2021 12:56 PM

@vnj are you unsing the 64bit version?

Is it stuck the same way or changed the behaviour?

Idea Statuses