Power BI Connector for Odoo

Name: Power BI Connector for Odoo
Brand: ECOSIRE
SKU: odoo-power-bi-connector

Key Features

Live (DirectQuery-style) data pulls from Odoo into Power BI for near-real-time operational dashboards

Scheduled refresh via the Power BI Service, with on-premises data gateway support when Odoo is not publicly exposed

Pre-mapped Sales dataset: sale orders, order lines, margins, salesperson and product performance with joins pre-built

Pre-mapped Inventory dataset: on-hand quantities, stock valuation, and stock moves per warehouse and location

Pre-mapped Accounting dataset: invoices, payments, aged receivables/payables, and journal entries

Pre-mapped CRM dataset: leads/opportunities, pipeline stage, expected revenue, and win-rate metrics

Secure token-based API connection over Odoo JSON-RPC/XML-RPC — rotatable tokens scoped to a least-privilege service user, stored hashed

Custom model and field selection: expose any Odoo model, including custom modules and Studio fields, as a Power BI table

Multi-company support that honors Odoo record rules and res.company scoping so each company's data stays correctly bounded

Multi-currency support with currency fields carried through for conversion and per-company slicing in Power BI

Security enforced through ir.model.access.csv and record rules — Power BI only ever reads what the service account is permitted to see

Odoo-to-Power BI field typing handled (dates, monetary, selection, many2one) so authors avoid manual data-type wrangling

Compatible with Odoo 17, 18, and 19 on both Community and Enterprise editions

Pagination and incremental extraction for large tables so refreshes stay fast and don't time out

Audit-logged pulls so IT can see which datasets were queried, when, and by which token

Built to order, done for you

No DIY setup — a working app, built, installed and supported by ECOSIRE.

You order

Start with a one-time build price. We scope it with you at kickoff.

We build & install

ECOSIRE builds, configures and installs it on your Odoo.

Go live + support

You go live in about 2–4 weeks, with a post-launch support window.

About this Product

Your Microsoft stack runs on Power BI, but your operational truth lives in Odoo — and copy-pasting exports into spreadsheets is not analytics. The Power BI Connector for Odoo closes that gap. It is a purpose-built, build-to-order Odoo module that ECOSIRE designs, develops, installs, and supports so your data team can pull Odoo data straight into Power BI Desktop and the Power BI Service, on a live connection or a scheduled refresh, without brittle CSV pipelines or a shadow ETL stack.

This is not an off-the-shelf apps.odoo.com download. After purchase, ECOSIRE builds the connector against your actual database — your models, your custom fields, your access rules — and hands you a clean, upgradeable Odoo app plus everything needed to run it in production. Under the hood it is a proper Odoo module: a token-authenticated read endpoint layered over Odoo's JSON-RPC/XML-RPC API, backed by dedicated data-access models, hardened by ir.model.access.csv and record rules so Power BI only ever sees the records a service account is permitted to read. Because it respects Odoo's own ORM and security layer, multi-company boundaries and record-level rules that already exist in your Odoo apply automatically to every query Power BI makes.

Out of the gate you get pre-mapped datasets for the domains your executives actually ask about — Sales (orders, order lines, margins, salesperson performance), Inventory (on-hand quantities, valuation, stock moves), Accounting (invoices, payments, aged receivables/payables, journal entries), and CRM (pipeline, stage, expected revenue, win rate). Each dataset arrives with the joins, currency handling, and Odoo-to-Power BI field typing already done, so a Power BI author can drop a table onto a canvas and build a report in minutes instead of reverse-engineering Odoo's schema. Need more than the standard four domains? Custom model and field selection lets ECOSIRE expose any model in your database — including your bespoke modules and studio fields — as a first-class Power BI table.

