Integration of Fabric Data Agent with Copilot Studio

[dalsin]

Hi All,

I'm trying to integrate the Fabric Data Agent with Copilot Studio, but I’m encountering the following error:

Error Message:

connectorRequestFailure: The connector 'Fabric data agent' returned an HTTP error with code 400. Inner Error: The response is not in a JSON format.

In Copilot Studio, I’ve provided both the Workspace ID and the Agent ID while configuring the Fabric Data Agent under Tools using the Fabric MCP connector. However, the agent fails to respond correctly when invoked.

Am I missing a specific configuration step or response formatting requirement?

Has anyone successfully integrated Fabric Data Agent with Copilot Studio? If so, could you please share the steps you followed or any tips for resolving this?

Thanks in advance!

[v-priyankata]

Hi @dalsin 
Thank you for reaching out to the Microsoft Fabric Forum Community. @burakkaragoz Thanks for the inputs.

Thank you for informing us that you directly added the Fabric Agent and were able to use it without any problems. Please contact the community if you have any other issues. We are happy to help you.

Thanks.

[v-priyankata]

Hi @dalsin 

Thank you for information, Please feel free to contact us if you have any further questions. We are happy to help you.

[v-priyankata]

Hi @dalsin 

Hope everything’s going smoothly on your end. if you have any other issues please reach community.
We are happy to help you.

[dalsin]

Instead of using the Data Agent MCP, I directly added the Fabric Agent and was able to use it without any issues.

[Hashwanth]

Hi,
I've been experiencing the same issue, as DLP is blocking me in most of my environments (personal dev, declarative, etc.). Do you know why this might be happening, or are you using a particular configuration or environment?

[dalsin]

I was able to make it work by adding Fabric Data agent to Copilot Stuido Agent but not using the Data Agent MCP

[burakkaragoz]

Hi @dalsin ,

This is a pretty new integration and honestly, it's kind of finicky right now. That HTTP 400 "not in JSON format" error is annoying but not uncommon with these early Fabric integrations.

First things to check: Your Fabric Data Agent might be returning HTML error pages instead of JSON - this happens a lot when there's an auth issue or the agent isn't properly set up. Try hitting the agent directly outside of Copilot Studio to see what it's actually returning.

Common gotchas:

• Make sure Generative Orchestration is turned on in your Copilot Studio agent (it's required for MCP)
• Double-check those IDs - workspace ID and agent ID need to be exact
• The agent needs to be published and actually working in Fabric first

What's probably happening: The Fabric agent is likely throwing an error (maybe a 401 or 403) that's coming back as HTML instead of JSON, and Copilot Studio doesn't know what to do with it.

Quick test: Can you query the Fabric Data Agent directly from Fabric? If that's not working, then the Copilot Studio integration definitely won't work.

This whole Fabric + Copilot Studio thing is still pretty rough around the edges. I've seen similar issues where people had to recreate the connector from scratch to get it working. Not ideal, but sometimes that's what it takes with these preview features.

What response are you getting when you test the agent directly in Fabric?

---

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

This response was assisted by AI for translation and formatting purposes.