Forum Discussion
POWER QUERY NOT WORKING !!
I’m using Office LTSC 2024, In Power Query, when I try to load data from another Excel file (or even the same workbook), I get the error:
"Microsoft Excel couldn't load a necessary component. It might have been damaged or deleted. Try reinstalling the client software or data source driver software for your database."
And also: "download failed error in data source query n connections".
Here’s what I’ve already tried:
Tested with a new blank workbook, same error appears.
Done Office repair (both offline and online), still not working.
The issue is only with Power Query loading Excel workbooks.
Could anyone please help me with this issue?
2 Replies
That's repeating of 2 weeks ago discussion Power Query Error Data Not Loading | Microsoft Community Hub
Interesting, Excel gave the same error 20 years ago, long before PQ appeared. Excel was unable to load a necessary component Maybe something else, not PQ?
This is not a general PQ bug; it’s a known limitation/compatibility problem in LTSC 2024 when loading Excel files via PQ. Using an external copy, 64-bit Office, and re-registering PQ DLLs usually resolves it.
