Power Platform Community Forum Thread Details

How to create a Microsoft 365 Copilot Agent using Copilot Studio that can access Power BI semantic model data and then share insights via Teams.

Thank you

Categories:

Building Copilot Studio chatbots in Microsoft Teams

Hi @JD-07041904-0

1. Prepare your data

Publish your semantic model in Power BI Service

Configure permissions (users + agent access)

2. Create a Fabric Data Agent (required)

Go to Microsoft Fabric

Create a Data Agent on top of your Power BI semantic model

Define instructions (what data it can access, how it should respond)

3. Connect Fabric agent to Copilot Studio

Open Microsoft Copilot Studio

Add agent → Connect to external agent → Microsoft Fabric

Select your Fabric Data Agent

👉 Official doc:
https://learn.microsoft.com/en-us/microsoft-copilot-studio/add-agent-fabric-data-agent

4. Publish to Teams

Publish the agent

Add it to Microsoft Teams for end users

5. Share insights

Users ask questions in Teams (e.g., “sales last month”)

The agent returns insights from the semantic model

------------------------------------------------------------

If this solved your issue, please mark it as ✅ Accepted Answer.
If it helped, feel free to give it a 🩷 Like!

Best regards,
Piotr

Community site session details

How to use Power BI semantic model as a knowledge Source

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the May Top 10 Community Leaders!

Leaderboard > Copilot Studio

Featured topics

Product updates