Odoo Business Intelligence: Native Reports, Spreadsheet or Power BI
Odoo business intelligence explained: native reports, Spreadsheet and Dashboards, their limits, when to add Power BI, and data access by hosting type.
Most articles on Odoo business intelligence promise an analytics engine and stop there. The useful question is narrower: which report belongs in Odoo, and which one needs a BI tool? Our Odoo consulting services answer that before anyone buys a connector.
Related service: Odoo implementation services — fixed-scope implementations with a named senior team.
This guide is for owners, finance leads and IT managers on Odoo 19 or Odoo 20. If you want the build steps for KPI boards, read our guide to Odoo dashboards and alerts next; this post covers the whole stack and the Power BI decision.
What is Odoo business intelligence?
Odoo business intelligence is the set of built-in tools that turn Odoo records into reports: pivot and graph views, accounting reports, Odoo Spreadsheet and Dashboards. There is no separate BI app to buy or install.
Think of it as four layers. Each one answers a different kind of question, and each has a ceiling.
| Layer | What it does | Best for | Ceiling |
|---|---|---|---|
| Pivot and graph views | Group, filter and measure records in any app | Ad hoc questions on one model | One model at a time |
| Accounting reports | Balance sheet, profit and loss, aged balances, tax report | Finance and audit | Finance data only |
| Odoo Spreadsheet | Formulas over linked lists, pivots and charts | Cross-app analysis, budgets | Odoo data only, spreadsheet scale |
| Dashboards | Published spreadsheets with global filters | Weekly management review | Built and edited by admins |
| External BI tool | Models data from Odoo and other systems | Group reporting, history, big volumes | Extra license, data pipeline, upkeep |
The first four layers work on the same database your team posts into. That is the main strength of native reporting, and also its limit, as later sections show.
What does native Odoo reporting cover in each app?
Native Odoo reporting covers one app or one model at a time through the Reporting menu found in most apps. Odoo's documentation names two generic reporting views, graph and pivot, plus app-specific reports.
In a pivot view you pick measures and group rows and columns. Odoo notes that only numeric fields, such as integer, decimal and monetary fields, can be measured, plus a record count. Saved filters turn a good pivot into a repeatable report.
Accounting adds its own engine. The generic reports include the balance sheet, profit and loss, executive summary, general ledger, aged receivable, aged payable, cash flow statement and tax report. Each exports to PDF or XLSX and compares periods.
App reports go deeper than most teams expect. See our guides to Odoo CRM reporting and to Odoo inventory reports for the pipeline, valuation and aging views.
How do Odoo Spreadsheet and Dashboards work together?
Odoo Spreadsheet is the analysis layer and Odoo Dashboards is the publishing layer built on top of it. Odoo's docs say spreadsheets "serve as the foundation for dashboards", with data sources that connect each one to your database.
You insert a list, pivot or chart from any Odoo view into a spreadsheet. Each insert creates a data source, so the numbers update when the records change. Lists, pivots and charts from different apps can sit in the same file.
Finance teams get Odoo-specific functions such as ODOO.BALANCE, ODOO.CREDIT, ODOO.DEBIT, ODOO.RESIDUAL and ODOO.PARTNER.BALANCE. These pull ledger figures into a budget or board pack without an export.
A finished spreadsheet can be converted into a dashboard. Readers then use global filters, sort tables, and click a value to open the underlying records. Access follows user groups, and each reader sees only the data their own access rights allow.
Odoo 20 added useful controls. Our Odoo 20 Spreadsheet release notes list 30 changes, including calculated columns in dynamic lists and a manual recalculation mode for heavy files. Dashboards gained private dashboards and a fiscal year date filter.
One edition note: editing spreadsheets needs the Enterprise spreadsheet apps. Community users still get pivot and graph views in each app.
Where does native Odoo reporting stop?
Native Odoo reporting stops at the edge of the Odoo database and at the scale of a spreadsheet. The limits below come from Odoo's own documentation, so plan around them instead of finding them in a board meeting.
- Refresh timing: linked data refreshes when the spreadsheet is opened or the page reloads, or when you click Refresh all data. There is no scheduled refresh to a stored history.
- List size: a dynamic list shows a maximum of 80 records when first inserted; you edit the function to raise it.
- Sharing: spreadsheets with dynamic Odoo data can be shared with internal users only. Outside readers get a frozen copy.
- Downloads: an XLSX download freezes dynamic values at the moment of download.
- Upgrades: standard dashboards are reinstalled at each version upgrade, so changes made on the original are lost. Duplicate first.
- Exports: Odoo warns that large exports can time out and should be processed in smaller batches.
- Other systems: Odoo data sources point at Odoo models. Web analytics, ad spend, a second ERP or a legacy database need another route.
None of these is a defect. They mark the point where a reporting need stops being an Odoo setup task and becomes a data project.
When should you add Power BI to Odoo?
Add Power BI to Odoo when the question needs data from outside Odoo, stored history, or a data model too heavy for a spreadsheet. If the question is about current Odoo records, stay native.
These signs usually justify an external BI tool:
- Several sources: you report across Odoo plus another ERP, a marketing platform, a payroll provider or machine data.
- Snapshots: you need last month's stock or pipeline as it stood then, not as it stands today.
- Volume: analysts work on millions of rows and reports must stay fast for many readers.
- Group standard: the parent company already runs Power BI, Tableau or Looker Studio and wants one format.
- Outside readers: investors, franchisees or customers need filtered access without an Odoo login.
These signs do not justify it: wanting nicer charts, a team that has not learned pivot views, or one missing field. Those are fixed inside Odoo for far less money. Our post on why Odoo users keep Excel after ERP rollout covers that habit.
Odoo business intelligence vs Power BI: which fits which job?

