Forum Discussion
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.
Community SupportHi AllanMou , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.
Hi v-hashadapu Appreciate the input and guidance I have received, I am still working on this issue and will defintely relay back to the community the result and lessons learned on breaking down roadblocks.
- v-hashadapu
Hi AllanMou , thanks for the update. please do share the results.
