Export Power Apps and Power Automate user licenses

This article is contributed. See the original author and article here.

Context

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 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 a local 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 sign-in as Power Platform Administrator or Global Administrator 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!

 

You can read this article on my blog here.

 

Resources

https://docs.microsoft.com/en-us/powershell/powerapps/get-started-powerapps-admin

https://docs.microsoft.com/en-us/powershell/module/microsoft.powerapps.administration.powershell/get-adminpowerapplicenses

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.