Native Odoo business intelligence wins on speed, security and cost for Odoo data, while Power BI wins on blending sources, history and modeling. Most mid-size companies end up using both, each for its own job.
| Criterion | Odoo native BI | Power BI on Odoo data |
|---|---|---|
| Data freshness | Current records on open or refresh | As fresh as the last scheduled refresh |
| Data sources | Odoo models only | Odoo plus any other source |
| History | Current state, plus dated records | Stored snapshots by period |
| Access control | Odoo groups and record rules apply | Rebuilt separately in the BI tool |
| Drill to record | One click to the Odoo record | Needs a link back to Odoo |
| Extra license | Included with Odoo Enterprise | US$14.00 per user a month for Pro |
| Upkeep | Follows Odoo upgrades | Pipeline and model to maintain |
The access control row matters most. In Odoo, a salesperson limited to own documents sees only their own numbers on a shared dashboard. Once data leaves Odoo, those rules do not travel with it, and someone must rebuild them.
Microsoft lists Power BI Pro at US$14.00 per user a month, paid yearly, and Premium Per User at US$24.00. Power BI Desktop is a free download for building reports.
Refresh is not real time by default. Microsoft's documentation limits shared capacity to eight scheduled refreshes a day; Premium, Premium Per User and Fabric capacity allow up to 48. Each refresh must finish within two hours on shared capacity.
How can a BI tool read Odoo data on each hosting type?
A BI tool can read Odoo data in three ways: file exports, the external API, or a direct PostgreSQL connection, and your hosting decides which ones are open. This is the part most guides skip, and it decides the budget.
| Hosting | File export | External API | Direct PostgreSQL |
|---|---|---|---|
| Odoo Online | Yes, XLSX or CSV | Custom plan only | Not offered; backup download only |
| Odoo.sh, shared hosting | Yes | Yes | No remote connection; integrate over HTTP |
| Odoo.sh, dedicated hosting | Yes | Yes | Read-only external access over SSL |
| On-premise or own cloud | Yes | Yes on the Custom plan | Yes, you control the database |
The Odoo.sh FAQ says PostgreSQL External Access allows read-only connections for BI tools, only for projects on dedicated hosting. It lists Power BI, Tableau and Zoho Analytics as tested, and PgAdmin and Qlik Sense as incompatible.
On shared Odoo.sh hosting the same FAQ tells you to integrate "at the HTTP layer". Users hit this wall often: in one Odoo forum thread, a partner explains that Odoo.sh does not allow remote PostgreSQL connections and suggests exports or an API script.
For Odoo Online, the documentation describes a backup download and the API, not a database connection. A downloaded backup is a point-in-time copy, so it suits a one-off analysis, not a daily report.
On your own servers, Power BI's PostgreSQL connector supports Import and DirectQuery through an on-premises data gateway. Point it at a read-only replica or a reporting schema, never at the production database with a write-capable user.
What does the external API mean for Odoo and Power BI?
The external API is the standard way to feed Power BI from Odoo Online and shared Odoo.sh, and it is only available on the Odoo Custom plan. Odoo's docs state that API access "is not available on One App Free or Standard plans".
That changes the math. On the Odoo pricing page, the US price billed yearly is US$31.10 per user a month for Standard and US$61.00 for Custom. Moving plans only to feed a BI tool adds US$29.90 per user a month at list price, before any Power BI license.
Check the connector's protocol too. Many older Power BI connectors for Odoo call XML-RPC. XML-RPC and JSON-RPC are deprecated in Odoo 20 and scheduled for removal in Odoo 22, so new pipelines should use the JSON-2 API. Our Odoo JSON-2 API migration guide shows the change.
API extraction has a practical limit. It reads through the Odoo application, record by record, so very large daily loads are slow. Pull only changed records since the last run, and load them into a small reporting database that Power BI reads.
A word on Odoo AI: in Odoo 20 the AI features run on Odoo AI IAP credits at EUR 1 per credit. They help users ask questions and draft content, but they are not a reporting layer. See our AI and Odoo integration services for where AI fits.
Which reporting setup fits your industry?
The right Odoo reporting setup depends on how many systems hold your numbers, not on company size. The table shows where native tools are usually enough and where an external layer earns its cost.
| Industry | Reporting pain | Odoo approach | How iVentureTeam helps |
|---|---|---|---|
| Manufacturing | Margin by product, scrap, machine data | Pivot on manufacturing orders, Spreadsheet for cost roll-ups; BI for machine data | Define KPIs, build dashboards, link shop-floor data |
| Wholesale and distribution | Stock aging, vendor spend, rotation | Inventory reports and SQL reports inside Odoo | Write margin and rotation reports |
| Retail and eCommerce | Store, web and ad data in separate tools | Dashboards for sales; BI to blend ad and web data | Build the pipeline and a shared model |
| Professional services | Billable hours against targets | Timesheets dashboard with billing targets in Odoo 20 | Configure targets and role filters |
| Multi-company groups | Consolidated view across entities and ERPs | Odoo multi-company reports; BI when entities run other systems | Design the group reporting layer |
How do you decide between native Odoo BI and Power BI?

