What sort of licensing are people using for Power BI in a multi-academy trust setting?
We are looking at sharing reports internally amongst (hundreds of) staff, but can't really justify the price of a Power BI Pro license for every user. Our first idea was to simply anonymise all of our data and remove any PII, then publish to the web and embed on a custom web-app secured with a login. However, after some quick research, I stumbled across a Power BI Community discussion (https://community.powerbi.com/t5/Service/Restrict-Publish-to-Web-Functionality/td-p/134647) which explained that although the embed links are random, they are still indexed by search engines and so generally accessible to the public. Even with anonymous data, this method would not be suitable for us to use.
We are now looking at Power BI Embedded Analytics on Azure, which works out cheaper than provisioning Power BI Pro licenses for everyone (when using the cheapest 'A1' node). We would then use our internal software dev team to create a hosted web-app with a login system, and then display embedded reports based on user access rights.
I'd love to hear what other people are doing when it comes to Power BI, and, if you encountered the same licensing issues as we are currently experiencing, how you managed to circumvent them.