| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Inventory (stock) • Invoicing (account) • Manufacturing (mrp) • Purchase (purchase) |
| Community Apps Dependencies | Show |
| Lines of code | 8778 |
| Technical Name |
ecosire_powerbi_connector |
| License | LGPL-3 |
| Website | https://www.ecosire.com |
| Versions | 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Inventory (stock) • Invoicing (account) • Manufacturing (mrp) • Purchase (purchase) |
| Community Apps Dependencies | Show |
| Lines of code | 8778 |
| Technical Name |
ecosire_powerbi_connector |
| License | LGPL-3 |
| Website | https://www.ecosire.com |
| Versions | 17.0 18.0 19.0 |
|
ECOSIRE (PRIVATE) LIMITED
AI Powered Business Solutions
|
v19.0.1.0.0 |
Power BI Connector
The most advanced Power BI connector for Odoo. Push data, pull via REST API, embed reports — with 6 pre-built templates and a semantic data layer that transforms raw Odoo data into business-ready analytics.
|
Odoo
Your ERP Data
|
◄───►
Push & Pull
|
Power BI
Your Analytics
|
Real-Time Connector Dashboard
Monitor sync status, connection health, template deployment, and errors — all from a single OWL-powered dashboard inside Odoo.
Three Ways to Connect
|
📤
Push to Power BIAutomatically push Odoo data to Power BI datasets on a schedule. Full sync or delta (incremental) mode with 10,000-row chunked batches. Semantic name resolution included. |
📥
Pull REST APISecure REST API that Power BI Desktop can query directly. Hashed API tokens, paginated results, model whitelisting, and full Odoo security context — no sudo anywhere. |
📊
Embed in OdooView Power BI reports and dashboards directly inside Odoo. OWL embed component with automatic token refresh. Requires Power BI Premium or Embedded capacity. |
6 Pre-Built Report Templates
Ready to use on day one. No Power BI expertise required.
|
📈
Sales AnalyticsRevenue trends, top customers, order pipeline, salesperson leaderboard, monthly comparison. |
🏭
ManufacturingMO status, production throughput, BOM cost vs sale price, cycle time analysis, WIP tracking. |
📦
InventoryStock levels by warehouse, turnover rates, valuation trends, low stock alerts, aging analysis. |
|
💰
Accounts ReceivableAR aging waterfall, top overdue customers, collection rate, DSO KPI, payment timeline. |
🛒
PurchasingVendor spend analysis, lead time trends, PO status pipeline, on-time delivery rates. |
🛍
ShopifyOnline vs offline revenue split, channel performance, top online products, geographic analysis. |
One-Click Template Deployment
Download .pbix files for Power BI Desktop or auto-deploy to Power BI Service with Premium capacity.
Semantic Data Layer
Raw Odoo data transformed into business-ready analytics. No more cryptic IDs in your dashboards.
| Raw Odoo Data | ➡ | Power BI Output |
|---|---|---|
partner_id: 42 |
→ | Customer Name: "Landmark Group" |
state: "sale" |
→ | Order Status: "Confirmed" |
invoice_date_due: 2026-01-15 |
→ | Aging Bucket: "61-90 days" |
amount_untaxed: 10000
|
→ | Gross Margin: 40% |
22 pre-configured rules across Sales, Manufacturing, Inventory, AR, and Purchasing domains.
Easy Azure AD Configuration
Service Principal or OAuth 2.0 — connect in minutes with automatic token refresh.
Enterprise-Grade Features
|
🔒 Security First
SHA-256 hashed API tokens, no sudo, user-context queries, multi-company record rules. |
⚡ Delta Sync
Incremental sync using write_date watermark. Only changed records are pushed. Full sync on demand. |
⏰ Cron Automation
Schedule syncs per table: every N minutes, hours, or days. Token auto-refresh every 30 minutes. |
📝 Audit Trail
Every sync logged: rows pushed, timing, errors. API token usage tracked with last-used timestamps. |
|
🏢 Multi-Company
Company-isolated connections, workspaces, and data. Each company gets its own Power BI pipeline. |
🔧 MSAL Auth
Microsoft Authentication Library for Python. Service Principal + OAuth 2.0 Authorization Code flows. |
📂 11 Models Pre-Whitelisted
sale.order, account.move, mrp.production, stock.quant, purchase.order, res.partner, and more. |
🌍 Workspace Management
Import, create, and publish Power BI workspaces. Manage datasets, tables, reports, and dashboards from Odoo. |
Requirements
| Python | pip install msal requests |
| Azure | App Registration with Service Principal (Tenant ID, Client ID, Client Secret) |
| Power BI | Pro ($14/mo) for push + pull. Premium/Embedded for embedding + template auto-deploy. |
| Odoo | 17.0 / 18.0 / 19.0 — Community or Enterprise |
Please log in to comment on this module