Decide report by report, starting with the question and ending with the tool. This order keeps the project small and stops a connector purchase from becoming the plan.
- List the reports: write down the 10 to 15 reports management really reads, with owner and frequency.
- Mark the source: for each one, note whether every number is in Odoo or some sit elsewhere.
- Build native first: cover the Odoo-only reports with pivots, accounting reports and spreadsheet dashboards.
- Check your access route: confirm your hosting and plan against the table above before choosing a BI tool.
- Price both sides: add BI licenses, any plan change, the pipeline build and yearly upkeep.
- Pilot one report: build the hardest blended report end to end, then decide on the rest.
For a first budget figure on the Odoo side, the Odoo project estimate tool gives an indicative cost and timeline in minutes. When data must move between systems, our Odoo integration services cover the pipeline.
How iVentureTeam helps with Odoo business intelligence
iVentureTeam designs the reporting layer first, then builds it with the lightest tool that answers each question. We have delivered 150+ ERP projects across 35+ countries with 40+ Odoo specialists, led by a consultant with 13+ years in Odoo.
- Reporting audit: your current reports mapped to native Odoo, Spreadsheet, SQL reports or external BI.
- Native build: saved pivots, financial report layouts and spreadsheet dashboards with filters per role.
- Custom reports: SQL views and report modules where standard reporting cannot answer the question.
- BI pipeline: JSON-2 API or read-only PostgreSQL feeds into Power BI or a small reporting database.
- Access and upkeep: permission design outside Odoo, refresh monitoring and checks after each Odoo upgrade.
Odoo business intelligence case study: Indep Consulting
A Belgian cleaning-chemicals company got its management reporting from SQL reports built inside Odoo, without an external BI tool. This case shows the middle path between standard reports and Power BI, so it differs from a Power BI rollout.
Indep Consulting sells cleaning chemicals and equipment and runs maintenance contracts. Sales, stock and accounting data sat in disconnected tools, so questions like product margin or vendor spend were slow to answer.
We implemented Odoo across 10+ business areas in 12 weeks, then wrote eight custom SQL reports. They cover invoices, orders, sales activity, product margin, vendor summary, stock, stock rotation and contracts.
The management reporting cycle became 2x faster, with margins, stock rotation and vendor performance visible on demand. Read the Indep Consulting Odoo ERP and SQL reporting case study.
The bottom line on Odoo business intelligence
Use native Odoo business intelligence for every question that Odoo data alone can answer, and add Power BI only for blended, historical or high-volume reporting. The tool matters less than knowing where each number comes from.
Check your hosting and plan before you choose a BI tool, because they decide how data can leave Odoo and what it costs. A short reporting audit usually removes half the reports from the BI wish list.
Ready to plan your Odoo reporting and BI setup?

