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 |