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!
Solved! Go to Solution.
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.
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.
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
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.
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
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
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.
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.
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.
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.
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
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.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.