Forum Discussion
stucking on creating connection in model
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!
Leann,
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.
Regards,
Lydia
51 Replies
Leann,
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.
Regards,
LydiaHello,
Tried the Solution above, still doeswn't work. Stuck at Creating Connection in Model.
This is happening after September2021 update of PowerBI Desktop.
I tried degrading to previous version of Power BI Desktop(August2021) Version. It is fixed now.
Regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is still not resolved even after October Update.
i tried every thing mentioned in this thread.
I have August Version Installed and it works perfectly fine.
But the Version from Microsoft Store (Oct 2021) still having issues and is stuck at Creating Connection.
Please help! Anonymous
Hi can you tell me how I download the August version ?
Hi LyidaAnonymous,
Thanks a lot for your help. After I disable the features you mentioned plus "import relationship from data source", I can load the table smoothly. :-)
I found the cause might be the new source of the dimension table contains duplicate rows, it caused the hang on problem.
one more question, if I refresh the data from power bi service, will it check the relationship as well? or is related to what I set in the option power bi desktop? Thanks for your answer. :-)
Have a nice weekend!
LeAnn
I have the same problem, I followed the same steps as in your proposed solution, but i'm still having issues refreshing the data.
Can anyone help me?
bharath47Microsoft Employee
Hi Team, started having the same issue since this week's Aug 2022 update. Any resolution?
As of 1/30/24 I started experiencing this issue with none of the proposed solutions being successful. Are there any new updates on this root cause?
I've been driving myself crazy for the last 3 days trying to figure this issue out. The only message I have gotten pertained to my model not being able to refresh due to memory, so I tried unselecting the boxes at data load, I've removed like 60% of the columns across all my tables, and still can't refresh, data load, or publish anything. I can't believe there hasn't been a post or solution from this week regarding this issue!
Since a couple of weeks, I can't open some report because of memory issue ("Out Of Memory").
They probably have reduced their capacity. 😐
Exactly the same here. I am thinking a global change has happened with Sharepoint.
orangeatomResolver I
hi bharath47 in August 2022, this issue is back, advise on solutions. Latest PowerBI client is downloaded as of August 4th, 2022.
- bharath47
orangeatom - Workaround could be to manually refresh the table one by one in Power BI Desktop "InsteadOf" RefreshAll. That helped me progress.
September 2022 still doesn't fix the issue for me, still stuck on creating connection in model for bi that import data from web 😞
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
timmayAdvocate I
I solved my same issue just FYI for anyone who has tried the above fixes but is still experiencing "Creating connection in model".
I recently moved all my measures into the one measure group and created folers for them. This means that the old measure group was left behind with no measures in it and they were hidden from view.
these measure groups would give and error on refresh (scroll down on refresh and you can see the error).
On going to the model tab in pbi I could see these measure groups without any measures in them. I just deleted these and this resolved the issue!
Hi not to sure how to do this Tim, can you pm me please?
Hello,
i tried above also + unchecked "Creating Connection in Model" but its not working?
Its after Septmber update.
Please help. Data Loads into Power Query but when i apply the changes, it is stuck.
Fahd,
Hello Fahd,
i've the same issue , could you tell me please how did u figure this out
thank u
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
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.
wcarterAdvocate III
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.
MattGellI 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
