BI credentials
Based on selected connector type Admin need to provide valid credentials to BI service.
Please note, that all credentials are encrypted
Power BI
Analytics Hub provides two connection types for Power BI data importing:
- Principal access (by default)
- Standard access through Azure application (allows parse filters, indicators and dimensions from .pbix)
To establish a connection with Power BI with principal access, Admin should fill in the following credentials:
| Credential | Description | UI |
|---|---|---|
| Client ID ( = Application ID) | go to the User profile page - navigate to the Application tab - open the Assignment Detail page for the "PowerBI connection" app | input field |
| Client Secret | go to Azure Active Directory - navigate to App registrations - select the PowerBI connection page - go to the Certificates & secrets tab - create a new secret | input field |
| Tenant ID | go to the Azure Active Directory page | input field |
| Use Standard API | allow to use standart access through Azure application | switcher |
If Admin uses standard access, the following information must be provided:
| Credential | Description | UI |
|---|---|---|
| Client ID ( = Application ID) | go to the User profile page - navigate to the Application tab - open the Assignment Detail page for the "PowerBI connection" app | input field |
| Client Secret | go to Azure Active Directory - navigate to App registrations - select the PowerBI connection page - go to the Certificates & secrets tab - create a new secret | input field |
| Username | the user email with Power BI access | input field |
| Password | the user password with Power BI | input field |
Tableau Cloud
To establish a connection with Tableau Cloud, Admin should fill in the following credentials:
| Credential | Description | UI |
|---|---|---|
| Host | Tableau hostname | input field |
| Personal token name | token name created by user (with administrator access) in the My Account settings in Tableau personal profile | input field |
| Personal access token | token created by user (with administrator access) in the My Account settings in Tableau personal profile | input field |
| Site | Admin can provide site name, if there are the several sites on one host | input field |
Tableau Server
To establish a connection with Tableau Server, Admin should fill in the following credentials:
| Credential | Description | UI |
|---|---|---|
| Host | Tableau hostname | input field |
| BI username | username of the user with administrator access | input field |
| BI password | password of the user with administrator access | input field |
| Site | Admin can provide site name, if there are the several sites on one server | input field |
Please note, that a server admin must enable the Metadata API on Tableau Server for the full import.
Jira Cloud
To establish a connection with Jira Cloud, Admin should fill in the following credentials:
| Credential | Description | UI |
|---|---|---|
| BI username | username of the user with administrator access | input field |
| Personal access token | password of the user with administrator access | input field |
Qlik Cloud
To establish a connection with Qlik Cloud, Admin should fill in the following credentials:
| Credential | Description | UI |
|---|---|---|
| Host | Qlik hostname | input field |
| Personal access token | password of the user with administrator access | input field |
Report Server
The connector supports 3 types of authorisation.
- NTLM - standard connection method, you need to fill in for authorization:
Domain PBIRS Username Password
| Credential | UI |
|---|---|
| Domain PBIRS | input field |
| Username | input field |
| Password | input field |
- Axure Application Proxy - allows you to log in using a cookie, you need to fill in for authorization:
| Credential | UI |
|---|---|
| Cookie name | input field |
| Cookie value | input field |
- OAuth - the method used if access to PBIRS is provided via Azure OAuth. Requires setting up a separate Azure application, you need to fill in for authorization:
| Credential | UI |
|---|---|
| Cookie name | input field |
| Cookie value | input field |
| Username of the user who has access to PBIRS | input field |
| Password of the user who has access to PBIRS | input field |