PowerApp plan for Service Principal object in Azure AD?
I need some help regarding use of Power Apps plan. What kind of plan / license should I use to fulfill my requirements? Details below.
I've created a solution using web app for serving embedded Power BI reports (in app-owns-data scenario) with live connection to Azure Analysis Services. Authentication to tabular model data uses Effective Identity: a Service Principal object (aka SP) within security group (aka SG) in Azure AD, added to Admin role group in tabular database. The goal is to have no end-user Power BI Pro license needed.
Some reports use Power Apps to connect to underlying data, eg. to put a value in some tables, used as datasets to tabular model. I created those and publish within my company on my credentials. With the first test of the whole solution with use of Power Apps I faced a problem with its authentication: apps couldn't start without signing in. With some investigation I've learned that in our company we use Office 365 E3 licenses which include Power Apps for Office. I had one, so I was able to create and use Power Apps. Azure Admin subscribed one of the license to security group (SG). What I understand, he couldn't find the way to subscribe the license to SP object.
During the internal tests everything worked fine in our environment: I called public web app which serves reports with data, PowerApps are running and doing their job. It seemed to me, that PowerApps are running on the license subscribed for SG, where SP resides and uses the license, not on my own credentials. But probably I was wrong and it used my credentials to authenticate, because when I called public web app externally (outside of our Azure AD), the "sign in" prompt still occurs.
1) Is there any way to subscribe a license to SP object?
2) Maybe it should be a separate Power Apps plan additionally paid for SP object?
3) Or maybe I should not use SP but some other account with subscription for this app-ows-data scenario?
If you wrote all of the data to SharePoint as aggregated totals then this would work. You would be touching on the boundaries of Multiplexing which is when you specifically do something to not consume a premium license.
The other option for displaying charts in PowerApps is to parse all the aggregated totals to a chart generation service on the url and store those images on the web. PowerBI tiles in Power Apps are a little slow to load.