How to get data from Hivebrite into Power BI

Contents hide

1 Introduction

2 Prerequisites

3 Steps

3.1 Prepare Hivebrite API access

3.2 Create a new ODBC DSN using the ZappySys JSON Driver

3.3 Configure the Connection and API Settings

3.4 Preview Hivebrite data in the ODBC driver

3.5 Connect Power BI to Hivebrite via ODBC

3.6 Query Hivebrite data with SQL

4 Conclusion

4.1 Need Help?

Introduction

Hivebrite is a community management platform used for memberships, events, directories, and engagement workflows. Many organizations store operational data in Hivebrite and need to migrate it to Power BI for reporting, analytics, and business intelligence.

In this tutorial, you will learn how to read Hivebrite API data directly from Power BI by using the ZappySys JSON Driver (part of ODBC PowerPack). You will configure OAuth2 authentication, handle pagination, preview the data inside the driver, and then load it into a Power BI model — without writing a custom API client.

Prerequisites

Before we perform the steps listed in this article, make sure the prerequisites are met:

Basic knowledge of SSIS package development using Microsoft SQL Server Integration Services.
Make sure the SSIS designer is installed.
Download and install ZappySys SSIS PowerPack.

NOTE: If you are planning to deploy packages to a server and schedule their execution later, read this article.

Steps

Prepare Hivebrite API access

Sign in to your Hivebrite admin area and go to Integrations → External Integrations.
Click Create a Service App and give it a name.
- Copy the Client ID (UUID) and Client Secret shown at creation — the secret is displayed only once and cannot be retrieved afterward.
Identify your Authorization Host based on the zone that hosts your community:
- US: auth.us.hivebrite.com
- EU: auth.eu.hivebrite.com
- APAC: auth.apac.hivebrite.com
- CH: auth.ch.hivebrite.com
Note your community API host — it is your own subdomain, for example https://{your-community}.hivebrite.com.
Confirm which entities you need to extract (for example: members, events, groups, or donations).

Create a new ODBC DSN using the ZappySys JSON Driver

Search for ODBC in the Windows Start menu and open ODBC Data Source Administrator.
In User DSN or System DSN, click Add.
Select ZappySys JSON Driver and click Continue.

Configure the Connection and API Settings

Set the Data Source Path or URL to the endpoint you want to read. Example for members:

https://{your-community}.hivebrite.com/admin/v4/members

1

https://{your-community}.hivebrite.com/admin/v4/members
In the driver window, set Connection Type to HTTP and click Configure.
Set Credential Type to OAuth.
Fill in the OAuth settings:
- OAuth Provider: Custom
- OAuth Version: OAuth2
- Grant Type: Client Credentials Grant
- Client ID: your Hivebrite Client ID (UUID)
- Client Secret: your Hivebrite Client Secret
- Access Token URL: https://auth.{zone}.hivebrite.com/oauth2/token
- Scopes / Permissions: leave empty
  Hivebrite – ODBC OAuth connection configuration
Go to the Grant Options tab and add the following under Extra attributes for the token request:

audience=partner

1

audience=partner
Click OK to save the configuration.
Hivebrite – ODBC OAuth connection configuration advanced.
Set HTTP Request Method to GET.
Add the request header:
- Accept: application/json
Set the Array Filter (JSON Path) to $.data[*] — Hivebrite wraps collection responses in an data array. If you leave the filter empty, the driver will return a single row containing the envelope instead of one row per record.
Click Test Connection, then OK to save the DSN.
Hivebrite – ODBC JSON Driver configuration

Preview Hivebrite data in the ODBC driver

Go to the Preview tab.
Adjust the generated query if needed, then click Preview Data.
Confirm that you get one row per Hivebrite record and that the columns are flattened as expected. Validate here before moving to Power BI — troubleshooting is much faster inside the driver.
Hivebrite – ODBC JSON Driver result

Connect Power BI to Hivebrite via ODBC

Open Power BI Desktop.
Go to Home > Get Data > More….
Search for ODBC and click Connect.
Power BI – Get data from ODBC connection
Select your Spotify DSN from the data source list.
Optionally enter a custom SQL query in Advanced options.
Hivebrite – Power BI query
Click OK, review the preview, and click Load

Hivebrite – Power BI result

Query Hivebrite data with SQL

Example 1: Select specific columns

SELECT
    id,
    first_name,
    last_name,
    email,
    status,
    created_at,
    updated_at
FROM _root_

SELECT

id,

first_name,

last_name,

email,

status,

created_at,

updated_at

FROM _root_

Example 2: Filter and sort

SELECT
    id,
    first_name,
    last_name,
    email,
    status,
    created_at
FROM _root_
WHERE status = 'active'
ORDER BY created_at DESC

SELECT

id,

first_name,

last_name,

email,

status,

created_at

FROM _root_

WHERE status = 'active'

ORDER BY created_at DESC

Example 3: Count members by status

SELECT
    status,
    COUNT(*) AS MemberCount
FROM _root_
GROUP BY status

SELECT

status,

COUNT(*) AS MemberCount

FROM _root_

GROUP BY status

Conclusion

Connecting Hivebrite to Power BI with the ZappySys JSON Driver gives you a repeatable, no-code path from your community platform to your analytics stack. With OAuth2 client credentials handled by the driver, pagination configured once, and server-side filters pushed into the API, you can build reports on members, events, and engagement that refresh on a schedule.

Explore the full capabilities of the ZappySys ODBC PowerPack to combine Hivebrite data with your CRM, finance, or marketing sources and build a unified view of your community operations.

Need Help?

If you encounter any issues, our support team is here to help:

Live Chat: Open the chat widget (bottom right of this page)
Email: support@zappysys.com
Support Center: Support | ZappySys