Skip to main content

Power BI

Credential forms by connection type

Accton supports several authentication methods for discovering and working with your Power BI metadata. Each method and the information it requires is described below. If you need help, contact our support team using the Help Request button in the Accton menu.

1. Principal access

Used for a Power BI / Azure connection authenticated with a service principal (app-only) token. Depending on how the Azure Principal service app is configured, it can handle requests to both the Graph API and the Power BI API. To establish the connection, provide the Principal service app credentials below.

ItemDescriptionUI
Authenticate methodSelect "Principal" to use a service account for authenticationdrop-down list
Tenant IdAzure AD tenant identifier for the Power BIinput field
Client IdApplication ID of the service principal used to access Power BI reportsinput field
Client secretSecret key of the service principal for authenticating API requestsinput field

2. Principal with Standard

Used for a Power BI / Azure connection when you need to parse the maximum possible amount of data, including .pbix files . It handles requests to both the Graph API and the Power BI API. To establish the connection, provide the user's login and password in addition to the Standard app's credentials.

ItemDescriptionUI
Authenticate methodSelect "Principal with standard"drop-down list
Tenant IdAzure AD tenant identifier for the Power BIinput field
Principal Client IdApplication ID of the service principalinput field
Principal Client secretSecret value of the service principalinput field
Standard Client IdApplication IDinput field
Standard Client secretSecret value of applicationinput field
BI usernameUsername of the user account for BI accessinput field
BI passwordPassword of the user accountinput field

3. With Certificate

Uses the same Principal service app as in Principal access, but proves the connection with a .pfx certificate and its password instead of a client secret. This method must be configured accordingly in Azure.

ItemDescriptionUI
Authenticate methodSelect "With certificate" to authenticate using a certificatedrop-down list
Tenant IdAzure AD tenant identifier for the Power BIinput field
Client IdApplication ID associated with the certificateinput field
PFX certificateUpload the PFX certificate for certificate-based authenticationfile input
Certificate passwordPassword protecting the PFX certificateinput field

4. With Federated auth method

Used for a Power BI / Azure connection authenticated via workload identity federation, using a single service account with no impersonation step.

ItemDescriptionUI
Authenticate methodSelect "Federated"drop-down list
Tenant IdAzure AD tenant identifier for the Power BIinput field
Client IdAzure Application IDinput field
Service accountAccount name associated with the authentication providerinput field

5. Federated with impersonated SA

Used for a Power BI / Azure connection authenticated via workload identity federation, where the federated identity impersonates. A second service account to obtain its final access - useful when the federated identity itself should not hold direct access and should instead delegate through a dedicated impersonated account.

ItemDescriptionUI
Authenticate methodSelect "Federated with impersonated SA"drop-down list
Tenant IdAzure AD tenant identifier for the Power BIinput field
Client IdAzure Application IDinput field
VM Service accountBase service account used to obtain the federated token; leave as default to use the environment's attached accountinput field
Impersonated Service accountTarget service account the connection ultimately runs as — the VM Service account must be granted permission to impersonate itinput field

Additional options

ItemDescriptionUI
Parse PersonalGroupsIncludes or excludes personal workspaces and their reports from discoveryswitcher
Limited accessLets you provide a list of workspace IDs to limit requests to BI dataswitcher
Attach all objects to workspace categoryAutomatically creates a category in Accton for each workspace and maps its reports and other entities to that categoryswitcher

Form actions

ActionDescription
SaveSaves the entered credentials for this connection
CancelDiscards changes and closes the form
ClearClears all entered values from the form