9,656 questions
Have you looked at the Microsoft 365 Usage Analytics app? https://learn.microsoft.com/en-US/microsoft-365/admin/usage-analytics/usage-analytics?view=o365-worldwide
How to generate M365 Product license report in Power BI
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 48%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
igibason
35
Reputation points
Hello Everyone,
I see the Usage Report in the M365 Admin Center and they are helpful. However, I am looking for a way to generate a report on our product licensing usage. Similar to the view from the Entra ID -> Licenses -> All Products. Where it shows the friendly name of the product (e.g. MS 365 A5 for faculty) along with the Total, Assigned, and Available.
Then I wanted to share this Power BI report to my managers. This way they can get a real time view of our current license usage.
Is there a pre-built Power BI report that can be run?
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Windows for business | Windows Server | User experience | PowerShell
Microsoft Security | Microsoft Graph
13,724 questions
{count} vote
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 24%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENP%3C/text%3E%3C/svg%3E)
Nicole Ponce 0 Reputation points2025-04-18T21:13:20.41+00:00 Hi @igibason ,
I created a comprehensive guide specifically for that :
https://publish.obsidian.md/networkgirlie/00_NG/Power+BI/Create+M365+License+Dashboard/0+Game+Plan -
D S Niranjan Babu Vallabhaneni 15 Reputation points2025-05-14T20:45:34.25+00:00 Hi @Nicole Ponce , Your report looks great, and it's an amazing solution! The only issue is that your second query doesn't include pagination. If you can adjust the query to incorporate pagination, it will become the go-to solution for Power BI reporting.
Sign in to comment
1 answer
Sort by: Most helpful
-
Vasil Michev 119.6K Reputation points MVP Volunteer Moderator2024-02-01T07:57:55.1733333+00:00 -
igibason 35 Reputation points
2024-02-01T15:00:09.79+00:00 Thanks for the link. Unless I am missing something, I do not see a way to view all the project license from there along with the count and how many licenses are left. I am looking to produce something from this page.
Sign in to comment -