Connect a Copilot Agent to Power BI

[AllanMou]

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

[Idrissshatila · Accepted solution]

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-sgandrathi]

HI @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.

[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.

[AllanMou]

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-hashadapu · Accepted solution]

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.

[Idrissshatila · Accepted solution]

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