Answered

Report for KPIs of PVA

(0) Share

Report

Posted on by DiegoPeres

327

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.

Categories:

Topic creation & management

I have the same question (0)

All responses (5)

Answers (1)

Expiscornovus 33,784 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

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

Was this reply helpful? Yes No
DiegoPeres 327 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Expiscornovus 33,784 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
DiegoPeres 327 on at

Like (1)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Verified answer

DiegoPeres 327 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No