Refresh stuck on "Creating Connection in Model"

[Kamana]

Hello All,

I am trying to refresh my dashboard but its stuck on "Creating Connection in Model". I even tried to refresh tables individually but for one table its showing same thing. What can be the possible soultions so that I can refresh my data.

Thanks in advance.

[Udam89]

Hi Team- I have tried all the above options but no luck!.. Any other thing I can do? This issue is only for one dashboard out of many I am currently working on.

[Udam89]

Thanks Guys fixed it - Had so many unwanted columns in one query so add another step where I selected all the necessary columns and clicked the "Remove Other Columns" button.

[v-yangliu-msft · Accepted solution]

Hi  @Kamana ,

You can try the following:

1. 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".

2. Or when you load, there are a lot of blank columns, you can delete their columns and refresh them.

3. To clear Power BI cache:

File --> Option and Settings --> Options

Global --> Data Load --> Clear Cache

4. Is your Power BI Desktop up to date, and if not, update it to the latest version.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

This is the related document, you can view this content:

Solved: Creating connection in model... - Microsoft Power BI Community

Solved: stucking on creating connection in model - Microsoft Power BI Community

Refresh Stuck at "Creating Connection in Model" - Microsoft Power BI Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.