List Office 365 users with Free Licence asigned

[albertoderossi]

Hi community: hope I'm on the right place to ask for this, because the relation with O365

Is there any report or Power Shell command to list those users in my tenant with Power BI Free License assigned?

Thanks in advance

Alberto De Rossi

[Icey · Accepted solution]

Hi @albertoderossi ,

You can refer to this post: Get Office 365 users with a specific license type via Powershell.

“Power BI (free) license” corresponds to "POWER_BI_STANDARD".

Get-MsolUser | Where-Object {($_.licenses).AccountSkuId -match "POWER_BI_STANDARD"}

 

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[edhans]

Export the users from the Admin panel. Their licenses are listed there and it will say "Power BI (free)" in the licenses column.