SOLVED

very very simple query to append tables (connections) make Excel freeze

New Contributor

HI

OS

Edition Windows 10 Home
Version 21H1
Installed on ‎9/‎15/‎2020
OS build 19043.1237
Experience Windows Feature Experience Pack 120.2212.3530.0

 

Device


Processor AMD Ryzen 7 5800X 8-Core Processor 4.30 GHz
Installed RAM 16.0 GB
System type 64-bit operating system, x64-based processor

Microsoft® Excel® for Microsoft 365 MSO (Version 2109 Build 16.0.14430.20256) 64-bit

 

I managed to scope down the problematic portion of my working file to just this sheet, and surprisingly what cause my refresh all to freeze for several minutes is this simple query to a consolidate tables by appending the connections, in the early version of this file no problem at all, the refresh done instantly, not sure at which point and how this become corrupted?

this happen both in my work laptop and my personal PC (this one)
any idea?

 

 

2 Replies
I disabled all COM add-in, tried it in safe mode, all doesn't seems to work.
best response confirmed by allyreckerman (Microsoft)
Solution
Oh, I found the culprit, .xlsb is not supported by power query, and even if you turn the file back from .xlsb it wont fix