PVA to answer questions related to a dataset

(0) Share

Report

Posted on by MB1567

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:

General

All responses (1)

Answers (0)

MisterMark 70 on at

Like (1)

Report

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.
@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.