cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
digitaljonathan
New Member

Connecting Power VA with Power BI

Hey -- new here, thanks for your welcome and assistance, 

 

I have a powerBI report showing a simple analysis of some ticket sales and I'd like to build a PVA experience to allow folks to access the data. example: "how many sales for [x] event?" in pva, interrogates powerBI and returns the result.

Trouble is, I have no idea if this is possible! It might be that my imagination is much stronger than my capabilities/knowledge. All I can see in PVA is the ability to run a PowerAutomate ... and I can't see a way in PAuto to pull data so I'm at a loss to know how to proceed ... *IF* I can proceed. 

Thanks!

3 REPLIES 3
renatoromao
Super User
Super User

Hi @digitaljonathan ,

 

You can do a logic between PVA and Power BI using Power Automate workflows.

 

Deploy PVA in Power BI

Integrate Power Virtual Agents Chat Bot With Power BI Dashboard - Part Six (c-sharpcorner.com)

 

Connect PVA with Power Automate

(4) Add actions using Power Automate to a Power Virtual Agents bot - YouTube

 

Connect Power Automate with Power BI data

If you are using SharePoint, use the SharePoint connectors inside your workflow, to get the data. The same if you are using Excel, CDS (Dataverse), and much more.

You will need to structure your workflow to understand which action do you want, like "I want to see the events" (recognizing). You can implement LUIS (AI) to recognize it and return it to your Power Automate, or you can use Switch action inside Power Automate to set manually all options.

 

Maybe you will need some Pro-developer knowledge.

Feel free to reply this topic if you have any questions.


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.650 students) : English | Português
digitaljonathan
New Member

Hey Renato -- thanks for getting back to me. 

Your answers are excellent, but aren't quite what I need:

 

Deploy PVA in Power BI: Not quite the right solution --- I need PVA to *interrogate* a powerBI report. The PVA needs to sit in Teams in fact.

Add actions to PVA: There isn't an action/flow/PAuto that I can create to get data from PowerBI report I don't think? Let me know if I've misunderstood.

Connect PAuto with PowerBI data: Yes, this one looks promising. That's the route I need I think. 


renatoromao
Super User
Super User

hi @digitaljonathan ,

 

Now, I got it!

 

Deploy PVA in Power BI: Not quite the right solution --- I need PVA to *interrogate* a powerBI report. The PVA needs to sit in Teams in fact.
No, it's not possible to PVA interrogates a Power BI report.

Create your idea herehttps://aka.ms/pva/community/ideas


Add actions to PVA: There isn't an action/flow/PAuto that I can create to get data from PowerBI report I don't think? Let me know if I've misunderstood.
No, Power Automate it's available only to get data from other data sources.

Power BI - Connectors | Microsoft Docs


Connect PAuto with PowerBI data: Yes, this one looks promising. That's the route I need I think. 

You need to store your data inside a SharePoint database or SQL Server or something like that to allow your Power Autoamte search and filter data from those databases and return it back to your chatbot (PVA).


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.650 students) : English | Português

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,528)