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

Announcements

News and Announcements icon
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

(2) ShareShare
ReportReport
Posted on by 22
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,969 Moderator 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
    22 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,969 Moderator 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 594

#2
chiaraalina Profile Picture

chiaraalina 170 Super User 2026 Season 1

#3
deepakmehta13a Profile Picture

deepakmehta13a 118

Last 30 days Overall leaderboard