How to get data from Birdeye into Power BI

Introduction

Birdeye is a customer experience and reputation management platform that helps businesses manage reviews, listings, messages, and customer interactions across channels. Many organisations need Birdeye data in Power BI to track review trends, location performance, customer sentiment, and service responsiveness.

Using the ZappySys ODBC Driver for REST APIs, you can connect to Birdeye APIs, query data with SQL, and load it directly into Power BI dashboards without writing custom connector code.

This tutorial shows how to create an ODBC DSN for the Birdeye API, preview data, connect Power BI, and build analytics using custom SQL queries.

Prerequisites

1. A Birdeye account with API access enabled.
2. Power BI Desktop installed on your machine.
3. Basic understanding of SQL and Power BI data modelling.
4. Finally, install the ZappySys ODBC Driver.

Steps

Get Birdeye API Key

1. Sign in to your Birdeye account.
2. Open API settings in your Birdeye admin portal.
3. Generate or copy your API key.
   

   Birdeye – Generate token

4. Store the API key securely and do not expose it in logs or shared files.

Create a new ODBC DSN using ZappySys JSON Driver.

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

Configure the Connection and API Settings

1. Enter the base URL:
   https://api.birdeye.com/v1/review/businessid/{business_id}
2. In Connection Type, select HTTP and click Configure.
3. Select Static token/API key for Credential type.
4. Use x-api-key in the Auth header name.
5. In Auth Scheme, select {none}
6. Click OK to save the configuration.
   

   Birdeye – ODBC HTTP connection

7. Set HTTP Request Method to GET.
8. Set the following values in the HTTP headers:
   1. Accept: application/json
   2. Content-Type: application/json
9. Set JSON Path Filter to match the review array in the response, for example:
   
   $.hoursOfOperations[*] or $.serviceAreas[*]

   1	$.hoursOfOperations[*] or $.serviceAreas[*]

10. Click Test Connection to verify connectivity, then click OK to save the DSN.
    

    Birdeye – the JSON Driver configuration

Preview Birdeye data in ODBC Driver

1. Go to the Preview tab.
2. Generate a query, then click Preview Data to confirm rows are returned.
3. If no data is returned, verify your API key, business ID, and JSON Path Filter.
   

   Birdeye – the JSON source preview

Connect Power BI to Birdeye via ODBC

1. Open Power BI Desktop.
2. Click Get Data from the Home ribbon.
3. Click More…, search for ODBC, and click Connect.
   

   Power BI – Get data from ODBC connection

4. Select your Birdeye ODBC DSN from the dropdown list.
5. Optionally, enter a custom SQL query in Advanced options.
   

   Birdeye – Power BI select driver

6. Click OK, then click Load to import data.
   

   Birdeye – Power BI preview

7. In the Navigator window, select the columns you want to load.

Use Other Birdeye Endpoints

You can switch endpoints in DSN settings or custom queries to extract other modules:

• Businesses: https://api.birdeye.com/v1/businesses
• Locations: https://api.birdeye.com/v1/locations
• Messages: https://api.birdeye.com/v1/messages
• Listings: https://api.birdeye.com/v1/listings

Conclusion

Connecting Birdeye to Power BI using the ZappySys ODBC Driver makes it easy to build review and customer-experience analytics without custom connectors. With SQL-based access to Birdeye API responses, you can monitor rating trends, sentiment signals, and location performance in one place.

Explore the full capabilities of the ZappySys ODBC Drivers to integrate Birdeye and other APIs into your Power BI ecosystem.

Need Help?

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

1. Live Chat – Use the chat widget (bottom-right corner of this page)
2. Email – support@zappysys.com
3. Support center – Visit the ZappySys Support Portal