Forum Discussion

LB_Team's avatar
LB_Team
Advocate I
1 year ago
Solved

PowerBi chatbot in Copilot Studio

Hi everyone, I'm exploring the idea of building a chatbot using Copilot Studio (formerly Power Virtual Agents) that can answer natural language questions based on a Power BI dataset for example: ...
Need Help
Tutorial Requests
  • LB_Team's avatar
    LB_Team
    1 year ago

    okay i got a plugin like
    run a query against dataset I gave my workspace, dataset but in query what should I give? beacause i dont want to query for a specific visual or measure in my dashboard . I wanted to be dynamic like any a question I ask wrt to the dashboard I made i must get the answer from the chatbot.

BhavinVyas3003's avatar
BhavinVyas3003
Super User
1 year ago

 

  • Publish your Power BI dataset to a Premium or PPU workspace.
  • Go to Copilot Studio > Create a Copilot.
  • In your bot, go to Plugins > Enable Power BI plugin > Connect to your dataset.
  • Create topics with trigger phrases (e.g., "This month's sales").
  • Add Power BI plugin in topic to run natural language queries.
  • Test and publish the bot to Teams or Web.
  • LB_Team's avatar
    LB_Team
    Advocate I
    1 year ago

    okay i got a plugin like
    run a query against dataset I gave my workspace, dataset but in query what should I give? beacause i dont want to query for a specific visual or measure in my dashboard . I wanted to be dynamic like any a question I ask wrt to the dashboard I made i must get the answer from the chatbot.

  • LB_Team's avatar
    LB_Team
    Advocate I
    1 year ago

    There is no special plugin to powerbi
    i can find only Refresh a dataset in powerbi Plugin

  • JamesAshworth's avatar
    JamesAshworth
    New Member
    9 months ago

    Hi BhavinVyas3003, I am eager to get your solution working but am not seeing the plugins section on my copilot studio. Any help would be appreciated. My goal is to have a bot in teams that I can ask natural language questions to about a data set. Thanks!