cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DiegoPeres
Super User
Super User

Report for KPIs of PVA

Hi guys,
Has anyone created a report in power Bi to make more accurate PVA measurements?
I have some KPIs that I need to monitor but I do not know how to make the report, already connected to DataVerse but the tables do not bring the data I need, I believe I am not knowing how to build the report.
Here is what I want to measure.

Volume of registered topics
Title - Creator - Date Created - Date Modified
Number of accesses in the topic
Users who access the BOT

these are some of the data I need.

1 ACCEPTED SOLUTION

Accepted Solutions
DiegoPeres
Super User
Super User

I couldn't collect the information from the native Dataverse tables, so I created my own data.
I built tables in dataverse, which are populated with usage information from the bot via Power Automate. I built the BIs with the information that met my needs perfectly.

 

View solution in original post

5 REPLIES 5
Expiscornovus
Dual Super User
Dual Super User

Hi @DiegoPeres,

 

First of all, great idea! 😀

 

For the volume of registered topics you should be able to use the Chatbot subcomponent (botcomponent) table. Filter for ComponentType equals Topic.

 

chatbot_subcomponent.png

 

I will have a look at the other ones as well. Haven't found those yet.

DiegoPeres
Super User
Super User

@Expiscornovus Tks; in my view this data should be simpler so that we can improve the bot.

I was able to extract both the data from the flows, with the information I wanted, creation date, Owner, modification date, and who modified it.

Now I'm trying to get the users who access the topics to get the Dash complete, but and more complex, are many tables and a lot of information, but already managed to mount a primary relationship by ID access believe that soon I can mount everything.

Expiscornovus
Dual Super User
Dual Super User

Hi @DiegoPeres,


Have you figured out how to access the users who access the topics yet? I am exploring that as well in the nested activities collection of the Content field.

 

However, the from field looks like it has a different GUID compared to the Azure AD Object ID and the Dataverse systemuser record GUID.

Hi @Expiscornovus 

I haven't succeeded yet either.
I created a PowerAutomate in the greeting flow to collect the user ID and save it in a data verse table, today I will try to see if the Transcription of the accesses has this ID, if it is successful I will make a Query and play everything in Power BI, this week I need to solve this, people charging the DashBoard here, MS should have something simpler for us to raise these insigths.

If I get it I'll let you know!

DiegoPeres
Super User
Super User

I couldn't collect the information from the native Dataverse tables, so I created my own data.
I built tables in dataverse, which are populated with usage information from the bot via Power Automate. I built the BIs with the information that met my needs perfectly.

 

Helpful resources

Announcements
Canadian Cloud 2022 768x460.png

Register for a free PVA chatbot creation workshop.

Learn how to respond rapidly to your customers and employees at scale, using intelligent conversational chatbots.

MS Build PVA Carousel 768x480.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development for Power Virtual Agents.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Kudoed Authors
Users online (1,097)