How to Integrate ProProfs Chat With Power BI and Analyze Chat Data

ProProfs Chat integration with Power BI provides a powerful way to analyze chat data. This article will guide you through using the ProProfs Chat API to load chat data into Power BI in a tabular format. Once integrated, you can leverage Power BI’s analytical capabilities to gain insights from your chat data.
 

Here’s what the chat data will look like in the Power BI console:

To integrate ProProfs Chat with Power BI:

1. Go to Settings in the top navigation menu in your ProProfs Chat account and select Integrations from the left panel.

2. Activate the Power BI integration using the toggle button. An overlay will open.

3. In the Manage Power BI integration overlay, select the date range and the operator you want to analyze data for. Click Generate URL and copy the link below.

The next steps will be performed in the Power BI platform.

Power BI

1. In the Power BI console, click Get Data and select Web as the data source.

2. Paste the URL from the step above in the field and click OK. The console will fetch the data automatically.

3. Select Displayed Text (1) on the left pane in the Navigator and click Transform Data (2).

4. Click Parse and select JSON from the list.

5.1 Once the data is parsed, click the “To Table” icon to convert the data into a tabular format.

5.2 Now, in the popup, select the delimiter and the condition for handling extra columns. Click OK.

5.3 Click the icon to expand the columns. You can check/uncheck to include/remove the data points from your table. Once done, click OK.

Here’s what the table will look like:

And that's it! If you encounter any issues or have any questions, don't hesitate to reach out to our support team.