Connect a Copilot Agent to Power BI

Hello AllanMou ,

check if these would work for your case

1. Guide to Copilot in Power BI Embedded | Features, Limits & ISV Scenarios 

2. Solved: Re: Copilot for Power BI Embedded - Microsoft Fabric Community

Hi AllanMou , Thank you for reaching out to the Microsoft Community Forum.

What you want to do is not supported as a direct, built-in connection today. A Copilot Studio agent cannot natively connect to a Power BI report or semantic model and read its data. There is no “add Power BI as a data source” option for Copilot Studio.

To make this work, you have to put an API in between. You query the Power BI dataset using the Power BI REST API (ExecuteQueries) or the XMLA endpoint, wrap that query in an Azure Function, Fabric Notebook or Power Automate flow and then expose it as an Action in Copilot Studio. The agent calls that Action, gets back tabular results and uses them to generate commentary.