Refresh works the way Power BI expects. Use DirectQuery-style live pulls for near-real-time operational dashboards, or configure the Power BI Service scheduled refresh (and an on-premises data gateway where your Odoo isn't publicly reachable) for heavier historical models that don't need to be second-fresh. Multi-company and multi-currency are first-class: figures come through with company scoping intact and currency fields carried so you can convert or slice by company in Power BI without guessing which res.company a row belongs to.

The connector is compatible with Odoo 17, 18, and 19 and works on both Community and Enterprise editions — ECOSIRE targets your specific version's __manifest__.py, ORM, and API surface so nothing breaks on your next Odoo upgrade. Security is treated as a feature, not an afterthought: connections authenticate with rotatable API tokens scoped to a dedicated, least-privilege service user, tokens are stored hashed, every pull is auditable, and no analyst ever needs a real Odoo login or database credentials. The result is a governed, IT-approved bridge between your ERP and your BI platform — one that your data team owns, ECOSIRE supports, and Microsoft's tooling treats as a native source.

What you get

Fully built Odoo module (source code, __manifest__.py, models, security CSV, record rules, views) targeted to your Odoo 17/18/19 version and edition

Installation and configuration on your Odoo instance (staging first, then production), including the dedicated least-privilege API service user and token setup

Pre-mapped Power BI datasets for Sales, Inventory, Accounting, and CRM, plus any custom models scoped during discovery

A starter Power BI (.pbix) template with the connection and pre-mapped tables wired in, ready for your authors to build on

Connection and refresh setup: live vs. scheduled configuration, and on-premises data gateway guidance where required

Technical documentation: connection guide, dataset/field dictionary, token rotation runbook, and upgrade notes

A live handover and training session for your data/BI team covering connection, refresh, and adding new models

A post-deployment support window for fixes, questions, and adjustments, plus version-compatibility updates during that window

Who this is for

Enterprise BI / Data Team Lead

Standardizing all reporting on Microsoft Power BI and needs Odoo to behave like a governed, first-class data source — not a manual export. Wants pre-mapped datasets, scheduled refresh, and a connection IT will actually approve.

Finance & Operations Director

Lives in aged-receivables, margin, and inventory-valuation dashboards. Needs Odoo Accounting, Sales, and Inventory numbers in Power BI daily, correctly scoped by company and currency, without waiting on someone to email a spreadsheet.

IT Manager / Odoo Administrator

Owns database security and the upgrade path. Wants BI access via a least-privilege token and service user — never real logins — with record rules and multi-company boundaries enforced by Odoo itself, and a module that survives the next Odoo upgrade.

Data Analyst / Power BI Author

Builds the actual reports and is tired of reverse-engineering Odoo's schema. Wants clean, correctly-typed tables with joins already done so they can go from blank canvas to published dashboard the same day.

How Power BI Connector for Odoo Compares

Criterion	ECOSIRE	Custom Build	Competitor
Time to first dashboard	2–4 weeks to a built, installed connector with pre-mapped Sales/Inventory/Accounting/CRM datasets and a starter .pbix	Months of in-house ETL/API work before the first reliable dashboard	Fast to install, but generic mappings mean weeks of your own remodeling to fit your schema
Pre-mapped Odoo datasets	Included	Not included	Partial support
Live and scheduled refresh into Power BI	Both live (DirectQuery-style) and Power BI Service scheduled refresh, with gateway support	Whatever you build and maintain yourself	Usually scheduled only; live pulls often limited or unsupported
Security via record rules & least-privilege token	Included	Partial support	Partial support
Multi-company & multi-currency handling	Included	Partial support	Partial support
Custom models & Studio fields exposed to Power BI	Included	Included	Not included
Odoo 17/18/19 + Community & Enterprise upgrade-safety	Version-targeted, manifest-clean, upgrade-friendly module across all three	Breaks on upgrade unless you re-engineer it each time	Depends on the vendor keeping pace with each Odoo release
Ongoing support & ownership	Included support window + optional maintenance; you own the source code	You own it and you alone maintain it — the whole burden is internal	Vendor support varies; you rarely get or control the source

Frequently Asked Questions about Power BI Connector for Odoo

How long until my Power BI connector is ready, and how does delivery work?

This is a build-to-order module, not an instant download. After purchase, ECOSIRE runs a short discovery call to confirm your Odoo version (17/18/19), edition, hosting, and which models and custom fields you need. We then build and test the connector, install it on your staging instance first, validate the datasets against your data, and promote to production. Typical lead time is 2–4 weeks depending on how many custom models you want mapped. You get progress checkpoints along the way, and final handover includes installation, the starter .pbix template, documentation, and a training session.

What support and updates are included after delivery?

Every build includes a post-deployment support window for bug fixes, connection issues, and questions from your BI team. During that window we also cover version-compatibility adjustments — for example, if a field changes or you move between Odoo 17, 18, and 19. Because the module respects Odoo's ORM and __manifest__.py conventions, it is upgrade-friendly by design. After the initial window, ongoing support and enhancement (new datasets, new models, added companies) is available through a support/maintenance agreement so you are never left with an unmaintained connector.

Does this work with Odoo Community, or do I need Enterprise?

It works with both. The connector is built on Odoo's standard ORM, JSON-RPC/XML-RPC API, and security layer (ir.model.access.csv and record rules), all of which exist in Community as well as Enterprise. ECOSIRE targets your specific edition and version so the module installs cleanly whichever you run.

Is it secure? Will Power BI see data it shouldn't?

No. Power BI connects using a rotatable API token bound to a dedicated, least-privilege service user — not a real employee login or raw database credentials. That user's access is governed by Odoo's own ir.model.access.csv and record rules, so any multi-company boundary or record-level restriction you already enforce in Odoo automatically applies to every Power BI query. Tokens are stored hashed, can be rotated on demand, and pulls are audit-logged so IT can see what was queried and when.

Can it refresh in real time, or only on a schedule?

Both. You can configure live DirectQuery-style pulls for operational dashboards that need to be current to the minute, and scheduled refresh in the Power BI Service for larger historical models. When your Odoo instance isn't publicly reachable, we set up the connection to work through an on-premises data gateway so scheduled refresh still runs securely.

Can it pull our custom modules and Studio fields, not just standard Odoo apps?

Yes. Beyond the pre-mapped Sales, Inventory, Accounting, and CRM datasets, custom model and field selection lets ECOSIRE expose any model in your database — including bespoke modules and Studio-added fields — as a first-class Power BI table, with the correct field typing and joins built in during the engagement.