How can we connect Power Bi to Copilot Studio

(1) Share

Report

Posted on by hannguyen24

How can we connect Power Bi to Copilot Studio and build a chatbot to answer questions about the dashboard?

Categories:

General topics

I have the same question (15)

All responses (4)

Answers (0)

wswitzer 74 on at

Like (1)

Report

I'd be interested to see how this works too.

I'm presently looking into custom analytics and found this: https://learn.microsoft.com/en-us/microsoft-copilot-studio/analytics-sessions-transcripts. and this:https://github.com/microsoft/CopilotStudioSamples/tree/master/CustomAnalytics

I guess this would be the step before integrating Power BI outputs. If you have any more feedback around this on what you discover I'd be interested to read about it and can share my own discoveries as I go along with it as well. 👌🏻

Was this reply helpful? Yes No
RayBoone 77 on at

Like (0)

Report

I'm also interested in this...and if not Power BI, then what about Fabric artifacts--dataflows, warehouses, lakehouses, etc.

Was this reply helpful? Yes No
MG-07101031-0 2 on at

Like (0)

Report

Looking for something similiar . any leads or solutions would be helpful

Was this reply helpful? Yes No
Suggested answer

Vinoth Selvam 1,590 Super User 2025 Season 2 on at

Like (1)

Report

Hello hannguyen24 ,

I have'nt tried this till now. But below may be an approach that can help.

Enable the Power BI Q&A which is a natural language processing (NLP) feature that allows users to ask questions about the data in natural language. This will be the foundation for how Copilot can interpret user queries and respond with dashboard insights.

Power Automate is needed for connecting Power BI to Copilot Studio. You can create flows that trigger based on user queries to pull the relevant data from Power BI. Create a flow that listens for questions coming from your chatbot, queries the Power BI API, and sends back the relevant data.

Let me know if it works :)

Thanks.

Was this reply helpful? Yes No