Licensing Query

[Anonymous]

Hi Guys,

I need your help and suggesstion on how I can implement the below:

With an O365 license in place-

There is a team of 10 doctors who have patients listed under their name (say 50 each)

A Dashboard needs to be created on which RLS will be implemented and each doctor will be able to view only thier patients data. 

So, 11 Pro licenses are required so far. Now the catch is, if the 500 patients need to view ONLY thier data, would that be possible under Pro (I know the Capacity license gives the feture to view data for free users but its out of budget). Even a static pdf would work if it can be sent to them on email or saved on Sharepoint or anything. The goal here is for the patients to view thier data and medical history/analysis. I know paginated report would help but again it requires a capacity license.

The other alternative which would work is creating reports/charts in excel and if there is a way to automatically create an excel dashboard for each patient and place it in their particular folder/one drive/sharepoint or share it with them on email.

**The Doctor's wont have the time to work on the data individually for each of their patients. This is a major constraint that needs to be surpassed**

Any suggesstions are welcome!! 🙂

[bcdobbs]

I've not done it myself but I think you could adapt the second section of this:

https://simplifypowerbi.com/?p=254

[bcdobbs]

There's no way round it in terms of power bi reports without premium capacity.

You could look at premium per user as a way to get pagninated reports working for you to produce pdfs etc? You'd need one per doctor.

[Anonymous]

Yes, but PPU would require the patients also to have PPU license right?

[bcdobbs]

if you wanted them to have direct access yes but you can schedule pagnitated reports to email a pdf to someone with out a license on a schedule.

Not the easiest to maintain but given licensing constraints might be your only option.

The only other option would be to look at embedded capacity purchased through azure which can be cheaper than full premium power bi but you'd have to then build an app to share the reports.

[Anonymous]

Right - So the first option you mention seems feasible. However, how can each patients data be exported from the doctors automatically. I know with Power Automate the reports that are already saved can be scheduled, however in this case how can the reports be extracted 'automatically' from PBI for each patient and then shared/saved or whatever.