Power BI Connector for Slack

Build 22.0.8462

Custom Credentials

Authenticate to Slack from a Desktop Application

Set the following connection properties to connect:

  • InitiateOAuth: Set this to GETANDREFRESH. You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the access token in the connection string.
  • OAuthClientId: Set this to the Client Id in your app settings.
  • OAuthClientSecret: Set this to the Client Secret in your app settings.
  • CallbackURL: Set this to the Redirect URL in your app settings.
When you connect the connector opens the OAuth endpoint in your default browser. Log in and grant permissions to the application. The connector then completes the OAuth process:
  1. Extracts the access token from the callback URL and authenticates requests.
  2. Refreshes the access token when it expires.
  3. Saves OAuth values in OAuthSettingsLocation to be persisted across connections.

Authenticate to Slack from a Web Application

To obtain an OAuthAccessToken, set the following connection properties and follow the steps below.

  • OAuthClientId: Set this to the Client Id in your app settings.
  • OAuthClientSecret: Set this to the Client Secret in your app settings.
When connecting via a Web application, or if the connector is not authorized to open a browser window, you need to exchange temporary verification values for the access token:
  1. Call GetOAuthAuthorizationURL. The stored procedure returns the URL to the OAuth endpoint.
  2. Log in at the OAuth endpoint and grant the application permissions. You are redirected back to the callback URL.

    The callback URL contains a verifier code in the "code" query string parameter. Extract the verifier code.

  3. Call GetOAuthAccessToken.
To connect to data, set the OAuthAccessToken connection property to the access token returned by the stored procedure.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462