The data that you collect using Mobenzi can be viewed on other analytics platforms like Power BI by making use of our API.

Set up your connection:

  1. Open Power BI
  2. Select File -> New
  3. From the "Home" tab, select "Get data"
  4. Choose "OData Feed"
  5. Enter our API URL: 
  6. Choose "Basic authentication"
  7. Enter the username and password for a user that has permissions to the data in the account/project you wish to access
  8. Select the entities you wish to import (e.g. Submissions, Responses, Questions, etc) - more information about the supported API entities is available in theAPI overviewin our Help Center
  9. Wait for the data to load

The specified data will now be available for in Power BI and the rest is up to you. We recommend creating relationships between the tables and columns as this will make it much easier to build charts and reports within Power BI (e.g. Responses link to Questions using the question_id column).

Clearing permissions:

Should you run into any trouble connecting, we'd recommend clearing permissions as a first troubleshooting step.

To clear permissions, follow the steps below:

  1. Open PowerBi and navigate to File > Options & Settings > Data source settings.
  2. Ensure 'Global permissions' is ticked in the new pop-up.
  3. Select the data source url
  4. Choose 'Clear permissions' and confirm.
  5. Close the Data source settings pop-up and follow the steps above to connect using our API.