| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 1316 |
| Technical Name |
odoo_bi_connector |
| License | LGPL-3 |
| Website | https://leapai.ai |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 1316 |
| Technical Name |
odoo_bi_connector |
| License | LGPL-3 |
| Website | https://leapai.ai |
BI Connector Pro
Connect Odoo to Power BI, Tableau, Google Looker and any BI tool via secure OData/REST APIs with JWT authentication
See It In Action
Real screenshots from a live Odoo 19 instance — click to enlarge
BI Connector on Odoo Home Screen
API Endpoints List
JWT Access Token Manager
API Request Access Logs
Configuration Dashboard
Configuration Overview
Key Features
Everything you need to connect Odoo to your BI ecosystem
JWT Authentication
Industry-standard JWT tokens with configurable expiry, scope control and automatic revocation. No passwords in API calls.
OData v4 Support
Native OData v4 endpoint compatible with Power BI, Excel Get Data, and any OData-aware tool. Plug in directly.
REST JSON API
Clean RESTful JSON endpoints with pagination, filtering, ordering and field selection. Works with any BI platform.
Configurable Endpoints
Define custom endpoints per Odoo model with domain filters, field selection and record limits. No code needed.
Full Audit Logging
Every API request is logged with IP address, response time, record count and error details for compliance.
Rate Limiting & CORS
Built-in rate limiting per token and configurable CORS origins to secure your API against abuse.
How It Works
Four steps from installation to live dashboard
Install & Configure
Install the module and create your BI Configuration with a JWT secret key and expiry settings.
Define Endpoints
Create endpoints for each Odoo model you want to expose — Sales Orders, Invoices, Products, etc.
Generate Tokens
Create JWT access tokens for each BI tool or team member with the appropriate scope and expiry.
Connect & Analyze
Paste the OData URL and token into Power BI, Tableau or any BI tool and start building dashboards.
API Reference
All endpoints require a Bearer JWT token in the Authorization header
| Method | Endpoint | Description | Auth |
|---|---|---|---|
| POST | /api/bi/v1/token |
Issue a JWT access token using Odoo credentials | Basic / Body |
| POST | /api/bi/v1/token/revoke |
Revoke the current JWT token | Bearer JWT |
| GET | /api/bi/v1/odata |
OData service document listing all active endpoints | Bearer JWT |
| GET | /api/bi/v1/odata/{endpoint} |
OData entity set — supports $top, $skip parameters | Bearer JWT |
| GET | /api/bi/v1/data/{endpoint} |
REST JSON data with limit, offset, order, domain params | Bearer JWT |
| GET | /api/bi/v1/schema/{endpoint} |
Field schema information for an endpoint | Bearer JWT |
| GET | /api/bi/v1/health |
Health check — no auth required | None |
Compatibility
Tested across Odoo versions and leading BI platforms
Odoo Versions
Compatible BI Tools
Support & Services
We are here to help you succeed
🆕 Free Demo
Try BI Connector Pro on your own Odoo instance. We will set up a demo environment for you to test before purchase.
Request Demo🍷 Lifetime Support
Purchase includes 1 year of priority email support, bug fixes and minor updates. Optional extended support available.
Contact Support⚙ Customization
Need custom endpoints, advanced filtering, SSO integration or a bespoke Power BI template? We build it for you.
Get a Quote
Please log in to comment on this module