Forum Discussion
New Agent experience - how to add Fabric data agent
Good question, this trips a lot of people up because the setup spans two products. The key thing to know is that the Fabric data agent has to be built and published in Microsoft Fabric first, and then you connect to it from Copilot Studio. You don't create it inside Copilot Studio itself.
So the rough flow looks like this:
- In Microsoft Fabric, create your data agent over the data you want it to reason on (lakehouse, warehouse, semantic model, KQL, etc.), give it good instructions and example questions, then publish it. Make sure it actually answers questions correctly in Fabric before you wire it up, since anything off there will show up downstream too.
- In Copilot Studio, open your agent in the new experience and go to the area where you add knowledge or tools. Look for the Microsoft Fabric option, and you'll be asked to authenticate.
- Sign in with an account that has access to the Fabric workspace and the underlying data, then pick the published data agent from the list.
- Save and test it with a few natural language questions to confirm it's routing through to Fabric properly.
Two gotchas worth flagging. First is permissions. The connection runs in the context of whoever authenticates, so that identity needs access to both the Fabric workspace and the data behind the agent, otherwise it'll connect but return nothing useful. Second is licensing. You need the right Fabric capacity and Copilot Studio entitlement for this integration to be available, so if you don't even see the Fabric option, that's often the reason.
Where exactly are you getting stuck? Is the data agent already built and published in Fabric, or are you at the very start? And do you see the Fabric option in Copilot Studio at all? That'll help narrow down whether it's a setup step or a licensing or permissions thing.