Yo Motherboard

How to Check Visio and Power Apps Usage via PowerShell?

January 17, 2026 3 answers
Asked by TechieTraveler99
Hey everyone! I'm looking for some help with scripting in PowerShell. I need to check the usage of Microsoft Visio and Power Apps in our Microsoft 365 tenant for users who have licenses for these applications. Specifically, I'm interested in creating a CSV file that includes the user's display name or email address if they have a license for either product. Additionally, I want to know the last usage date for those apps, but only if it's older than 30 days or if it's never been used (null). I have Visio Plan 2 and Power Apps Premium in use. Even though I've searched online and played around with tools like Gemini, I'm struggling to find a working script. The usual APIs like "getVisioUserDetail" or "GetMgReportOffice365ActiveUserDetail" haven't returned the information I need, and it feels like Microsoft's API support for tracking these apps is pretty limited. I'd love any help you can offer so I can automate this process and have the data emailed to my manager at the end of the month. Thanks in advance!
Microsoft 365 power apps PowerShell Programming usage tracking Visio

Answers

ScriptSavant42
From what I know, there isn't a direct API that gives you the data you're looking for. Your best bet is to check the Admin Center under Reports > Usage > Visio. It provides some data, but it might not be exactly what you want, especially for automation purposes.
Reply to this answer
CodeCatcherX
You might want to check GitHub to see if any script libraries have what you're looking for. Libraries like admindroid or O365reports could have something already developed that might save you some time.
Reply to this answer
DataDiver77
You might be on the right track! While that method works, there is actually an OData API endpoint where you can retrieve such reports. It's a bit complex, but if you try this endpoint: https://reports.office.com/pbi/v1.0/, you might be able to extract the info you need. Additionally, there's a Microsoft Knowledge Base article that could help you navigate through the reporting APIs. Here's the link: https://learn.microsoft.com/en-us/microsoft-365/admin/usage-analytics/customize-reports?view=o365-worldwide#use-the-reporting-apis. Good luck!
Reply to this answer

Add your answer

Answers are reviewed before publication.

Related Discussions