Power Query error 0xC0000005

Question

User reported experiencing an error (0xC0000005) when running Power Query on two different queries in Excel

LDAP settings have been verified correct

Answer 1

Hi @Simpson, Alan

There are several factors that can cause this error 0xC0000005 when running Power Query in Excel.

Could you please tell us which version of Office are you using?

• To get this information, please go to File > Account > Product Information.

Although it has been verified that the LDAP settings are correct, sometimes such errors may occur due to read permissions of data source, network connection, etc.

• If these two queries are run on other devices, will the same error be reported?

Can you test it by simplifying the query or processing it step by step?

• If a query is too complex or involves large amounts of data, it may cause conflicts during Power Query processing.

It's recommended to run Excel in Safe Mode to check whether any COM add-ins effect running queries.

• You can press and hold on Ctrl key, click or double-click Excel icon, until it asks if you want to start it in safe mode, then please release Ctrl key and click "Yes".
• Open the queries files in Excel and run queries for a check.

When this issue occurs, please check the memory occupancy in Task Management to eliminate it caused by insufficient memory.

If there is any anti-virus installed on the computer, please exit it temporarily.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---