web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Copilot Studio - conne...
Copilot Studio
Suggested Answer

Copilot Studio - connect to Power BI Semantic Model

(1) ShareShare
ReportReport
Posted on by 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!
I have the same question (0)
  • Suggested answer
    Nivedipa-MSFT Profile Picture
    Microsoft Employee on at
    Hello  ,
    Thanks for bringing this issue to our attention. 

    Recommended Approach: Utilize Power BI's Built-in Integration

    1. In Copilot Studio, go to Knowledge and add a Power BI dataset.
    2. The agent can then automatically query the dataset using natural language.
    3. This method does not require a separate flow.

    Alternative Option: Implement a Custom Action Flow

    1. Create a flow with an input parameter:
      Input: userQuery (text)
      Action: Run a Power BI DAX query
      Output: results
    2. In Copilot Studio, call this action:
      Pass: {System.Activity.Text}
    3. 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.
  • LT-23020101-0 Profile Picture
    Microsoft Employee on at
    Thanks  for your response. I could not find Power Bi dataset to add as a knowledge in copilot studio, is there anything I am missing? 
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 161

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 130 Super User 2026 Season 1

#3
Arild Aarnes Profile Picture

Arild Aarnes 61 Super User 2026 Season 1

Last 30 days Overall leaderboard