How can Copilot Studio’s Code Interpreter always access a specific CSV without re-uploading?

(1) Share

Report

Posted on by CU26111039-0

Hello, I’m using Copilot Studio in my daily work.

In conversations, I often use the Code Interpreter (Python tool) to extract information. I’d like to make a certain CSV file (master data) always available for reference.

What I want to achieve:

Avoid requiring the user to upload the file every time a new conversation starts.
Ideally, set a specific CSV (e.g., product list, customer list) as a “default data source” that the Code Interpreter can automatically access.
Due to security requirements, the file must reside in protected storage within our internal tenant.

What I’ve tried / considered:

Uploading the file at the start of each conversation: works, but too much operational overhead.
Connecting data sources (SharePoint/OneDrive) in Copilot Studio: useful for knowledge-based Q&A, but there’s no mechanism to pass the file directly to Python processing in the Code Interpreter.

Question:
Is there an official way to permanently link a specific CSV file to Copilot Studio’s Code Interpreter (Python tool)?

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

HI @CU26111039-0

There is no direct way unless you want to build a plugin or use a flow to get the data. But there is no perm way as you are talking about cross topic talking?

Or do you simply mean you want everyone to have access to it (via the Code interpreter, in which case I would still say use an Agent or Power Automate directl flow to grab it

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

CU26111039-0 8 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your previous response. I’d like to clarify one point.
Currently, I’m only using the trial version of Copilot Studio, so I cannot publish an agent to Power Automate. From your answer, it sounds like it might be possible to retrieve a CSV file via Power Automate and then pass that file directly to an agent built in Copilot Studio. Is that really feasible?
To be clear:

I understand that Power Automate can retrieve a CSV file.
I also know that Power Automate can call an agent created in Copilot Studio.
However, I don’t know how to pass the retrieved CSV file as an attachment (or in any other way) to the Copilot Studio agent.

Would it be possible for you to show an example, ideally with screenshots of the flow configuration? That would be extremely helpful.
Thank you in advance!

Was this reply helpful? Yes No
CU28110631-0 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the information.

Was this reply helpful? Yes No
Suggested answer

Romain The Low-Code... 2,814 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@CU28110631-0

hello :) if you want sample if have two :

A great video from matthew wich have a lot informaiton on how to use file with ai builder prompt tool with flow : https://www.youtube.com/watch?v=JMlUcxqnU30

another one in french (but manual english subtitle, so it s ok translation :) ) wich at the end use a "fixed" file as a document to be compared with a document upload in chat by a user : https://youtu.be/rGIDE7_JwvU

i hope one of those content could you :) if yes please check the answer as validated it's important for the community and search engine

Was this reply helpful? Yes No
Suggested answer

S-Venkadesh 1,208 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @CU26111039-0,

you can use Get file content (from SharePoint or OneDrive) to read the file’s contents and then use that file for further processing.

I hope this information helps! If it does, please consider giving a 👍.
Best regards,
S-Venkadesh

Was this reply helpful? Yes No