How to Install and Use the Weni Data Connector for Power BI

Gustavo Dariano Updated by Gustavo Dariano

Introducing Weni Data Connector for Power BI

Weni Team is excited to announce a new feature to boost your chatbot analysis practices, the Data Connector for Power BI. This custom connector, made by our developers, allows users to pull data directly from Weni Platform to Power BI. This practical guide aims to introduce you to how to install and configure the feature as well as some best practices.

First things first: What are the Prerequisites?

  • Download the Power BI Desktop. This version is free to create. You need this free version of Microsoft software locally on your computer.  
  • Also, make sure you are a user collaborator in a chatbot project workspace inside Weni Platform to have an API Token.

How to install 

  1. Download the .mez files;
    WeniFluxos.mez
    RapidPro.mez
  2. Save the files in the path [Documents]/Power BI Desktop/Custom Connectors;
  3. Check Allow any extensions to be loaded without validation or warning in Power BI Desktop File > Options > Security > Data extensions;
  4. Restart Power BI Desktop.

How to extract data with Weni Data Connector

  1. Go to Get Data on PowerBI Desktop;
  2. Search for “RapidPro (beta)”;
  3. Enter the URL https://rapidpro.ilhasoft.mobi/api/v2/;
  4. Enter the Org API Token;
    Go to https://rapidpro.ilhasoft.mobi/org/home/ and copy the alphanumeric code. This code is unique for each user inside the Weni Platform/RapidPro.
  5. Press start.

It’s important to know!

The data connection happens by an API integration between RapidPro and Power BI. The data extracted is structured in a JSON format. So, in order to have access to all data fields, you need to expand the columns in the PowerQuery window.

Best Practices:

  1. Select only relevant data to optimize extraction process by previewing tables on navigator window;
  2. Transform to make your data useful
    Make sure that your data is well-formatted, clean, and organized before starting to create dashboards, reports, etc.;
  3. Keep a data catalog with all data fields, descriptions, and types from your chatbot project. Also, make sure that  your variables such as contact fields and results clearly describe its purpose;
  4. Understand data concepts like flows, runs, and contacts in order to properly interpret and create project insights;
  5. Explore the RapidPro API documentation to get familiar with what is the data available and how it is structured.

How did we do?

Explore Weni Database

Contact