Bulk assign Power BI licenses using Azure AD

Another interesting question that I got earlier this week is how to assign bulk Power BI licenses to users based on their group membership. Fortunately this turns out to be rather straight forward, as with many cases the fact that Power BI is build on top of the Azure Stack helps us out yet again. Today we will be using Azure AD Premium and the Enterprise Mobility Suite to achieve our goal.

For this purpose I went to my test tenant and activated Azure AD Premium and Enterprise Mobility Suite preview. Next I created a security group called “testgroup”:

image

 

Then I created a user in Office 365 that is member of my “testgroup” and doesn’t have a Power BI pro license (yet).

image

Now let’s assign a Power BI Pro license to all users in the testgroup. To do this I go back to Azure AD and click on licenses:

image

And then when I select “All products” I see the whole list of products in my domain, including both Power BI licenses:

image

Now to assign a license I select the group “Power BI Pro” and click on “Licensed Groups”:

image

Now I can use Assign button to add the “testgroup”, observe that the office group doesn’t show up here, I assume it doesn’t work for pure Office groups:

image

Then I assign the Power BI Pro license:

 

and when I am done I select “Assign”:

image

Now I can see the group “testgroup” has Power BI Pro licenses assigned:

image

And when I go back to the Office 365 portal I can see the user now has a Power BI Pro license:

image

 

So that is simple elegant way to assign product licenses to your organization.

2 Replies to “Bulk assign Power BI licenses using Azure AD

  1. Hi Kasper, Do you know what happens if you have purchased 20 licences and there are more than that many users in the group? – say 25 users. Is it first in gets a licence? also what if an account is disabled? ie 25 in the group but 7 accounts are disabled. If you add 1 enabled account would that account get a licence?

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.