Copilot Studio - connect to Power BI Semantic Model

(1) Share

Report

Posted on by LT-23020101-0 Microsoft Employee

Hello!

Use case description: I am working on a use case to build an AI Agent, that reads user's natural language - connect to power BI semantic model, fetch data and respond back to user. This agent has to be published on teams.

Solution: I have used topics to capture user's input. Created a tool (power automate flow that connects to power BI), and I am stuck at a step where we need to pass user's input dynamically and fetch data. Any pointers on how this can be done are really helpful.

Also, please advise if there is any other better way to build an agent for this use case.

Thanks in advance!

Categories:

Building Copilot Studio chatbots in Microsoft Teams

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Nivedipa-MSFT Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hello LT-23020101-0,
Thanks for bringing this issue to our attention.
Recommended Approach: Utilize Power BI's Built-in Integration

In Copilot Studio, go to Knowledge and add a Power BI dataset.

The agent can then automatically query the dataset using natural language.

This method does not require a separate flow.

Alternative Option: Implement a Custom Action Flow

Create a flow with an input parameter:
Input: userQuery (text)
Action: Run a Power BI DAX query
Output: results

In Copilot Studio, call this action:
Pass: {System.Activity.Text}

Use the Generative Answers node (rather than Topics) to let the agent determine when to trigger the action.

Please let us know if you have any further query here.

Was this reply helpful? Yes No
LT-23020101-0 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks Nivedipa-MSFT for your response. I could not find Power Bi dataset to add as a knowledge in copilot studio, is there anything I am missing?

Was this reply helpful? Yes No