BI Tool Connection Support
The methods you can use to connect to different BI tools depends on the tool and your organization's method for managing users. The following table lists the supported connection methods for each combination of tools and user management solutions.
| BI Tool | On-Prem AD | Microsoft Entra ID | Okta |
|---|---|---|---|
| Microsoft Excel | Windows Authentication with Kerberos Basic auth (username and password) | XMLA token | XMLA token |
| Microsoft Power BI Desktop | Windows Authentication with Kerberos | XMLA token | XMLA token |
| Microsoft Power BI Service | Windows Authentication with Kerberos | No token required | No token required |
| Tableau | SSO with OAuth via PostgreSQL Connector Basic auth (username and password) | SSO with OAuth via PostgreSQL Connector | SSO with OAuth via PostgreSQL Connector |
| Looker | PostgreSQL connection | PostgreSQL connection | PostgreSQL connection |
Note
AtScale answers SELECT * queries from BI tools connected via the PostgreSQL connector with preconfigured constant values. This enables BI tools that rely on metadata from SELECT * queries to connect to AtScale.
If you find you need to modify the constant values returned by AtScale, contact AtScale Support.