In April 2025 we launched a set of branch dashboards in Power BI, covering sales, margin, stock and deliveries, for thirty eight branch managers and forty one assistant managers. To view reports shared from our workspace, each of them needed a Power BI Pro licence, because we do not pay for the large capacity that removes that requirement.

We assign Microsoft licences through groups. Anyone who is a member of a licence group receives its licence automatically and loses it when they are removed. For the launch an engineer added our two existing groups, Branch Managers and Assistant Branch Managers, as members of the Power BI licence group. The admin centre showed the licence assigned to the group, with no errors. Testing went well. The analysts who built the reports and the two of us who checked them could open everything.

The launch email went out at seven on a Monday. By eight the service desk had taken thirty calls. Every branch manager who opened a dashboard was told they needed a Pro licence, with a button offering a free trial. Eleven clicked it, and their dashboards worked for exactly as long as the trial lasted.

Microsoft's group based licensing does not support nested groups. A licence assigned to a group reaches only the people who are direct members of it. A group placed inside it is ignored, and nothing says so. The admin centre showed six licences in use, belonging to the analysts and the two of us, who had been added to the licence group directly while we were building the reports. That is why our testing passed.

We fixed the launch that morning by making all seventy nine managers direct members of the licence group. Their membership is now maintained by our joiner and mover process from their job in the HR system, rather than inherited from another group. We then checked every other licence group and found two more with groups nested inside them. One covered the design office's Visio licences, and two of its members had been raising tickets for a year about Visio asking to be activated.

Testing for anything that depends on access now uses an account that receives that access by the same route as the people it is for. Each licence group has a monthly report comparing the number of people meant to have the licence with the number who actually do.

Our testers had a shortcut, and the shortcut was the only route that worked.

– Serguey Shinder