Why does the Copilot Agent's Code Interpreter not load the required libraries to read PDF documents?

Question

I am encountering an issue while using a Copilot Agent with the Code Interpreter turned on. When the Code Interpreter is turned off, the Copilot Agent fails. Here is the error message from the Copilot chat I receive:

I attempted to read the [PDF Document] and extract the information as requested. However, I encountered some issues with the tools required to process the document.

Here is a step-by-step approach I took to tackle the problem:

I tried to fetch the content of the document directly, but it was not successful. I then attempted to read the PDF document using Python libraries to extract the relevant sections and save them in an Excel file. Unfortunately, there were errors related to missing modules and other issues. As an alternative, you can try the following steps on your own system:

Ensure you have the necessary Python libraries installed, such as PyMuPDF or PyPDF2 and pandas. Use the code snippets provided to read the PDF document and extract the relevant sections. Save the extracted information in an Excel file. If you need further assistance with running the code or have any other questions, please let me know! I'm here to help.

What I Have Tried:

• I have tried to ask the Copilot Agent to load the Python libraries (PyMuPDF, PyPDF2, pandas).
• Despite these efforts, I continue to encounter errors related to missing modules and other issues.

Additional Information:

When I use a normal Copilot chat, there are no errors, and the document is read correctly, with an Excel file created successfully. I can even see the Python code.

I would appreciate any guidance or suggestions on how to resolve this issue. Thank you!