Skip to main content
Version: I2023.3.0

Using Power BI Service with Windows Authentication

You can publish and share reports in Power BI Service, so that other users can also run them. This can be achieved by configuring AtScale to authenticate with an external Directory that supports Windows Authentication.

note

In case you manage your users with Azure Active Directory you can choose to use token-based authentication, as described in Using Power BI Service with token-based authentication.

Before you begin

Configure authentication with external directory

You should configure AtScale to authenticate with an external Directory that supports Windows Authentication (NTLM v2). You also need to enable concurrent NTLM authentication requests. For details, see Connecting to AtScale Using Windows Authentication.

In case the Active Directory used for authentication is configured to use channel binding, you need to configure the communication between AtScale and Active Directory. For details, see Connecting to Active Directory that uses LDAP Channel Binding.

Required Azure and Power BI Services

The following services must be enabled for your account:

Configuring AtScale

info

If you are UPGRADING a system and think you should change the USER UNIQUE ID ATTRIBUTE setting please contact the AtScale Support Team first. Changing this setting after the initial system installation without the additional steps provided by the AtScale Support Team will result in service disruptions.

  1. Log in as a System Administrator to complete the following steps.

  2. Make sure Windows Authentication is enabled via the auth.ntlm.enabled engine setting.

  3. Set the AtScale Directory user identity attributes to the Directory values required by Power BI Desktop and Power BI Service.

    1. Go to SECURITY > Directory, Setup. Scroll down to the User Schema Settings section.

    2. Set the USER UNIQUE ID ATTRIBUTE value.

      This is the attribute used as the unique identifier for User Objects. Power BI Desktop users and the "service account" user that executes reports on behalf of other users will use this attribute for identification. This value is typically set to "sAMAccountName".

    3. Set the PROXY USER ATTRIBUTE value.

      This is the attribute that Power BI Gateway uses to identify report users who are impersonated by a "service account". This value is typically set to "userPrincipalName".

  4. Define a "service account". This is the account that the Power BI Gateway will use to access AtScale on behalf of other users.

    1. Create a new user or select an existing user to be the "service account".

    2. Create an AtScale role and assign it the Impersonation permission.

    3. Assign the "service account" user to the role.

    4. Assign the following permissions to this user or role. The account may have the these permissions from a different role or by explicitly adding them to the "Impersonation" role defined above.

      1. query
      2. read projects
      3. login
    5. Grant the user or role Run-time Query access to each cube you want to access from the Power BI Service.

  5. Create the standard report users in AtScale.

    These users must also have Power BI Service accounts. These users must be identified by Power BI Service and by the AtScale Directory by the "PROXY USER ATTRIBUTE". Finally these users will be impersonated by the "service account" defined in the previous step.

  6. If you wish to use the report user's identity when communicating to the data warehouse, then you must enable AtScale Impersonation when configuring the data warehouse connection.

    Data Warehouse User Impersonation is not supported for all Data Warehouses. Review the AtScale Supported Tools and Platforms documentation to learn if AtScale supports User Impersonation for your data warehouse.

Configuring Power BI Gateway

  1. Install Power BI Gateway on a Windows machine that is in the same domain as your Directory server.

    This server should be reachable from Power BI Service via a secure connection (for example, IP Sec Tunnel), and should be able to access your AtScale server. For more information see the Power BI Gateway documentation.

  2. Login to Power BI Service as a pbi service admin and go to Settings > Manage Gateways. Follow the Microsoft documentation instructions to connect to your Gateway.

  3. Click "Add Datasource" on the Manage Gateways screen.

  4. Give your AtScale datasource a name and select "Analysis Services" as the data source type.

  5. Enter the necessary connection information to connect to the AtScale server.

    1. You must use exactly the same string for the hostname that will be used in your reports authored with Power BI Desktop.

      Power BI Service and Power BI Desktop use exact string matching to find host configurations, and will not perform hostname or IP address resolution when looking up dataset connections.

    2. The user name must include your Windows domain. For example, either bob.smith@mydomain.com or mydomain.com\\bob.smith will work.

    3. For the "Database" field you must enter the AtScale "Project Name" (not the cube name).

note

You must set the same query string parameter to the "Server" field of all desired Datasource configurations.

  1. Click "Add". A connection confirmation indicates that Power BI Service successfully authenticated the service user against atscale and your directory service.

Publishing and Sharing Reports

  1. As the user in the Impersonation role, create a report using PBI Desktop connected to the AtScale cube.

    Once ready, publish the report to the PBI Service by clicking the "Publish" button in Power BI Desktop (must be logged in to Power BI Service).

  2. Using the same account that you used to author the report, log on to the PBI Service.

  3. Find the new report in the workspace you selected when publishing. Click the "Share" icon.

  4. Type in the user names of the other users that you want to run the report and click the "Share" button.

Other Power BI Service users will now be able to run the report. Additionally, their identity will be used to enforce Run-Time Cube security and will be displayed on the AtScale Query Screen.

What to do next

  1. Learn how to connect Power BI Desktop to AtScale.
  2. Build your report in Power BI. For details see Create reports and dashboards in Power BI.
  3. Review the list of AtScale's Power BI Known Issues and Limitations.