Hello there!

Need Help? We are right here!

support
miniOrange Email Support
success

Thanks for your inquiry.

If you dont hear from us within 24 hours, please feel free to send a follow up email to info@xecurify.com

Single Sign-on (SSO) for Power BI
miniOrange provides a ready to use SSO solution for Microsoft Power BI. This solution ensures that you are ready to roll out secure access to Power BI to your users within minutes.

Power BI SSO Login

Power BI SSO solution by miniOrange provides secure access and full control over multiple applications to enterprise users . Power BI SSO let users to Single Sign-On into Power BI account with one set of login credentials, eliminating user-managed passwords and the risk of phishing. Power BI Single Sign-On leverages the existing on-premise Active Directory infrastructure and provides seamless integration without the need to manage multiple on-premise and cloud identities.

miniOrange supports both IdP (Identity Provider) and SP (Service Provider) initiated Single Sign-on (SSO)

  • IdP Initiated Single Sign-On (SSO) for Power BI

    In IdP Initiated Login, SAML request is initiated from miniOrange IdP.

    • Enduser first authenticates through miniOrange Idp by login into miniOrange Self Service Console.
    • The Enduser will be redirected to their Power BI account by clicking the Power BI icon on the Enduser Dashboard - there is no need to log in again.

We can connect with any directory

miniOrange provides user authentication from external directories like Microsoft Active Directory, Azure AD,AWS Cognito etc.

Prerequisites

    1. Sync On-Premise Active Directory with Azure Active Directory

      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 Azure AD.

    • Download the Azure AD Connect
    • Run the Azure AD installer on your domain machine and follow the setup.

    2. Verify your UPN Domain in Azure Portal

    • In the Azure portal navigate to Azure Active Directory >> 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.
    • Power BI Single Sign-On (SSO) Add custom 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.
    • Power BI Single Sign-On (SSO) Add domain record

    • 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. Setup a Custom Branded URL in miniOrange Admin Console

Single Sign-On into Power BI requires a custom branded URL to be set. Access to miniOrange and connected resources will need to be through the custom branded URL in the format: https://<custom_domain>.xecurify.com/moas

  • Login to miniOrange Admin Console.
  • Click on Customization in the left menu of the dashboard.
  • In Basic Settings, set the Organization Name as the custom_domain name.
  • Click Save. Once that is set, the branded login URL would be of the format https://<custom_domain>.xecurify.com/moas/login
  • Power BI Single Sign-On (SSO) setting up branding

2. Configure Power BI in miniOrange

  • Login into miniOrange Admin Console.
  • Go to Apps and click on Add Applicaton button.
  • Power BI Single Sign-On (SSO) add app

  • In Choose Application Type click on Create App button in SAML/WS-FED application type.
  • Office 365 Single Sign-On (SSO) choose app type

  • In the next step, search for Office 365. Click on Office 365 app.
  • Office 365 Single Sign-On (SSO) add 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.
  • Office 365 Single Sign-On (sso) configuration steps

  • 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.
    • Office 365 Single Sign-On (sso) configuration steps
    • Using miniOrange as a User Store: Select Custom Profile Attribute and select a Custom Attribute from the drop-down.
    • Office 365 Single Sign-On (sso) configuration steps
  • 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.
  • Office 365 Single Sign-On (sso) configuration steps

3. Configure Microsoft Online Services

  • Click on Select dropdown and choose Metadata.
  • Power BI Single Sign-On (SSO) Select Metadata

  • Click on the Download Federate Domain Script button under "INFORMATION REQUIRED TO AUTHENTICATE VIA EXTERNAL IDPS"
  • Power BI Single Sign-On (SSO) Download federate domain script button.

  • 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.
  • Power BI Single Sign-On (SSO) Download Federate Domain Script

  • After downloading the script, Open PowerShell run the federate_domain script using: cd ./Downloads powershell -ExecutionPolicy ByPass -File federate_domain.ps1
  • Power BI Single Sign-On (SSO) Run Federate Domain Script

  • Your domain is now federated. Use the commands below to check your federation settings: Connect-MsolService Get-MsolDomainFederationService
  • Power BI Single Sign-On (SSO) Verify Federated Domain

