Forum Discussion
Power BI Login Loop
Hi Anonymous
Please try creating a service account in AD that was synced to the O365. Make the user an actual service account on the server where installed the gateway on and then gave it a Power BI license on O365.
Also, make sure that the account is added to the local security policy “Log on as a Service”, you can use the following steps to add the "Log on as a service" right to an account on your local computer.
1. Open Local Security Policy.
2. In the console tree, double-click Local Policies, and then click User Rights Assignments.
3. In the details pane, double-click Log on as a service.
4. Click Add User or Group, and then add the appropriate account to the list of accounts that possess the Log on as a service right.
Hi,
thanks for the suggestion. I dont believe that this is an on-premise application server issue however. It appears to be an authentication issue between Azure and PowerBI.
Putting the on-premise server aside for the moment, I can't even log into https://powerbi.microsoft.com/en-us/landing/signin/ successfully. When clicking on sign in with my user account I am presented with the Azure login screen "Pick an Account" which prompts me to select my account. When selecting my account it looks like it is going to authenticate and then just returns back to the same "Pick an account" screen.
My account has the Free PowerBI license associated with it in Azure.
If I look at the Azure sign in logs for my account I see the following:
The service principal for resource '{identifier}' is disabled. This indicate that a subscription within the tenant has lapsed, or that the administrator for this tenant has disabled the application, preventing tokens from being issued for it.
This is similar to the errror log from the server when attemting to log in.
I assume that I dont have the required pre-requisites configured within Azure. Is there something addtional required to get this working?
Thanks,
Ben
Further testing indicates that this issue is related to our Azure license / subscription or Azure configuration.
If I log into a the Power BI website using a different Microsoft organization account I am successful and similarly the On Premise Gateway registration is successful. I cant however use this organization account.
Both of the organizations have the Power BI free subscription. The only difference is that the non working organization uses SSO. Could this be the issue? Are there any other requirements?
Thanks,
Ben