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 (3)

Answers (0)

Sort by

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.
Power BI processes DAX queries only; it does not interpret natural language directly.
The main challenge is converting natural language (NL) to DAX, as variable passing is already supported.
Recommended Approach

Capture the user’s question in Copilot Studio as a string variable.

Send this variable to Power Automate using supported string input variables.

Within the flow:

Extract the intent or parameters (such as metric, time, or filter), or

Match the question to a predefined DAX template.

Execute the query in Power BI using “Run a query against a dataset” or the ExecuteQueries API.

Provide a concise text summary (instead of full tables) to the agent.

Deploy the agent to Teams.

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
Nivedipa-MSFT Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello LT-23020101-0,
Apologies for the confusion.

Power BI datasets (semantic models) cannot be added directly as a “Knowledge source” in Copilot Studio. Knowledge sources today support unstructured content (files, SharePoint, websites, etc.), not live structured datasets like Power BI models.

Was this reply helpful? Yes No