azureblog.co.uk
← cd ~/licences
// licences · sku

POWER_BI_ADDONPower BI for Office 365 Add-On

POWER_BI_ADDON is the SKU part number Microsoft uses for Power BI for Office 365 Add-On. You'll see it in Graph, PowerShell, licence reports and group-based licensing errors.

Product namePower BI for Office 365 Add-On
String ID (SkuPartNumber)POWER_BI_ADDON
GUID (SkuId)45bc2c81-6072-436a-9b0b-3b12eefbc402
Service plans2

Service plans included (2)

Service planNameID
BI_AZURE_P1MICROSOFT POWER BI REPORTING AND ANALYTICS PLAN 12125cfd7-2110-4567-83c4-c1cd5275163d
SQL_IS_SSIMMICROSOFT POWER BI INFORMATION SERVICES PLAN 1fc0a60aa-feee-4746-a0e3-aecfe81a38dd

Is it in your tenant?

powershell3 lines
Connect-MgGraph -Scopes "Organization.Read.All"
Get-MgSubscribedSku | Where-Object SkuPartNumber -eq "POWER_BI_ADDON" |
    Select-Object SkuPartNumber, ConsumedUnits, @{ n = "Purchased"; e = { $_.PrepaidUnits.Enabled } }

Assign it to a user

For more than a handful of people, use group-based licensing instead. The user needs a usage location set first.

powershell3 lines
Connect-MgGraph -Scopes "User.ReadWrite.All"
Set-MgUserLicense -UserId "jane.doe@contoso.com" `
    -AddLicenses @{ SkuId = "45bc2c81-6072-436a-9b0b-3b12eefbc402" } -RemoveLicenses @()

Who has it?

powershell4 lines
Connect-MgGraph -Scopes "User.Read.All"
Get-MgUser -Filter "assignedLicenses/any(x:x/skuId eq 45bc2c81-6072-436a-9b0b-3b12eefbc402)" `
    -ConsistencyLevel eventual -CountVariable n -All |
    Select-Object DisplayName, UserPrincipalName

Similar licences

These share the most service plans with POWER_BI_ADDON.

Search all 620 SKUs →

Sources