Power BI Report on Bot Analytics for Chatbot in Bot Framework Composer
Published: 2022-07-05 10:45:53

---
title: Power BI Report on Bot Analytics for Chatbot in Bot Framework Composer
published: true
date: 2021-12-15 10:34:55 UTC
tags: 
canonical_url: https://lkgforit.com/power-bi-report-on-bot-analytics-for-chatbot-in-bot-framework-composer
---

# Tutorial: View analytics with Power BI

## Intro

### Purpose

The BOT framework Composer sample provides a Power BI template that can be used to understand how your bot is performing.

 ![Overall usage](https://cdn.hashnode.com/res/hashnode/image/upload/v1639564238462/hIDiRfPUY.png)

#### Overall usage

Personalize your experience for your brand and customers.

 ![All dialogs overview](https://cdn.hashnode.com/res/hashnode/image/upload/v1639563482860/My-jJtDOD.png)

#### All dialogs overview

All dialogs' popularity and status based off of SDK telemetry

 ![Dialog overview](https://cdn.hashnode.com/res/hashnode/image/upload/v1639563487150/vXZq9lbAf.png)

#### Dialog overview

Review a specific dialog's popularity and status

 ![LUIS intents](https://cdn.hashnode.com/res/hashnode/image/upload/v1639563491124/ND5NEhvBq.png)

#### LUIS intents

A count of LUIS intents per day

 ![All conversation metrics](https://cdn.hashnode.com/res/hashnode/image/upload/v1639563495836/q90RHL706.png)

#### All conversation metrics

Highlights the average number of conversations per unique user and the average duration by day

 ![Conversations drill down](https://cdn.hashnode.com/res/hashnode/image/upload/v1639563503764/r7xUY7NWf.png)

#### Conversations drill down

Per conversation, this highlights the dialogs triggered and common utterances

 ![Transcript](https://cdn.hashnode.com/res/hashnode/image/upload/v1639563512529/OYb3aGabv.png)

#### Transcript

Review interactions, sessions, and the transcript between a bot and its users

 ![Demographics](https://cdn.hashnode.com/res/hashnode/image/upload/v1639563530955/-RlE66szF.png)

#### Demographics

See where users are connecting to your bot

 ![Word cloud](https://cdn.hashnode.com/res/hashnode/image/upload/v1639563534798/5bvkdAcYP.png)

#### Word Cloud

Commonly user queries

 ![Sentiment analysis](https://cdn.hashnode.com/res/hashnode/image/upload/v1639563540099/JGXsEyIZJ.png)

#### Sentiment analysis

Average user sentiment results provided by LUIS

 ![QnA Maker insights](https://cdn.hashnode.com/res/hashnode/image/upload/v1639563544702/DeR1ogn0a.png)

#### QnA Maker insights

Insights on matched user queries with QnA Maker

 ![User feedback](https://cdn.hashnode.com/res/hashnode/image/upload/v1639563517912/nm5WqQB4o.png)

#### User feedback

Insights on user submitted feedback

### Prerequisites

- [Install Power BI Desktop](https://powerbi.microsoft.com/desktop/)
- [Download the Bot Composer analytics Power BI template](https://github.com/SSanjeevi/BotFramework-Composer/blob/main/reports/Power-BI-Report-Composer.pbit)
- [Create a Bot in Composer](https://docs.microsoft.com/en-us/composer/quickstart-create-bot?tabs=v2x) to deploy your Azure resources

### Time To Complete

10 minutes

### Scenario

A Power BI dashboard showing Application Insights telemetry captured from a Bot Composer BOT.

# Tutorial: View analytics with Power BI

## Get your Application Insights Application ID

1. Log in to the [Azure Portal](https://portal.azure.com/).

2. Navigate to the Application Insights resource created.

3. In the sidebar, navigate to **Configure > API Access** on the sidebar. ![Screenshot highlighting the API Access tab in an Application Insights resource](https://cdn.hashnode.com/res/hashnode/image/upload/v1639563470212/_yXWutIYJ.png)

4. Copy the Application ID for the next step. ![Screenshot highlighting the Application ID of an Application Insights resource](https://cdn.hashnode.com/res/hashnode/image/upload/v1639564050921/qD-stuspf.png)

# Tutorial: View analytics with Power BI

## Open the Power BI template

1. Open the [Bot Composer analytics template](https://github.com/SSanjeevi/BotFramework-Composer/blob/main/reports/Power-BI-Report-Composer.pbit) and paste your **Application Insights Application ID**. ![Screenshot of the load template view of a new Composer Bot analytics Power BI template](https://cdn.hashnode.com/res/hashnode/image/upload/v1639563553120/BkIJbJCcU.png)

2. After loading the tables with your populated data, you should now see insights from your Virtual Assistant.

_Note: You may run into authentication issues when opening the template, particularly if you have opened the template previously using another Application ID. If so, perform the following steps to re-authenticate the template with your Application Insights service:_

1. Open the Template
2. File > Options and Settings > Data Source Settings
3. Click "Global permissions"
4. Click on anything resembling "api.logalytics.io" and Clear Permissions > Clear Permissions > Delete
5. Close and Re-open the Template
6. Paste your Application Insights AppId
7. Click Load
8. _Important_: Select Organizational Account > Sign In > Connect

## Additional Telemetry

By default, a Bot composer Bot based project collects personally identifiable information (e.g. Conversation drill-down and transcripts) which will lead to the respective sections in the PowerBI dashboard to function as expected. If you wish to not collect this information make the changes to `appsettings.json` by following this article: https://docs.microsoft.com/en-us/composer/how-to-capture-telemetry?tabs=v2x#configure-telemetry

Raised a PR to Bot Framework Composer: https://github.com/microsoft/BotFramework-Composer/pull/8641