Custom Visual: Visualize Chat Transcripts in Power BI

This custom visual for Power BI visualises bot transcripts (activities) to show the interactions between a user and your bot in a chat interface. Combine your statistics with user conversations in your Power BI (Embedded) report to learn how to improve your chatbot.

In order to use this custom visual, you will need to have your activities (array) in JSON format and compliant to the Bot Framework Activity schema. This is the default format for Microsoft Copilot Studio / Power Virtual Agents transcripts, saved in Dataverse.

Features

• Visualize your chat transcripts (Microsoft Copilot Studio / Power Virtual Agents / Bot Framework)
• Web Chat language based on Power BI language
• Style your Web Chat via Power BI visual settings

How to use

Microsoft Copilot Studio

This transcript viewer is now available as part of Copilot Studio Custom Analytics, see the official blog post for more information. This solution allows customers to create a Power BI dashboard for their copilots built in Microsoft Copilot Studio, and includes pre-created screens to show all-up performance, customer satisfaction, topics and transcripts.

Report: CustomAnalytics for Copilot Studio

Custom Power BI report / other scenarios

Power BI visuals are packaged as a single .pbiviz file, that can then be imported into a Power BI report. Head to releases and download the .pbiviz file of the last available version.

To import a Power BI visual from a file, see Import a visual file from your local computer into Power BI.

If don't trust pregenerated .pbiviz files, feel free to checkout and review the code in this repository and package your own visual. This way you can be 100% sure that your data is not leaving your environment. In the future, the plan is to get have this visual certified by Power BI and added to AppSource.

How to handle updates?

Since this visual is not published on Power BI Marketplace, you will need to download updates yourself. Updating the visual is recommended due to possible vulnerabilities in older versions of the visual dependencies. Download the latest version and import the visual as usual. This will update the visual to the latest version.

If you want to be notified on new releases, you can subscribe to releases via GitHub.

How to contribute to the development

This project is based on PowerBI Visual Tools (pbiviz) and includes a devcontainer and VSCode configuration to get started with development easily.

Contribute to the localisation

If you speak one of the supported languages, you can help translate the visual. You can fork the project and translate the strings into your language, or create an issue where you enter the translated strings. The English (US) version is the base version and can be used as reference. Have a look at the existing translations.

Start development server

npm run start

Package for production

npm run package

License

MIT