Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Creating Connection in model stuck

Hi Guys,    I am trying to refresh my Power BI report but it is stuck on "creating connection in model".   Steps taken:    Turned off automatically creating connections from options  narrowed...
  • v-juanli-msft's avatar
    6 years ago

    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.