Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Regular Visitor

stucking on creating connection in model


I have a data model in power bi desktop, the tables are loaded from ssas server, and it refreshed data well yesterday.

But today when I pulled in more data (400,000 rows to 17,986,280 rows) to ssas server, and click refresh data of the fact table (refresh only one table), it's stucking in "Creating connection in model" 1 hour...(still stucking)

Also, I've exmained the table which has no blank columns. is it normal? 

or any experience to check the problem efficiently?


Thanks a lot!



Do  you choose “Import” or “Connect Live” mode to connect to SSAS database in Power BI Desktop? I would recommend uncheck the following options in Power BI Desktop and then refresh your data model.

If the above error still occurs, please try to re-connect to the SSAS database in Power BI Desktop, pull in columns and rows you need to build report.


Community Support Team _ Lydia Zhang
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

New Member

I was loading data from flat files when i got this error. It somehow created multiple columns in my data sheet and due to which I was stuck at creating connection in model. I just deleted those unnecessory columns (though it showed blank in my original excel file), and problem is resolved. 

New Member

Trying to load a recurrent csv input, and this time is not working. Stuck in Load " Creating connection in the model." I normally have to modify the query i.e, if any header changes or new columns to incorporate w/o problems in the past. This time, new columns were modified in the power query to make the load pass the evaluation but stuck in the creating connection

New Member



just want to add another possible cause for this issue as it has happened to me a couple of times now. If you import data to PBI from an excel sheet make sure to delete any empty columns on the right of the table you're loading (just mark the columns and press delete). It seems like PBI is trying to create connections to all the empty columns as well and then it takes forever to refresh.



Helper I
Helper I


I had the same issue with a new table i added to an existing data set. I removed the new table, then readded it and it worked for me.

Maybe that will help for you

Regular Visitor

Hi I believe it crashes as it's trying to pull endless columns so you need to save the information you have as a table so it just read and puts the data other with the upgrade it's been defaulted to pull endless columns

Frequent Visitor

Hi, does anyone have any other suggestions.  I am connecting to excel files in sharepoint and am getting blocked at the "Creating connections in model" stage.  I have tried everythgin above, but no joy.

Resolver I
Resolver I

hi @bharath47 in August 2022, this issue is back, advise on solutions. Latest PowerBI client is downloaded as of August 4th, 2022.

September 2022 still doesn't fix the issue for me, still stuck on creating connection in model for bi that import data from web 😞

@orangeatom - Workaround could be to manually refresh the table one by one in Power BI Desktop "InsteadOf" RefreshAll. That helped me progress.


Hi Team, started having the same issue since this week's Aug 2022 update. Any resolution? 

Same here! Don't know what to do. 😞

@inesnovo7 try manual refresh of individual tables once and then try RefreshAll. Not incurring this issue after this step.  

Thank you, it works! You really saved me here.

However, it's super inconvenient that the overall refresh doesn´t work...  hope this will get fixed soon.

Update: I hate to say that manually resfreshing doesn't work on every table. 😞

New Member

When are MS going to admit there is an error with the software and release a bug fix.


That parallel loading is killing the loading and has caused be so much greif since august.



New Member

hello guys , 


Could someone help me please , it has been a week i'm struggling wtih this issue , i haven't found a solution 


i've PBI installed on the virtual machine (VMW) & i'm trying to connect it with a CSV file but when i select my file it shows me the table as well , then i press  "Transform data " , it opens me the power query but when i press" close" the loading phase never ends.


Thanks in advance 



Frequent Visitor

I have this same issue, though I think it is not that the data isn't loading for me but that it only shows the Creating Connection message the entire time it is loading data. It seems like some bug or change has resulted in users no longer seeing the number of rows loaded during a refresh and instead only this mesasge for all tables.

Hi @wcarter did you find a fix for this? I have downloaded the latest version of power bi and still issue creating connections in model and no refresh. Can anyone help? @Jakelender @timmay 

I have exactly the same issues - on all my Power BI files for a variety of data sources. It just started in September for some reason.

Everything loads but I cant see the progress of x many rows from x , its a real nuiscance as I cant gauage mcuh longer it has to run - unless I set a timer on my phone. Please fix this

Yes I believe you may be right. I got the 'Creating Connection' message and the data was loaded into my model. I then checked my model and the connections were not made. Seems like a bug on the message but didn't keep me from loading in data and the load did not take long

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors