web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Databricks Connector n...
Copilot Studio
Unanswered

Databricks Connector not working

(2) ShareShare
ReportReport
Posted on by NA-20020143-0 29
I'm trying to use the Azure Databricks Execute a SQL statement to pull some data from Databricks. The connection has been set up, but when the agent calls the connector, I get this error message:
 

Error Message: Evaluating PowerFx expression resulted in error while invoking the connector : PVA.SqlExecuteStatement failed: PowerFxJsonException Expecting Record but received a String, in result/data_array Error Code: ConnectorPowerFxError 

 

I just used a standard SQL statement to pull a bunch of records. How do I fix this?

Categories:
Autonomous agents
Model context protocol
I have the same question (0)
  • lbendlin Profile Picture
    lbendlin 8,716 Super User 2026 Season 1 on at
    Is this on a private network?  Do you use a gateway?
  • NA-20020143-0 Profile Picture
    NA-20020143-0 29 on at
    Never got the tool to work. This issue would always occur when the agent invoked the tool. But the connection and SQL statement works perfectly if executed in Agent Flows as a standalone action and the output fed as a prompt to my agent. This is my current workaround.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 277

#2
11manish Profile Picture

11manish 206

#3
sannavajjala87 Profile Picture

sannavajjala87 156 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Announcing the "Microsoft Copilot Studio ❤️ MCP" lab
Block PII/PCI in Copilot Studio agent user prompt

Product updates

Microsoft Power Platform Community release plans