Step 6: Configure 2FA for miniOrange Admin Dashboard and Power BI

6.1: Configure 2FA for miniOrange Admin Dashboard.

  • From your miniOrange Dashboard in the left navigation bar, select 2- Factor Authentication, click on Configure 2FA.

  • Two factor-authentication for Power BI | configure_2fa

  • Choose any 2FA method you want to configure.
  • Let's say you want to configure OTP over SMS
  • Click on OTP over SMS
  • Two factor-authentication for Power BI  | otp_over_sms

    Two factor-authentication for Power BI  | enter_phone_no

  • Now add your mobile number on which you want to receive the OTP.
  • Then click on Save.
  • Two factor-authentication for Power BI  | save_phone_number

    Two factor-authentication for Power BI  | otp_over_sms_active

  • Now as shown in the above image, OTP over SMS is your Active 2FA method.
  • Enable Prompt for second factor during signin to your console.
  • Then click on Save.
  • Two factor-authentication for Power BI  | enable_2fa

  • To verify the configuration login again.
  • You will be asked for Username and password then it is redirected to below page:
  • Enter the OTP received on the phone and click on verify.
  • Two factor-authentication for Power BI  |  2fa_otp_verification

  • If you are redirected to your dashboard, you have successfully configured OTP over SMS as your 2FA method.
  • Similarly you can configure rest of the 2FA methods for miniOrange dashboard by following this guide.
  • To configure 2FA methods for end-users, You can find the guide here.

6.2: Enable 2FA for Users of Power BI application.

  • To enable 2FA for Users of Power BI application. Go to Policies >> App Authentication Policy
  • Click on Edit against the configured application
  • Two factor-authentication for Power BI | Two Factor Authentication configure 2fa of application

  • Enable the Enable 2-Factor Authentication (MFA) option.
  • Two factor-authentication for Power BI | Two Factor Authentication enable 2fa

  • Click on Save.

Step 7: Adaptive Authentication with Power BI

7.1: Restricting access to Power BI with IP Blocking

    You can use adaptive authentication with Power BI Single Sign-On (SSO) to improve the security and functionality of Single Sign-On. You can allow a IP Address in certain range for SSO or you can deny it based your requirements and you can also challenge the user to verify his authenticity. Adaptive authentication manages the user authentication bases on different factors such as Device ID, Location, Time of Access, IP Address and many more.

    You can configure Adaptive Authentication with IP Blocking in following way:
  • Login to Self Service Console >> Adaptive Authentication.
  • Add a Policy Name for your Adaptive Authentication Policy.
  • Power BI Single Sign-On (SSO) Restrict Access adaptive authnetication policy

  • Select your Action for behaviour Change and Challenge Type for user from the Action for behaviour Change Section.
  • Power BI Single Sign-On (SSO) Restrict Access adaptive authentication behaviour change


    Action for behaviour Change Options :


    Attribute Description
    Allow Allow user to authenticate and use services if Adaptive authentication condition is true.
    Challenge Challenege users with one of the three methods mentioned below for verifying user authenticity.
    Deny Deny user authentications and access to services if Adaptive authentication condition is true.

    Challenge Type Options :

    Attribute Description
    User second Factor The User needs to authenticate using the second factor he has opted or assigned for such as
  • OTP over SMS
  • PUSH Notofication
  • OTP over Email
  • And 12 more methods.
  • KBA (Knowledge-based authentication) The System will ask user for 2 of 3 questions he has configured in his Self Service Console. Only after right answer to both questions user is allowed to proceed further.
    OTP over Alternate Email User will recieve a OTP on the alternate email he has configured threw Self Service Conolse. Once user provides the correct OTP he is allowed to proceed further.

  • Now Enable Enable IP Restriction option from the IP RESTRICTION CONFIGURATION section to configure custom IP range.
  • Power BI Single Sign-On (SSO) Restrict Access adaptive authentication ip blocking

  • Select the Action you want to perform if the IP address is out of the range. i.e Allow, Challenge & Deny.
  • Specify the IP Address range for which you want above setting to reflect. You can add more than one IP Address ranges by clicking on following button +.
  • Scroll to the end and click on save.


