Access Token for Microsoft Power BI

Configure an access token to connect to Microsoft Power BI.

Figure: MS Power BI Access Token Configuration screen

Power BI Access Token Configuration screen

Background and Setup

Examples

Prerequisites

  • One of these account types:
    • Microsoft Power BI Pro
    • Microsoft Power BI Premium

Good to Know

  • In most cases, you can use a global access token or an application level access token:
    • Global access tokens are shared across all users and apps. If you want all process designers and runtime app users in your AgilePoint NX tenant to be able to connect to an external data source, use a global access token. An example is a SharePoint site on an intranet that all employees in a company can access.
    • Application level access tokens are shared with all processes in a process-based app, or restricted to use within a form-based app. Use application level access tokens if only process designers or runtime app users for a particular application should access an external system — for example, a Google Drive account that is only used to share files within a small team.
  • Access tokens are collections of credentials that are used to authenticate communication directly between AgilePoint NX and an external system. Because it is the AgilePoint NX system that uses these credentials, rather than an app, there is no difference between design time and runtime access tokens. Access tokens are never checked in or published, and they do not use version control. If you change an access token in the App Builder or Manage Center, the access token changes immediately everywhere the access token is used. Changes to application level access tokens apply to all versions of an app, including running application instances. Changes to global access tokens apply everywhere they are used in AgilePoint NX. You can not roll back an access token to a previous version.

    For more information, refer to What Data Is Deleted When I Delete an App or Application Resource?

  • OAuth 2.0 access tokens require a 2-way exchange of credentials between AgilePoint NX and the external service. This means that you must get the credentials from the third-party service to paste in the AgilePoint NX access token, and get the redirect URI from AgilePoint NX to paste in the external service. This requires you to open both the AgilePoint NX access token and the third-party service at the same time, so you can copy and paste from one screen to the other.

    This topic shows the suggested procedure for Microsoft Power BI. The exact procedure for your access token depends on whether you already have a connection (usually called an app) configured in the external service.

    (Example) How to Get the Access Token Credentials from Microsoft Power BI.

  • Some information about third-party integrations is outside the scope of the AgilePoint NX Product Documentation. It is the responsibility of the vendors who create and maintain these technologies to provide this information. This includes specific business use cases and examples; explanations for third-party concepts; details about the data models and input and output data formats for third-party technologies; and various types of IDs, URL patterns, connection string formats, or other technical information that is specific to the third-party technologies. For more information, refer to Where Can I Find Information and Examples for Third-Party Integrations?

Fields

Field Name Definition

Token Name

Function:
Specifies the unique name for your connection to Microsoft Power BI.
Accepted Values:
A text string that can have letters, numbers, and spaces
Default Value:
None
Example:
This is a common configuration field that is used in many examples. Refer to:
  • Examples - Step-by-step use case examples, information about what types of examples are provided in the AgilePoint NX Product Documentation, and other resources where you can find more examples.

Application ID

Function:
Specifies the application ID of the app you created or added in Microsoft Power BI.
Accepted Values:
A string with letters and numbers.
Default Value:
None
Example:
Refer to:

Key

Function:
Specifies the key of the app you created or added in Microsoft Power BI.
Accepted Values:
A string with letters and numbers.
Default Value:
None
Example:
Refer to:

Redirect URL

Function:
Specifies the callback URL from the connected application.
Accepted Values:
A string in URL format.
Default Value:
https://mysite.com/manage/shared/success.html
Example:
Refer to:

Description

Function:
A description for your access token.
Accepted Values:
More than one line of text.
Default Value:
None
Example:
This is a common configuration field that is used in many examples. Refer to:
  • Examples - Step-by-step use case examples, information about what types of examples are provided in the AgilePoint NX Product Documentation, and other resources where you can find more examples.

Get OAuth2 Access Token

Function:
Sends a request to the Microsoft Power BI application service to get the access token.

To complete this process, you must sign in to Power BI, and specify your consent when prompted.

OAuth2 Access Token

Function:
Specifies an OAuth 2.0 access token from Microsoft Power BI.com.
Accepted Values:
An OAuth 2.0 access token

This value comes from PowerBI.com.

Default Value:
None.
Example:
Refer to:

Renewal Rate

Function:
Specifies how frequently to renew your application's access token.
Accepted Values:
  • Disabled
  • Every 15 minutes
  • Every half an hour
  • Every hour
Default Value:
Every hour

Encrypt

Function:
Stores the access token in the AgilePoint database as encrypted data.
Note: AgilePoint recommends you to store this access token in the database in encrypted format.
Accepted Values:
  • Deselected - The access token is in plain text in the database.
  • Selected - The access token is encrypted in the database.
Default Value:
Selected
Limitations:
  • This field was removed from the UI in AgilePoint NX OnPremises and Private Cloud v7.0 Software Update 2. Access token credentials are encrypted by default. If you want to store credentials in unencrypted format, contact AgilePoint Customer Support.