Get a clear map of which reports stay in Odoo and which need a BI tool. Request an Odoo reporting and BI review, call +91-90235-15208, or email business@iventureteam.com.
Frequently Asked Questions
Does Odoo have business intelligence?
+
Odoo has built-in BI tools: pivot and graph views in each app, dynamic accounting reports, Odoo Spreadsheet and the Dashboards app. They report on current Odoo data without a separate product.
Can you connect Power BI to Odoo?
+
Power BI can read Odoo through file exports, the external API, or PostgreSQL. The API needs the Odoo Custom plan. Direct database access is open on your own servers and read-only on Odoo.sh dedicated hosting.
Can Power BI connect to Odoo Online?
+
Power BI can read Odoo Online through the external API on the Custom plan, or through exported files. Odoo Online does not offer a PostgreSQL connection, only a backup download, which is a point-in-time copy.
Is Odoo Spreadsheet enough for dashboards?
+
For Odoo data, usually. Spreadsheets hold linked lists, pivots, charts and formulas, and convert into dashboards with global filters. They do not blend outside sources or store period snapshots.
Does Odoo Community include dashboards and spreadsheets?
+
Community includes pivot and graph views in each app. Editing spreadsheets needs the Enterprise spreadsheet apps, so building custom spreadsheet dashboards is an Enterprise task.
How much does Power BI cost with Odoo?
+
Microsoft lists Power BI Pro at US$14.00 per user a month, paid yearly. Add the Odoo Custom plan if you need the API, the pipeline build and upkeep. Power BI Desktop itself is a free download.
Is Odoo dashboard data real time?
+
Dashboard data is retrieved each time the dashboard is opened or refreshed, so it shows current records. It is not a continuous stream, and it does not keep a history of past states.
Which BI tools work with Odoo besides Power BI?
+
The Odoo.sh FAQ lists Power BI, Tableau, DBeaver, Datapine and Zoho Analytics as tested with its read-only PostgreSQL access on dedicated hosting. Any tool that reads PostgreSQL or a REST API can work.
Do Odoo access rights carry over to Power BI?
+
No. Odoo groups and record rules apply inside Odoo only. Once data is loaded into a BI tool, you must rebuild who can see what there, for example with row-level security.
Free integration feasibility review
Connecting your other systems to Odoo?
Tell us what needs to sync between your systems and Odoo. We recommend a connector, API or custom approach and plan how failures are handled.
Free, with no obligation. A senior consultant replies within 12 business hours.
Free Odoo tools
All tools- Odoo Health CheckVersion, modules, findings and upgrade cost
- Odoo App SelectorWhich apps you need, by industry
- Odoo Project EstimateIndicative cost and timeline in minutes
- Odoo Implementation Cost CalculatorImplementation cost and timeline, in minutes
- Odoo Migration Cost CalculatorVersion jump or legacy ERP, priced in minutes
Continue reading
Spreadsheets After ERP Implementation: Why Odoo Users Keep Excel
Why teams keep Excel after an Odoo go-live, the hidden risks of shadow spreadsheets, and a fix plan using Odoo 20 Spreadsheet, Dashboards and imports.
Odoo ERP Implementation in Saudi Arabia: ZATCA, Arabic, Cost, Timeline
Odoo ERP implementation in Saudi Arabia: Odoo 19 vs 20, ZATCA Phase 2 onboarding, Arabic invoices, GOSI and WPS payroll, hosting, cost and timelines.
Odoo Post Implementation Review: 30/60/90 Day Checklist and Template
Run an Odoo post implementation review at 30, 60 and 90 days: go-live checklist, six KPIs, Odoo 19 and 20 checks and a report template you can copy.
