As you have probably seen Power BI has introduced two new sharing paradigms:
- Apps for the consumption of the data
- App workspaces for the editing/authoring/collaborating of the data
Had a couple of customers asking about sharing their Apps and App Workspaces using AAD Security Groups. While i typically recommend the security best practice of sharing all resources with AAD Security Groups in this case Power BI doesn’t support adding AAD security groups as members of App Workspaces…But in most cases you will be sharing the resulting Power BI Apps –which CAN be shared with AAD security groups….And wanted to document how this can be accomplished.
1. Create a Group in the Office Admin Portal
2. Add the members to the AAD Group
Here you probably WILL want to use the Azure Active Directory admin center as the office Group dialog only displays Office Users not all the users in your active directory.
(Note: none of the users above show up in the “Add” dialog of the Office > Groups > Dialog as they are only actives directory users not licensed office members. )
3. Update the Power BI App to use the AAD Security Group
4. Add the AAD Security Group to the Access List for the Power BI App
Note you need the fully qualified AAD Security Group ID i.e. MyGroup@mytenant.onmicrosoft.cmo
Related and frequently asked question:
I have a premium capacity and shared the App Workspace with a Free User but they are still getting prompted: with “Upgrade to Power BI Pro” what is going on?
The issue is the fact Premium enables you to share Apps NOT App Workspaces.