web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Creating reports on Co...
Copilot Studio
Answered

Creating reports on Copilot Studio Credit Consumption

(0) ShareShare
ReportReport
Posted on by 16
Wondering if anyone has found a way to automate the creating of the Credit Consumption for Copilot Studio Agents.
I've gone through all the Dataverse table I can think of and, although the PVA Bot Table shows a Consumption Column, but it does not break it down the type of Consumption.

If you go Power Platform Admin Center, licensing, Copilot Studio - Manage Agents and manually download the Report I get a report that shows what Feature type was consumed:
 
We want to create a dashboard that would show the Total cost of credit consumed by Environment and by Agent.
So, based on this Table:
Flow actions would cost 13 Credits.
Similar if there were say 5 Agent Actions consumed, then that would be 25 Credits.
 
I'm not sure where that report pulls back the FeatureType..
But if I can find that, then I can connect that as a source for the dashboard.
Categories:
I have the same question (0)
  • Verified answer
    Michael E. Gernaey Profile Picture
    53,442 Super User 2025 Season 2 on at
     
    Look up Microsoft.PowerApps.Administration.PowerShell and use it to pull back the data that you want.
     
    If you just google it will give you an example of how to do it. Then you can spit out the data somewhere for Power BI to pick up.
     
    If you have a hard time finding it or understanding come on back, its just a lot to paste here
     
     
    Cheers

    If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

    Thank you!
    Sincerely, Michael Gernaey
  • SM-06101152-0 Profile Picture
    16 on at
    @Michael E. Gernaey - Thank you very much for the response!
     
    I just started here 3 months ago so I am checking to see if we are allowed to use Azure Runbooks so that I can schedule this to run daily.
     
    I really do appreciate the help!!
  • Michael E. Gernaey Profile Picture
    53,442 Super User 2025 Season 2 on at
     
    You sure can then you can output it in whatever format you want to get to Power BI if that is what you want.

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.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 261 Super User 2025 Season 2

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 198 Super User 2025 Season 2

#3
S-Venkadesh Profile Picture

S-Venkadesh 93 Moderator

Last 30 days Overall leaderboard