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.760 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.760 students) : English | Português

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Virtual Agents Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Virtual Agents!

Top Kudoed Authors
Users online (1,886)