Notifications
Announcements
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 topicsTitle - Creator - Date Created - Date ModifiedNumber of accesses in the topicUsers who access the BOT
these are some of the data I need.
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.
@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.
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!
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 256
Romain The Low-Code... 189 Super User 2025 Season 2
chiaraalina 119