Unanswered

PVA Teams Chatbot Pulling data and visuals from Power BI app

(0) Share

Report

Posted on by HenryS

The use case I'm working on needs to integrate PVA Chatbot with the Power BI report/dataset that can query PBI data and return table/chart visuals. Exactly like this blog post described:
https://botcore.ai/blog/power-bi-chatbot-power-virtual-agents/

Not sure if the solution described in that blog post used the Power BI Q&A feature or DAX queries against the dataset, but the bot's output was very useful for the Teams user.

For example, if the user asks "What are the top 5 customer orders in the healthcare segment in the last 30 days?", the bot should return a list of customers with sales amount or a chart like in the blog post.

Can someone please share some pointers on how to get that setup with PVA, Power Automate, and Power BI?

All responses (3)

Answers (0)

AnneM 3 on at

Like (0)

Report

Re: PVA Teams Chatbot Pulling data and visuals from Power BI app

Curious to know if anyone has new resources on this concept since it's been almost a year and many recent updates with PVA, Copilot and BI. Concept I'm exploring in my workplace.
anshulSingh 2 on at

Like (0)

Report

Re: PVA Teams Chatbot Pulling data and visuals from Power BI app

Hey @HenryS Did you get any updates on this story?
I was also working on the same idea over the weekend and have got something that could help.
Please respond back if we can collaborate on this.
Cheers!
Kamrani on at

Like (0)

Report

Re: PVA Teams Chatbot Pulling data and visuals from Power BI app

@HenryS - take a look at this topic (Use Power Automate flows in Power Virtual Agents - Power Virtual Agents | Microsoft Learn) which talks about using Power Automate in PVA. In Power Automate, you should be able to access the data from a backend and pass it to PVA.