Using AtScale with Microsoft Power BI Desktop
This section describes how to connect to AtScale from Microsoft Power BI Desktop.
Prerequisites
Before connecting to Power BI Desktop, do the following:
- Ensure you are using a supported version of Microsoft Power BI Desktop. For details, see AtScale Supported Tools and Platforms.
- Deploy the catalog that contains the model you want to connect to. For details, see Deploying Catalogs.
Setting up authentication
You need to ensure authentication is configured in one of the following ways.
Token-based authentication
The xmla.auth.token.enabled
global setting must be enabled. For more
information, see Configuring Global Settings.
Windows authentication
AtScale must be configured to use either Kerberos or NTLM. You can set this up via the Identity Broker. For more information, see Configuring Kerberos and Connecting to Active Directory via NTLM Pass-Through (Netlogon).
Optionally, you can enable Xpress compression to improve the
communication. To do this, you can the turn on soap.xpress.enabled
global setting. For more information, see Configuring Global Settings.
Connecting Power BI Desktop to an AtScale Model
-
In Design Center, obtain the connection string for the catalog you want to connect to.
If you are using token-based authentication:
- Click the profile icon in the top right corner of Design Center. The Account panel opens.
- Click Generate XMLA token.
- Open the Deployed Catalogs panel, then open the catalog you want to connect to.
- On the Connect tab, copy the MDX + Token connection string.
If you are using Windows Authentication:
- Open the Deployed Catalogs panel, then open the catalog you want to connect to.
- On the Connect tab, copy the MDX connection string.
-
In Microsoft Power BI Desktop, select Get Data > Analysis Services.
-
In the dialog's Server field, enter the connection string you copied above.
-
(Optional) In the Database field, enter the name of the AtScale catalog you're connecting to.
-
Select the Connect Live option.
AtScale does not recommend using the Import option, as this is equivalent to exporting your entire dataset in model form. AtScale will deliberately fail export queries that exceed a complexity threshold to prevent service disruption. If you want to export data from AtScale, contact AtScale Support for more information.
-
Do not enter an MDX or DAX query as a connection parameter. AtScale does not support this feature.
-
Click OK.
-
Select your catalog and model from the Display Options dropdown, then click OK.
Power BI will connect to AtScale and return a representation of the model in the Fields Pane.
What to do next
- Build your report in Power BI. For details, see Create reports and dashboards in Power BI.
- Review the list of AtScale's Power BI Known Issues.
- Configure Power BI Service Integration and publish your report to Power BI Service.