Skip to main content

Notifications

Power Platform Community / Forums / General / PVA to answer question...
General
Unanswered

PVA to answer questions related to a dataset

Posted on by

Hi,

 

I'm trying to achieve the following: create a chat bot that answers questions from a user related to a dataset (Example: Power BI). 

 

Example: If the user asks a question "Which site has the least turnover?". The chat bot should be able to analyze the data set and give an appropriate response to the user. 

 

I've explored the option of adding a share point/ OneDrive file. I would like to know if there are any other approaches to doing this.

Categories:
  • MisterMark Profile Picture
    MisterMark 70 on at
    Re: PVA to answer questions related to a dataset

    Yes, this is definitely possible. The high-level steps would be
    1 - Create a Power Automate flow to get the data you need for the bot to respond properly..
    https://learn.microsoft.com/en-us/power-virtual-agents/advanced-flow-create?source=recommendations
    2 - Call a flow as an action with PVA
    https://learn.microsoft.com/en-us/power-virtual-agents/advanced-use-flow
    3 - Add variables if needed
    https://learn.microsoft.com/en-us/power-virtual-agents/advanced-flow-input-output
    4 - Return the results
    https://learn.microsoft.com/en-us/power-virtual-agents/advanced-flow-list-of-results


    Have you used any Dataverse tables yet? This article path focuses on using Dataverse as a table data to return the question from.

    It seems like you have the data already in Power BI. You can query the Power BI Dataset for the site with the least turnover in DAX or JSON with the built-in connector in Power Automate. On the step where you connect to Dataverse you can switch from Dataverse to Power BI in the Power Automate connections.

    MisterMark_0-1692982732723.png

    @MounikaBanda let me know if this idea helps you out and mark this as the solutions if it does. I am trying to answer questions and win a trip to the https://www.powerplatformconf.com/ 🙂

    Visualizing the Flow.

    MisterMark_1-1692982856137.png

     

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
renatoromao Profile Picture

renatoromao 6,459

#2
Pstork1 Profile Picture

Pstork1 1,968

#3
Expiscornovus Profile Picture

Expiscornovus 1,671