Power BI Single Sign-On (SAML SSO)

---

Power BI SAML Single Sign-On (SSO) solution by miniOrange provides secure Single Sign-On access into Power BI using a single set of login credentials. This allows organizations to secure access to their Power BI team and easily manage user access, while also providing a seamless login experience for users.

With miniOrange Power BI SSO, you can:

• Enable your users to automatically login to Power BI
• Have centralized and easy access control of the users
• Connect easily with any external identity source like Azure AD, ADFS, Cognito, etc

Supported SSO Features

miniOrange Power BI SAML integration supports the following features:

• SP Initiated SSO Login: Users can access their Power BI account via a URL or bookmark. They will automatically be redirected to the miniOrange portal for login. Once they've signed on, they'll be automatically redirected and logged into Power BI.
• IdP Initiated SSO Login: Users need to login to the miniOrange first , and then click on the Power BI icon on the applications dashboard to access Power BI.(If you have set up any more Identity Sources, you will log in to that platform).

Prerequisites

1. Sync On-Premise Active Directory with Microsoft Entra ID

NOTE: If you want to use your On-Premise Active Directory as a user store to Single Sign-On into Power Bi then follow the below steps to sync your AD and Microsoft Entra ID.

• Download the Microsoft Entra ID Connect
• Run the Microsoft Entra ID installer on your domain machine and follow the setup.

2. Verify your UPN Domain in Azure Portal

• In the Azure portal navigate to Microsoft Entra ID >> Custom domain names and click on Add custom domain.
  
• Enter the full domain name in the right pane that pops up and click on Add domain.



• A new window will open up with TXT/MX records for the domain. You will have to add the resented entry in your domain name registrar.



• Click on verify once you have added the entry

Follow the step-by-step guide given below for Power Bi Single Sign-On (SSO)

1. Configure Power Bi in miniOrange

• Login into miniOrange Admin Console.
• Go to Apps and click on Add Application button.



• In Choose Application Type click on Create App button in SAML/WS-FED application type.



• In the next step, search for Office 365. Click on Office 365 app.



• Make sure the SP Entity ID or Issuer is: urn:federation:MicrosoftOnline
• Make sure the ACS URL is: https://login.microsoftonline.com/login.srf
• Click on Next.



• Configure Name ID based on the User Store you are using:
  • Using Active Directory / miniOrange brokering service: Select External IDP Attribute from the dropdown and add objectguid in the text-box that appears.
  
  
  
  • Using miniOrange as a User Store: Select Custom Profile Attribute and select a Custom Attribute from the drop-down.
  
• Set the login policy. You can choose to enable 2FA for login or have users login using a standard username-password.
• Click on Save to configure Office 365.

2. Configure Microsoft Online Services

• Click on the icon ' ' and choose Metadata.
  



• Click on the Download Federate Domain Script button under "INFORMATION REQUIRED TO AUTHENTICATE VIA EXTERNAL IDPS"



• Enter the domain name that you want to federate and click on Download. Note: You cannot federate your default "onmicrosoft.com" domain. To federate your Power Bi tenant, you must add a custom domain to Power Bi.



• After downloading the script, Open PowerShell run the federate_domain script using:
  cd ./Downloads powershell -ExecutionPolicy ByPass -File federate_domain.ps1



• Your domain is now federated. Use the commands below to check your federation settings:
  Connect-MsolService Get-MsolDomainFederationService

4. Test SSO Configuration

1. Using SP initiated login :-

1. Go to Office 365 - Power Bi Login and click on sign-in
2. You will be redirected to Microsoft Online portal. Here you have to enter the UPN of the user.(It should contain the domain that is federated with miniOrange)
3. Now you will be redirected to miniOrange IdP Sign On Page.




4. Enter your login credential and click on Login. You will be automatically logged in to your Office 365 account.




2. Using IdP initiated login :-

1. Login to your miniOrange Self Service Console as an End User and click on the Office 365 icon on your Dashboard.
2. Once you click on Office 365 you don't need to enter credentials again you will be redirected to Office 365 account.

Troubleshooting

External References

• Know More about Single Sign-On (SSO)
• Read more about SAML SSO
• Microsoft Apps + miniOrange