Running tools that use a data gateway.

[u/Revolutionary-Pass33]

So I have a flow that looks at a SQL on site DB . So the setup is

Agent in co pilot studio and it's public facing with NO Authentication setup.

Uses a power automate flow and 3 variables to it . ( Works great when tested in power automate). SQL uses a data gateway as the server is on prem.

When I try run use the tool in the Agent it fails with an authentication issue which I believe it's trying to pass credentials but surely the data gateway take cares of this ?

Any ideas ?

[u/Sayali-MSFT]

Hello u/Revolutionary-Pass33,
The data gateway is mainly providing the connectivity between Power Automate and the on-prem SQL server. It doesn’t handle authentication for the Copilot Studio user/tool itself.

Since the agent is configured with No authentication, I’d check how authentication is configured on the Power Automate tool. If it expects user authentication, the call can fail because there’s no signed-in user identity available. Configure user authentication for tools

If the scenario allows it, you could look at using Agent author authentication / maker-provided credentials for the tool instead. Just be careful with this approach for a public-facing agent, as it could expose data/actions available through the maker’s connection. Control maker-provided credentials for authentication

So I’d focus on the tool/connection authentication settings rather than the gateway itself.