Using AtScale With Microsoft Power BI Desktop

Before you begin

Setting up authentication

You need to ensure authentication is configured in one of the following ways.

Token-based authentication

Make sure Azure AD is configured and tokens are enabled, and generate and copy your personal token. For details, see Using token-based authentication

Windows authentication

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.

Optionally, you can enable Xpress compression to improve the communication. To do this, you can the turn on soap.xpress.enabled engine setting. For more information, see Changing Engine Settings.

Connecting Power BI Desktop to an AtScale Cube

  1. In Microsoft Power BI Desktop, select Get Data > [more] > SQL Server Analysis Services database. Click Connect.

  2. In the dialog's Server field, enter the following:

    • When using Windows authentication, enter the MDX connection URL; for example: http://atscale-host:10502/xmla/default.
    • When using token-based authentication, enter the MDX+token connection URL; for example: http://atscale-host:10502/xmla/default/76da811d-26b7-4f09-61eb-f378cb958ac7.
  3. Optionally, enter the AtScale project name for the Database field.

  4. Choose Connect Live as your Data Connectivity mode.

    Choosing "Import" is not recommended because doing so is the equivalent to exporting your entire dataset in cube form. AtScale will deliberately fail export queries that exceed a complexity threshold to prevent service disruption. If you wish to export data from AtScale, please contact AtScale Sales and Consulting Services for more information.

  5. Do not enter an MDX or DAX query as a connection parameter. This feature is not supported by AtScale.

  6. Click OK.

  7. Select your project and cube from the Display Options drop-down, and click OK.

  8. Power BI will connect to AtScale and return a representation of the published cube in the Fields Pane.

What to do next

  1. Build your report in Power BI. For details see Create reports and dashboards in Power BI.
  2. Review the list of AtScale's Power BI Known Issues and Limitations.
  3. Configure Power BI Service Integration and publish your report to Power BI Service.