Forum Discussion
unable to do a simple query on power query Container unexpectedly exited. Exit code: 0x80131700. PID
Hi nickamaro ,
This error message can occur due to various reasons such as insufficient memory, corrupted files, or issues with the Power Query engine. Here are some steps you can try to resolve this issue:
- Increase the available memory for Power BI Desktop by closing other applications.
- Restart your computer and run it again.
- Update Power BI Desktop to latest version.
- Try to replicate the issue on a different machine to see if the issue is specific to your machine.
- Check if there are any corrupted files in your data source and try to repair or replace them.
- Try to disable the load preview rows option in the Power Query Editor options and see if that resolves the issue.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Increase the available memory for Power BI Desktop by closing other applications.
I could try with nothing else opened. The issue still happens.
I7 processor and 16gb of ram
2. estart your computer and run it again.
Done. Same issue. Done
3.update Power BI Desktop to latest version.
Is an organization computer. Does not show pending update office 2019 license.
3.Try to replicate the issue on a different machine to see if the issue is specific to your machine.
The file is a test file with 2 raw and 3 columns.
- Check if there are any corrupted files in your data source and try to repair or replace them.
Repair office and reinstalled
Short file 2 raw and 3 colum
- Try to disable the load preview rows option in the Power Query Editor options and see if that resolves the issue.