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