How to get data from Cin7 into Power BI

Introduction

Cin7 is a connected inventory and order management platform used by growing businesses to synchronise products, stock, orders, and customer data across sales channels. Many organisations need Cin7 data in Power BI to monitor inventory health, order trends, and fulfilment performance.

Using the ZappySys ODBC Driver for REST APIs, you can query Cin7 REST API data with SQL and load it into Power BI without writing custom connector code.

This tutorial shows how to create a Cin7 ODBC DSN, configure API authentication, preview data, connect Power BI, and run practical SQL queries.

Steps

Get Cin7 API Credentials

1. Sign in to your Cin7 account.
2. Open Settings → Integrations & API → API v1 in your Cin7 admin portal.
   • Note your API Username shown on the page.
   • Click Add New API Connection, give it a name (e.g. ZappySys), and copy the generated API Key.
   

   Cin7 – Generate new API connection

3. Store both values securely — the API Username and API Key together act as your login credentials.
   

   Cin7 – API credentials

4. Note your API base URL: https://api.cin7.com/api.

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 User DSN or System DSN, click Add.
3. Select ZappySys JSON Driver, then click Continue.
   

Configure Cin7 API Connection

1. Enter a Cin7 endpoint URL in this format:
   https://api.cin7.com/api/v1/Products
2. In Connection Type, select HTTP and click Configure.
3. Set Credential Type to Basic Auth (Username/Password).
4. Set Username to your Cin7 API Username.
5. Set Password to your Cin7 API Key.
6. Click OK to save HTTP authentication settings.
   

   Cin7 – ODBC HTTP connection configuration

7. Set HTTP Request Method to GET.
8. Set JSON Path Filter to $.Products[*] for the Products endpoint.
9. Click Test Connection, then click OK to save the DSN.
   

   Cin7 – JSON Driver configuration

Preview Cin7 Data in ODBC Driver

1. Open the Preview tab in the DSN configuration window.
2. Generate a query and click Preview Data.
3. Confirm rows are returned. If not, recheck endpoint URL, credentials, and JSON Path Filter.
   

   Cin7 – JSON Driver result

Connect Power BI to Cin7 via ODBC

1. Open Power BI Desktop.
2. Go to Home > Get Data > More….
3. Search for ODBC and click Connect.
   

   Power BI – Get data from ODBC connection

4. Select your Cin7 DSN from the data source list.
5. Optionally enter a custom SQL query in Advanced options.
   

   Cin7 – Power BI select driver

6. Click OK, review the preview, and click Load.
   

   Cin7 – Power BI result

7. In the Navigator, select fields or tables you want to import into your model.

Query Cin7 Data with SQL

Use custom SQL queries in the ODBC driver or Power BI to shape data before loading.

Example 1: List Products

Example 2: Active Products Only

Example 3: Recently Modified Products (Last 30 Days)

Conclusion

Connecting Cin7 to Power BI using the ZappySys ODBC Driver gives you a fast, SQL-friendly way to build inventory and sales analytics from Cin7 API data. You can centralise operational data, model it in Power BI, and publish dashboards without building custom connectors.

Explore the full capabilities of the ZappySys ODBC Drivers to integrate Cin7 and other APIs into your reporting workflow.