During a Power Platform audit for a customer, I was looking for exporting all user licenses data into a single file to analyze it with Power BI. In this article, I’ll show you the easy way to export Power Apps and Power Automate user licenses with PowerShell!
Download the user licenses
To do this, we are using PowerApps PowerShell and more particular, the Power Apps admin module.
To install this module, execute the following command as an administrator:
Install-Module -Name Microsoft.PowerApps.Administration.PowerShell
Note: if this module is already installed on your machine, you can use the Update-Module command to update it to the latest version available.
Then to export user licenses data, you just need to execute the following command and replace the target file path to use:
Get-AdminPowerAppLicenses -OutputFilePath <PATH-TO-CSV-FILE>
Note: you will be prompted for your Microsoft 365 tenant credentials, you need to be Power Platform Administrator or Global Admin to execute this command successfully.
After this, you can easily use the generated CSV file in Power BI Desktop for further data analysis:
Happy reporting everyone!