Forum Discussion
Creating Connection in model stuck
Hi Anonymous
First, please tell me some basic information:
Do you connect to excel files with power bi desktop?
Is the data in excel file from outside source?
To end the refresh process, please open task manager, find the "Microsoft Mashup Evalution", this is the process for connecting in power bi, end the task of this.
In Power bi desktop, to improve the performance when connecting, please turn off options below in Options and Settings->Data load:
'Relationship","Time Intelligence","Backgroud data","parallel loading of tables".
Besides, please check if any blank column from excel(your data source) is loaded into Power bi.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
im having the same issue except im connecting to a data base and my connection to model works and loads but it has stopped showing me the number of rows that are being loaded on ?
Same issue. My load usually takes 7 hours, but at least I can see how many rows it's loading and tell that it's making progress. Today, It stopped telling me how many rows were being loaded and just sits on "Creating connection in model..."
Is there any way to know that it's running and not just stuck? I'd hate to wait 7 hours and then not have results.
The data loaded for me. I just could not tell how many rows were loaded into each object which creates a validation concern. I check these counts to make sure new data loaded properly. With this bug, I can't validate which bothers me.
