stucking on creating connection in model

[Leann]

Hi,

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!

[Vipuls1011]

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. 

[DiegoAuvert]

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

[benstrom]

Hi,

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.

//Benny

[dmaddern]

Hello,

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

[FSmyth]

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

[Taz_Car]

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.

[orangeatom]

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

[saintsitive]

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

[bharath47]

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

[bharath47]

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

[inesnovo7]

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

[bharath47]

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

[inesnovo7]

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.

[inesnovo7]

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

[GavinR]

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.

[soumi]

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 

ASMAA

[wcarter]

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.

[FSmyth]

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 

[MattGell]

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

[Jakelender]

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