Connecting Odoo to Power BI does not require a consultant or a custom development project. The Zehntech Odoo Power BI Connector handles the hard parts — authentication, schema management, scheduled sync — so you can focus on building dashboards.
This guide is for Odoo administrators and IT implementers connecting Odoo to Power BI for the first time. By the end, you will have live Odoo data flowing into Power BI — either via DirectQuery for real-time access or scheduled sync for automated batch updates.
No advanced development skills are required. Estimated setup time: 1–3 hours.
Prerequisites — What You Need Before You Start
Confirm the following before installing:
- Odoo version: v16, v17, v18, or v19 — all supported
- Deployment: Odoo Online, Odoo.sh, or On-Premise — all compatible
- Power BI: Power BI Desktop (free) is sufficient for DirectQuery and basic reporting. Power BI Pro or Premium is only required if you want to share dashboards across your team or publish datasets to Microsoft Fabric.
- Odoo access: Admin rights to install modules and create API keys
- Module dependency: Discuss (mail) module — built into Odoo by default, no extra installation needed
- Time required: 1–3 hours for full setup including dashboard configuration
Step 1 — Connect: Install and Authenticate
Install the connector from the Odoo App Store. Navigate to Main Apps in your Odoo backend, search for the Zehntech Power BI Connector, and install it. The module installs like any standard Odoo app — no server restart required.
Create a private app token in Odoo. Go to Settings → Technical → API Keys. Create a new API key — this is your private app token. Copy it and store it securely. This token is how Power BI authenticates with your Odoo instance without transmitting your password.
Configure the connector. In the connector configuration screen, enter:
- Your Odoo instance URL
- The private app token you just created
- Choose your deployment type: Standalone Power BI or Microsoft Fabric
The connector uses private app token authentication — no passwords are stored or transmitted. All connections are encrypted and access is governed by your existing Odoo security roles and permissions.
Step 2 — Sync: Configure Your Data Models
With authentication complete, configure which Odoo data to bring into Power BI.
Select your Odoo modules. Choose which modules to sync — Sales, Inventory, Accounting, CRM, or any custom Odoo modules you have built. The connector supports multi-model sync, meaning you can configure all modules simultaneously in one setup.
Choose your sync mode:
- DirectQuery — live queries run directly against your Odoo database every time a Power BI report is opened. Data is always current. No export file is created. Best for dashboards that need to reflect real-time Odoo data.
- Scheduled Export — configure a cron job frequency (hourly, daily, or weekly) via Odoo’s built-in scheduler. The export runs automatically on the schedule you set. No manual triggering required. Best for large datasets or teams with lower real-time requirements.
Map your fields dynamically. Choose which Odoo fields to expose in Power BI. Fields can be mapped and updated at any time without disrupting existing reports or dashboards.
Create and manage tables. Define the table structure, set up relationships between models, and update schemas as your Odoo configuration evolves. The connector handles schema management — when Odoo updates, your tables stay intact.
Step 3 — Analyse: Build Dashboards in Power BI
With your data models configured, open Power BI Desktop.
Get Data → choose your Odoo connector. Your configured Odoo connection appears as a data source. Select it.
Choose your mode. Use DirectQuery mode to query live Odoo data on every report open. Use Import mode for scheduled datasets. Both modes are supported.
Build your first report. Drag Odoo fields onto the Power BI canvas — sales by period, inventory levels, outstanding invoices, pipeline by stage. Every field you mapped in the connector is available as a Power BI dimension or measure.
Apply filters. Use Power BI’s native filter panel to apply date ranges, product categories, sales teams, or any other dimension from your Odoo data. Filters work the same way as any other Power BI data source.
Publish to Microsoft Fabric (if using Pro or Premium licence). The connector supports Eventhouse and KQL dataset publishing — your Odoo datasets can be published directly to Microsoft Fabric for enterprise-scale Power BI deployment.
Troubleshooting — Common Questions
Does this connector work with all Odoo editions and versions?
Yes. The Odoo Power BI Connector supports Odoo v16, v17, v18, and v19 across all deployment types — Odoo Online, Odoo.sh, and On-Premise. No edition restrictions apply.
Do I need a paid Power BI license to use this connector?
No. The connector works with Power BI Desktop (free) for DirectQuery and basic reporting. A Power BI Pro or Premium license is only required if you want to share dashboards across your team or publish datasets to Microsoft Fabric.
Is my Odoo data secure when connecting to Power BI?
Yes. The connector uses private app token authentication — no passwords are stored or transmitted. All connections are encrypted and access is governed by your existing Odoo security roles and permissions.
What to Do Next
After your first live connection is working:
- Add a second data model — if you started with Sales, add Inventory or Accounting to the same connector configuration
- Set up continuous refresh for datasets that need to stay current throughout the working day
- Explore Microsoft Fabric integration if your organisation uses Power BI Premium for enterprise-scale deployment
- Contact Zehntech support if you encounter schema issues or connection errors — 90 days of free support is included with every purchase
Connecting Odoo to Power BI Starts Here
Connecting Odoo to Power BI does not require a consultant or a custom development project. The Zehntech connector handles authentication, schema management, and scheduled sync — so you can focus on building the dashboards your team actually needs.
Power BI consultant setup: $150/hr × 40 hours = $6,000. The Zehntech Odoo Power BI Connector: $122.09 one-time. 90 days of free support included.
Install the Odoo Power BI Connector — $122.09 one-time
→ https://apps.odoo.com/apps/modules/19.0/zt_odoo_powerbi_connector
Not sure if you need this? Read why manual Odoo exports break Power BI reporting → http://why-manual-odoo-data-exports-are-breaking-your-power-bi-reporting/
