Hi everyone! I'm looking for some assistance with scripting in PowerShell to track the usage of Visio and Power Apps within our Microsoft 365 tenant. We have licenses for Visio Plan 2 and Power Apps Premium, and I need to generate a CSV file containing the following information: 1. User's display name or email address if they have a license for Visio or Power Apps. I'm okay with creating two separate CSVs for each application. 2. The last usage date of each app, but only if it's older than 30 days or if the user has never used the app. I've tried some existing scripts online but they rely on APIs like "getVisioUserDetail" or "GetMgReportOffice365ActiveUserDetail," which haven't worked for me. The purpose of this script is to automate the process and email the summary to a manager at the end of the month, since the native reports from the Admin Center don't fully meet my needs. Any tips or guidance would be greatly appreciated! Oh, and if possible, I'd like to include usage data for Project too.
1 Answer
From what I know, obtaining the usage data you're after can be tricky. It seems that there isn't a direct API to get Visio usage specifically. The best method I've found is to check the Admin Center under Reports > Usage > Visio. However, you might be limited there.
Haha, you're spot on about that! But did you know you can actually access that data via an OData API endpoint? Check this out: reports.office.com/pbi/v1.0/. There's more info on using PowerBI with the OData feed, and it’s doable with PowerShell once you navigate the query syntax.