Forum Discussion
Refresh stuck on "Creating Connection in Model"
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.
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.
3 Replies
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.
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.
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.