7.2: Adaptive Authentication with Limiting number of devices.

    Using Adaptive Authentication you can also restrict the number of devices the end user can access the Services on. You can allow end users to access services on a fixed no. of devices. The end users wii be able to access services provided by us on this fixed no. of devices.

    You can cofigure Adaptive Authentication with Device Restriction in follwing way

  • Login to Self Service Console >> Adaptive Authentication.
  • Add a Policy Name for your Adaptive Authentication Policy.
  • Select your Action for behaviour Change and Challenge Type for user from the Action for behaviour Change Section.
  • Power BI Single Sign-On (SSO) Restrict Access adaptive authentication behaviour and challenge type


  • Scroll down to Device Configuration section and enable Allow User to Register Device option to allow users to register their devices.
  • Enter the Number of Devices which are allowed to register in field next to Number of Device Registrations Allowed
  • Choose Action if number of devices exceeded (This will override your setting for Action for Behaviour Change.)
    1. Challenge: The user needs to verify himself using any of the three methods mentioned in table in step 7.1
    2. Deny : Deny users access to the system
  • Enable option Send email alerts to Users if number of Device registrations exceeded allowed count if you want to alert the user about no of devices exceeding the limit. Save the configuration.
  • Power BI Single Sign-On (SSO) Restrict Access adaptive authentication enable device restriction


7.3: Add Adaptive Authentication policy to Power BI.

  • Login to Self Service Console >> Policies.
  • Click on Edit option for predefined SAML app policy.
  • Power BI Single Sign-On (sso) edit device restriction policy

  • Set your application name in the Application and select password as Login Method.
  • Enable Adaptive Authentication on Policy page and select the required restriction method as an option.
  • From Select Login Policy dropdown select the policy we created in last step and click on save.
  • Power BI Single Sign-On (SSO) Restrict Access save device restriction policy

    How to add a trusted Device
    1. When End-user log in to the self service console after the policy for device restriction is on, he is provided the option to add the current device as a trusted device.

Step 8: Now sign in to your Office 365 account with miniOrange IdP by either of the two steps:

    1. Using SP initiated login :-

    1. Go to Office 365 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 Microdoft UPN to SSO into PowerBI

    5. Enter your login credential and click on Login. You will be automatically logged in to your Power BI account.
    6. Entering Office 365 Credentials you have successfully loginto Power BI using SSO

    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 Power BI account.
    3. Select office365 to Single Sign-On (sso) to PowerBI

For further details refer following Documents :

  1. https://support.office.com/en-us/article/Office-365-integration-with-on-premises-environments-263faf8d-aa21-428b-aed3-2021837a4b65
  2. http://blogs.technet.com/b/canitpro/archive/2015/09/11/step-by-step-setting-up-ad-fs-and-enabling-single-sign-on-to-office-365.aspx

Why Our Customers choose miniOrange Secure Identity Solutions ?


24/7 Support

miniOrange provides 24/7 support for all the Secure Identity Solutions. We ensure high quality support to meet your satisfaction.

Try Now

Affordable Pricing

miniorange provides most affordable Secure Identity Solutions for all type of use cases and offers different packages based on customer's requirement.

Request A Quote


We offer Secure Identity Solutions for Single Sign-On, Two Factor Authentication, Adaptive MFA, Provisioning, and much more. Please contact us at -

   +1 978 658 9387 (US)   ,   +91 97178 45846 (India)    |       info@xecurify.com