Skip to main content
Last updated on

Configure Microsoft Teams notifications

Preview

This feature is in Public Preview.

AI/BI dashboards support sending scheduled snapshots to Microsoft Teams channels. This allows teams to receive dashboard updates directly in their Teams workspace. This page explains how to create a Microsoft Teams app and configure a Teams channel as a notification destination. Dashboard editors can then add this notification destination as a subscriber to scheduled dashboards. For information about adding a Teams channel as a subscriber, see Subscribe a Slack or Microsoft Teams channel.

Teams subscriptions deliver dashboard snapshots that include:

  • A PNG image snapshot of the dashboard visible directly in the channel
  • A direct link to open the dashboard in Databricks
  • A PDF snapshot attachment in the message thread

Requirements​

You must have the following permissions:

  • You must be a Databricks workspace admin to configure notification destinations.
  • You must have the appropriate permissions to create and configure apps in Microsoft Copilot Studio and Microsoft Entra ID.

During the setup process, you collect authentication credentials from Microsoft to configure the Databricks notification destination.

After you configure the notification destination, any user with CAN EDIT permissions on a dashboard can add the Teams destination as a subscriber to schedules they manage.

Step 1: Create and configure a Microsoft Teams app​

Create a Microsoft Copilot Studio bot for your Teams workspace and configure the necessary permissions.

Create the Microsoft Copilot Studio bot​

Complete the following steps from the Microsoft Copilot Studio documentation:

  1. Install the Copilot Studio app in Microsoft Teams.
  2. Create a new chatbot in a team.

Configure app permissions in Microsoft Entra ID​

  1. Go to the Microsoft Entra admin center.
  2. Click Applications > App registrations.
  3. Find and select the app registration associated with your Copilot Studio bot using the Application ID from the previous step.
  4. In the left sidebar, click API permissions.
  5. Click Add a permission.
  6. In Microsoft APIs, click Microsoft Graph > Application permissions.
  7. Add the following permissions:
    • Files.Read.All
    • Sites.ReadWrite.All
  8. Click Add permissions.
  9. Click Grant admin consent to grant the permissions for your organization.

Create an authentication secret​

  1. In the Microsoft Entra admin center, with your app registration selected, click to Certificates & secrets.
  2. Click Client secrets > New client secret.
  3. Enter a description and select an expiration period.
  4. Click Add.
  5. Copy the Value of the newly created secret. This value is displayed only once and you need it to configure the Databricks notification destination.

Get the tenant ID​

  1. In the Microsoft Entra admin center, with your app registration selected, navigate to Overview.
  2. Copy the Directory (tenant) ID. You need this value to configure the Databricks notification destination.

Publish the bot and add to Teams channel​

Complete the following steps from the Microsoft Copilot Studio documentation:

  1. Publish your Chatbot.
  2. Make your chatbot available to other employees.

Create an incoming webhook for the channel​

  1. In Microsoft Copilot Studio documentation, follow the steps to Create an Incoming Webhook.
  2. Copy and save the generated webhook URL.
  3. Click Done.

Copy generated webhook URL.

Get the Teams channel URL​

  1. In Microsoft Teams, navigate to the destination channel.
  2. Click the hamburger menu ••• next to the channel name.
  3. Click Copy link. Ensure to copy the channel URL and not the Teams URL. You need this URL to configure the Databricks notification destination.

Step 2: Configure the notification destination in Databricks​

Create a notification destination in your Databricks workspace that points to your Microsoft Teams channel.

  1. Log in to your Databricks workspace.

  2. Click your username in the upper right corner of the workspace.

  3. Select Settings from the dropdown.

  4. In the Workspace admin section, click the Notifications tab.

  5. Click Manage in the Notification destinations section.

  6. Click Add destination.

  7. Select Microsoft Teams from the destination type dropdown.

  8. Enter the following information:

    • Name: A descriptive name for this Teams channel destination
    • Microsoft teams Webhook URL: The webhook URL from the Teams incoming webhook
    • App ID: The Application ID from your Microsoft Copilot Studio bot
    • Auth Secret: The client secret value from Microsoft Entra ID
    • Channel URL: The channel URL from Microsoft Teams
    • Tenant ID: The Directory (tenant) ID from Microsoft Entra ID

  9. Click Create.

Create new teams destination.

Users can now add this Teams notification destination as a subscriber to dashboard schedules.

For instructions on subscribing Teams channels to dashboard schedules, see Subscribe a Slack or Microsoft Teams channel.

Troubleshooting​

Use the following to troubleshoot common errors with Microsoft Teams notifications.

Missing PDF attachment​

If the Teams notification appears without a PDF attachment, verify that:

  • The Application ID is correctly configured in the notification destination
  • The auth secret is valid and has not expired
  • The app has been granted the required Files.Read.All and Sites.ReadWrite.All permissions in Microsoft Entra ID
  • Admin consent has been granted for the API permissions

Notification not appearing​

If notifications do not appear in your Teams channel:

  • Verify the webhook URL is correct and matches the destination channel
  • Check that the bot has been published and added to the destination channel
  • Ensure the channel URL is correct
  • Verify the tenant ID matches your Microsoft organization
  • Confirm the schedule is active and not paused

Next steps​