Using Telemetry In BC Training sandbox. Can Power BI be used to get useful reports

Power Platform
1

Our partner installed, Telemetry in BCApplicationInsights so that we can track our users in the Training Sandbox to see what they are doing in BC. Such as what menus links, reports they are using and how much time are they spending in BC.

The problem I am running into, is you don’t see the user’s name. You see a big set of hex. number identifying a user. Ex. dde915e2-fca7-49a8-b3c0-2cb7397eeff9. This does not help me when I want to run a report.

Is there anyway to get some nice reports from Power BI? Anybody got any ideas on how to accomplish this?

Thank you.

2

Interesting question. I’m going to take a look.

3

Hi @Randy_Duly,

I think this is something related to protect user data. But if you need this info and you have access to users section in Azure Portal, you can download the user list as CSV, import this file to your PBI and do some work to link the “id” column from the CSV file to the data you need.

Best regards.

4

Yes, Power BI can definitely be used to generate useful reports from Telemetry data in a Business Central (BC) Training Sandbox. Since telemetry provides insights into user activities, system performance, and errors, Power BI can help visualize and analyze this data effectively.

5

Hi Randy,

Since Telemetry reliably records the technical Object ID (the hex string), we just need to match it to a friendly name.

  1. Extract the Mapping: Get a simple list (a dictionary) from your Microsoft 365 Admin Center or Azure portal. This list must have two columns: the user’s Object ID and their Email Address or Full Name.

  2. Lookup in Power BI:

    • Load both the Telemetry Data and your new User Mapping Table into Power BI.

    • Create a relationship (join) between the Telemetry table’s “User ID” (the hex number) and the Mapping Table’s “Object ID.”

By creating this simple link, you can now pull the friendly name from the Mapping Table and use it in all your reports, making your usage metrics immediately useful for tracking your trainees!

If you have a problem, we can have a quick knowledge-sharing call to help you find a solution.
Email: Hardik.gupta@allgrowtech.com