Insightful AI Builder Consumption Report or not?

Have you ever had the need to figure out who is consuming the AI Builder credits in your organization? If the answer is yes, you might have run into the same issues as I. Which is, who is consuming the credits? 🤔
The good thing about this is that Microsoft has provided a report that you can run called: AI Builder Consumption Report which shows the capacity consumption of your organization.

How to run the AI Builder Consumption Report

In order to create and run the report the following steps need to be taken:

1. Open the Power Platform Admin Center

2. From the left menu, select Resources > Capacity

3. On the Summary page, on the right-hand side, you will find the Download reports option

4. Select + New and from the report dropdown AI Builder and select Submit

5. Once the report has the status of Completed, you can once you select Download the report

When you then open the report you will see something that looks like the following:
Job done you would think 😎 Because now you would have the User GUID and then you would search for the user in the specific environment and you would have the name.

This is where I had a different experience which took me a while to figure out. Let’s start with what the documentation describes from Microsoft about how to read this report. The full documentation can be found here.

• Date: The date of the AI credits consumption.
• UserId: The identifier visible in the Dataverse User table.
• EnvironmentId: The identifier visible in your Power Apps or Power Automate URL (for example, https://make.powerapps.com/environments/%GUID%).
• EnvironmentName: The name of the environment.
• AIConsumption: Contains the number of credits consumed by the user and in the environment for a given date.
• IsTrial: If the value is TRUE, credits that have been consumed are AI Builder trial credits. More information: Ai Builder trial

UserId to me is the User GUID, of the User table. So if I create an export of the User table to Excel, my expectation would be that column A (by default hidden) will contain the User GUID.

Unfortunately, I was not able to find the User GUID in column A (User), Then I searched in the User table what other Guids are available and when I added Azure AD Object ID to my view and exported this I was able to link the AI Builder Consumption Report User to a user in Power Platform.

So to conclude, the report is insightful as long as you understand how things are referenced. Feel free to post in the comments and help me understand this or if you have recommendations regarding a capacity allocation plan of credits then please let me know.