Forum Discussion
External Users Access to Report
- 2 months ago
Hi DPCCGF ,
For 750 external field users, the answer is app-owns-data embedding, not per-user access. You embed the report in a web app, authenticate the officers with your own auth, and the app connects to Power BI/AAS through a single service principal. The 750 never need Power BI licenses or guest accounts in your tenant, so you skip the whole per-user B2B security nightmare. If different agencies should only see their own data, you enforce that with AAS roles and effective identity in the embed token, so isolation is handled centrally rather than per user. (Skip Publish to Web here, it's fully public, which is a non-starter for law enforcement data.)
You can build this yourself with the powerbi-client SDK, but at 750 external users it's real infrastructure to stand up and maintain: capacity, embed token generation and refresh, and per-agency RLS. That's exactly the problem we solve at DataTako, an out-of-the-box embedding layer that handles the tokens, the licensing side, and the agency isolation for you, so you get the officers into the report without wiring it all up yourself. Happy to walk you through how it'd map to your AAS setup if useful.
Paco
Helping data analytics leaders distribute their reports
Hi DPCCGF,
Unfortunately, sharing a report with 750 external users is going to be a nightmare :(.
To share the report directly with them, you would need to add all users as B2B guests in your tenant, and then you can share the reports with them the same way you would share them with your colleagues.
Another option would be switching to an embedded model.
https://learn.microsoft.com/en-us/power-bi/developer/embedded/embedded-analytics-power-bi
In which you develop a custom portal/app for the external users to access, and embed your report into that app.
The third option is to open the report to the public internet and let anyone who has the link access it. This is probably a very bad idea unless the data is public data.