Forum Discussion
Connect a Copilot Agent to Power BI
Hi everyone, I am working on connecting a Copilot agent that is built out in Copilot Studio, and I need to find out how to connect it to a Power BI dashboard, so it can review the data and develop commentary (which is what the Agent is built to do). Does anybody have experience in how to connect this successfully? looking for insights and guidance. Thank you, Allan
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.
6 Replies
- Idrissshatila
Super User
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
v-hashadapuCommunity Support
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.
- v-hashadapu
Hi 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.
v-sgandrathiHI AllanMou,
Thank you for your update.
Just checking in -- have you had a chance to review and try the provided solution? Kindly share the status whenever you get a chance.
Looking forward to your response.
Best regards,
Sahasra.
