News & Blog

Power BI user management gets easier

I’ve recently discovered that Microsoft Teams associated with Office 365 groups can now have members assigned dynamically. This is good news because Microsoft Teams translates to workspaces with Power BI.

Power BI has been tricky to manage for organisations with a large number of employees as it wasn’t possible to assign security or distribution groups to workspaces. This issue was largely resolved under the improved workspaces but these still don’t create associated 365 groups for easy updating – they need to be managed within Power BI itself. Dynamic 365 groups could change all this as follows;

Rules are set for all users associated to a group and then the system does the work for you. For example, if any factor changes within a 365 group in a particular organisation; a new employee, a change of location, or someone leaving the business, the dynamic 365 groups are updated to reflect this. This is especially useful where there’s high staff turnover or a large number of temporary contractors. 

The commitment is to an Azure Active Directory P1 or P2 licence at £4.50 to £6.70 per user per month. I haven’t hit the limits on Microsoft Teams yet but it is subject to restrictions; having said that, a team can have 2,500 members and the maximum number of teams on a tenant is 500,000.

If you’d like to know more about integrating Microsoft Teams with Power BI, email me on