The integration of enterprise systems like Odoo with business intelligence (BI) tools such as Microsoft Power BI is transforming how organizations leverage their data. This guide explores how to connect Odoo – one of the world’s fastest-growing open-source ERP platforms – with Power BI, unlocking real-time analytics, automated reporting, and data-driven decision-making for your business.
What is Odoo?
Odoo is a comprehensive, modular ERP solution used by over 15 million users worldwide. It covers everything from CRM, sales, and accounting to inventory, HR, and project management.
The platform is known for its flexible architecture, rapid deployment, and a thriving ecosystem of over 52,000 modules and apps. According to industry analysis on the future growth of Odoo, recent versions have introduced AI-driven automation and enhanced integration capabilities, making Odoo a strong choice for both SMEs and enterprises.
What is Power BI?
Power BI is Microsoft’s business analytics platform designed to help organizations visualize data, build interactive dashboards, and share insights across teams.
Power BI is available in multiple editions – Desktop (free), Pro (collaboration and sharing), and Premium (enterprise-scale analytics). A detailed comparison of Power BI Free vs Pro vs Premium explains how each version fits different business needs, while official Power BI pricing outlines licensing options.
Why integrate Odoo with Power BI?
An Odoo to Power BI integration allows businesses to turn raw ERP data into actionable insights. By connecting Odoo to a BI tool, organizations gain:
- Real-time dashboards with up-to-date KPIs
- Automated financial and operational reporting
- The ability to blend Odoo data with other business systems
- Improved decision-making through interactive analytics
Companies that move beyond manual exports and spreadsheets often experience faster reporting cycles and better data accuracy. Several real-world Odoo Power BI reporting examples highlight these benefits, especially when supported by a robust integration layer.
Integration methods: how do you connect Odoo to Power BI?
| Feature | Direct API / Connector | Manual Export | Data Warehouse via Peliqan |
|---|---|---|---|
| Setup Complexity | Low–Medium | Low | Low |
| Real-time Data | Yes | No | Yes |
| Cost | Varies | Free | Subscription (free trial available) |
| Automation | Yes | No | Yes |
| Data Volume | Medium | Low | High |
| Historical Data | Limited | Limited | Extensive |
| Maintenance | Low | High | Low |
For most organizations, a warehouse-based approach offers the best balance of scalability and reliability. Peliqan’s Odoo to Power BI integration provides fast setup, built-in data modeling, and automated sync between Odoo and Power BI – all without complex ETL pipelines or coding.
Step-by-step: Odoo to Power BI integration with Peliqan
This comprehensive guide walks you through connecting Odoo to Power BI using Peliqan. Most organizations complete this setup in under 3 hours and begin visualizing data immediately.
Phase 1: Preparation (15-30 minutes)
What you’ll need:
- An active Odoo subscription (Community or Enterprise edition)
- Admin or API access to your Odoo instance
- Power BI Desktop installed on your computer (download free here)
- A Peliqan account – start your free trial here
Before you start:
- Make a list of Odoo divisions/companies you want to connect
- Identify which financial and operational reports you need (P&L, cash flow, sales pipeline, inventory, etc.)
- Determine which Odoo modules you’re using (CRM, Sales, Accounting, Inventory, Manufacturing, etc.)
- Ensure you have proper access permissions in Odoo
Pro tip: If you’re managing multiple Odoo companies or working as an Odoo partner, consider exploring Peliqan’s Odoo partner program for additional benefits and support.
Phase 2: Setting up Peliqan (30-45 minutes)
Step 1: Create your Peliqan account
1. Visit Peliqan’s website
2. Click “Start Free Trial”
3. Enter your business details (company name, email, region)
4. Verify your email address
5. Log in to your new Peliqan workspace
Peliqan offers a fully-featured free trial with no credit card required, allowing you to test the complete Odoo to Power BI integration before committing.
Step 2: Connect Odoo to Peliqan
Peliqan’s Odoo connector makes connecting your ERP system simple and secure:
1. Navigate to Connections: In your Peliqan dashboard, click on “Connections” in the left sidebar
2. Select Odoo: Click “Add Connection” and choose “Odoo” from the list of 250+ available connectors
3. Start OAuth Connection: Click “Connect Odoo” to begin the secure authentication flow
4. Authenticate: You’ll be redirected to your Odoo login page – sign in with your credentials
5. Authorize Access: Grant Peliqan permission to access your Odoo data (read-only by default)
6. Configure Basic Settings:
– Starting Year: Choose how far back to sync historical data (e.g., 2020, 2022, 2024)
– Country: Select your country for proper localization
– Divisions: Pick which Odoo companies/divisions to connect (you can start with one and add more later)
Pro tip: Start with one division and the most recent 2-3 years of data for your initial setup. This reduces sync time and allows you to test the integration quickly. You can always add more divisions and historical data later.
Step 3: Select Odoo models to sync
Peliqan automatically detects all available Odoo models. Choose the ones relevant to your reporting needs (like):
Core Financial Models:
- account.move – Journal entries, invoices
- account.payment – Payment records
Sales & CRM Models:
- crm.lead – Leads and opportunities
- sale.order – Sales orders and quotations
Inventory & Operations Models:
- product.product – Products and variants
- stock.move – Inventory movements
Peliqan’s intelligent sync engine handles relationships between these models automatically, so you don’t need to worry about foreign keys or data integrity.
Why Peliqan stands out: Unlike basic connectors, Peliqan understands Odoo’s relational structure and automatically flattens nested data for easy analysis in Power BI. This saves hours of manual transformation work.
Phase 3: Data configuration in Peliqan (30-45 minutes)
Step 1: Choose your data warehouse
Peliqan offers flexible data warehouse options:
Option 1: Peliqan built-in data warehouse (recommended for getting started)
- Zero configuration required – automatically provisioned
- Optimized for analytics queries
- PostgreSQL-based for wide compatibility
- Included in all Peliqan plans
- Perfect for small to medium datasets (up to several GB)
Option 2: Bring your own data warehouse
- Snowflake – Best for enterprise-scale analytics
- Google BigQuery – Excellent for Google Cloud users
- Microsoft Fabric/Synapse – Ideal for Microsoft ecosystem
- Amazon Redshift – Great for AWS environments
- ClickHouse – Ultra-fast for large-scale analytics
For most users starting out, the Peliqan built-in data warehouse is perfect. It’s pre-configured, requires no setup, and works seamlessly with Power BI.
Step 2: Configure sync settings
Peliqan intelligently manages Odoo’s API rate limits (5,000 calls per day per company) while maximizing data freshness:
Sync frequency options:
- Every 6 hours (Default) – Balances freshness with API limits
- Every 3 hours – For more time-sensitive data
- Daily – For historical analysis where real-time isn’t critical
- Custom schedule – Define specific times (e.g., overnight only)
Data optimization settings:
- Incremental Sync: Peliqan only syncs changed records after the initial load, dramatically reducing sync time
- Smart Pagination: Automatically handles large datasets by fetching data in optimized batches
- Automatic Retries: If a sync fails, Peliqan automatically retries with exponential backoff
- Historical Tracking: Optionally enable SCD Type 2 tables to track how records change over time
Click “Start Sync” and Peliqan will begin extracting your Odoo data. You can monitor sync progress in real-time from the Peliqan dashboard. Once complete, you’ll see all your Odoo tables ready for exploration.
Step 3: Explore and transform data in Peliqan (optional)
Before connecting Power BI, you can optionally use Peliqan’s built-in features to prepare your data:
Peliqan spreadsheet interface:
- Browse your Odoo data in a familiar spreadsheet-like UI
- Filter, sort, and preview data before building reports
- Verify data quality and completeness
SQL transformations with AI assistance:
- Use Peliqan’s “Magical SQL” editor to create calculated fields and aggregations
- Ask the AI assistant to write SQL queries in plain English (e.g., “show me total revenue by customer for 2024”)
- Create star schema models with fact and dimension tables optimized for Power BI
- Save transformed views as new tables that automatically refresh
Low-code Python scripts:
- Write custom data transformations using Python
- Implement complex business logic that’s difficult in SQL
- Create calculated KPIs and metrics
Why this matters: By doing transformations in Peliqan before Power BI, you keep your Power BI models lightweight and fast. Peliqan’s transformation engine can handle complex calculations on large datasets more efficiently than Power BI’s DAX engine.
Phase 4: Connect Power BI to Peliqan (30-45 minutes)
Now that your Odoo data is in Peliqan’s data warehouse, connecting Power BI is straightforward:
Step 1: Get Peliqan connection credentials
1. In Peliqan, navigate to “Data Warehouse” in the left sidebar
2. Click on “Connection Details”
3. Copy the following information:
- Server/Host: db.eu.peliqan.io (for EU) or db.us.peliqan.io (for US)
- Database name: Your workspace name (e.g., yourcompany-prod)
- Username & Password
- Port: **** (PostgreSQL default)
Step 2: Open Power BI Desktop
1. Launch Power BI Desktop on your computer
2. If you don’t have it installed, download it free from Microsoft
3. Click on “Get Data” in the Home ribbon
4. Select “More…” to see all data sources
Step 3: Configure PostgreSQL connection
Since Peliqan’s built-in warehouse uses PostgreSQL (the most compatible database for BI tools):
1. In the data sources list, search for “PostgreSQL”
2. Click “Connect”
3. Enter the connection details:
- Server: db.eu.peliqan.io (or your regional server)
- Database: Your Peliqan workspace name
4. Select “DirectQuery” or “Import” mode:
- Import (Recommended): Faster dashboard performance, scheduled refresh, works offline
- DirectQuery: Real-time data, no storage limits, but slower performance
5. Click “OK”
Step 4: Authenticate
1. Select “Database” as the authentication method
2. Enter your Peliqan username and password
3. Check “Use Encrypted Connection (SSL)”
4. Click “Connect”
Power BI will establish a secure connection to your Peliqan data warehouse containing all your Odoo data.
Step 5: Select your Odoo tables
The Navigator window will display all available tables. You’ll see:
Odoo source tables (prefixed with your Odoo connection name):
- odoo_account_move (invoices)
- odoo_sale_order (sales orders)
Transformed tables (if you created any in Peliqan):
- Custom views and aggregations you built
- Star schema fact/dimension tables
Selection strategy:
For your first dashboard, start simple:
1. Select 3-5 core tables that support your primary use case (e.g., for a Sales Dashboard: sale_order, sale_order_line, res_partner, product_product)
2. Preview the data by clicking each table – verify columns and data quality
3. Click “Load” to import the selected tables into Power BI
Peliqan advantage: All foreign key relationships from Odoo are automatically preserved in Peliqan, and Power BI will auto-detect most relationships. This saves significant time compared to manual relationship configuration.
Step 6: Verify relationships in Power BI
1. Click on “Model View” (icon on the left sidebar)
2. Review the automatically detected relationships between tables
3. Verify that relationships match your understanding (e.g., sale_order links to res_partner via partner_id)
4. Add any missing relationships by dragging fields between tables
Step 7: Configure refresh settings (import mode only)
If you chose Import mode:
1. Go to File → Options and Settings → Data Source Settings
2. Configure refresh schedule:
– Personal Use: Manual refresh by clicking “Refresh” button
– Power BI Service: Schedule automatic refreshes (up to 8x daily for Pro, 48x daily for Premium)
3. Peliqan continuously syncs your Odoo data, so each Power BI refresh pulls the latest information
Phase 5: Build your first dashboard (60-90 minutes)
Now comes the exciting part – creating visualizations! Here’s a starter dashboard that demonstrates common Odoo analytics:
Financial overview dashboard
📊 KPI Cards (Top of Dashboard)
where state = ‘sale’
grouped by payment type
📉 Monthly Revenue Trend
sale_order[date_order] by monthSUM(sale_order[amount_total])res_partner[country_id] to see revenue by country🏆 Top Customers by Revenue
res_partner[name]SUM(sale_order[amount_total])⏰ Invoice Aging Analysis
TODAY() – account_move[invoice_date]SUM(account_move[amount_residual])🎯 Sales Pipeline
crm_lead[stage_id]SUM(crm_lead[expected_revenue])💡 Power BI Pro Tips with Peliqan Data
- Use slicers for date ranges, salespeople, product categories, and divisions
- Create drill-through pages for detailed transaction views
- Add bookmarks for different views (Executive Summary, Sales Detail, Financial Detail)
- Enable mobile layout for access on phones and tablets
Step 8: Publish to Power BI Service
Once your dashboard looks great:
1. Click “Publish” in the Home ribbon
2. Sign in to your Power BI Service account (or create one)
3. Choose a workspace (or create a new one)
4. Click “Select” to publish
Your dashboard is now available online for sharing with your team!
Step 9: Share and collaborate
In Power BI Service (https://app.powerbi.com):
- Set up workspace access for your team
- Configure row-level security (RLS) if needed (e.g., salespeople see only their customers)
- Create apps to bundle related dashboards
- Schedule refresh (Peliqan keeps data fresh automatically)
- Share links or embed dashboards in SharePoint/Teams
Phase 6: Testing and validation (30 minutes)
Before rolling out to your organization:
Data accuracy verification:
- Compare key metrics in Power BI against Odoo’s native reports
- Check that totals match (revenue, invoice counts, customer counts, etc.)
- Verify that filters work correctly (date ranges, divisions, product categories)
- Test drill-through functionality and cross-filtering
Performance testing:
- Open dashboards and measure load times (should be < 5 seconds for most visuals)
- Test with multiple filters applied
- Verify that auto-refresh works in Power BI Service
- Check mobile view on actual devices
User acceptance:
- Show the dashboard to 2-3 key users from different departments
- Gather feedback on layout, metrics, and usability
- Make refinements based on their input
Peliqan support: If you encounter any issues during testing, Peliqan’s support team is available via email and chat. Many certified Odoo partners also specialize in Peliqan integrations and can provide expert assistance.
Phase 7: Training and rollout (ongoing)
User training:
- Schedule 30-minute training sessions for different user groups
- Create quick reference guides with screenshots
- Document common tasks (applying filters, exporting data, refreshing reports)
- Record a video walkthrough for on-demand learning
Establish governance:
- Define who can create new reports vs. who can only view
- Set naming conventions for dashboards and datasets
- Create a feedback channel (Teams, Slack, email) for enhancement requests
- Schedule monthly reviews to assess usage and identify improvements
Iterate and expand:
- Start with your initial dashboard serving one department or use case
- Gather feedback after 2-4 weeks of use
- Build additional dashboards for other departments (Operations, HR, Purchasing)
- Explore advanced Peliqan features like reverse ETL to write data back to Odoo
- Connect additional data sources (Shopify, Stripe, Google Analytics) to enrich Odoo data
Popular SQL queries for Odoo
- Total sales amount by product – Calculate the total sales amount for each product.
- Total revenue by customer – Calculate the total revenue generated by each customer.
- Top selling products – Identify the top selling products based on quantity sold.
Common challenges & solutions
Even with Peliqan simplifying the integration, you may encounter these common challenges:
1. API rate limits
Challenge: Odoo limits API calls to 5,000 per day per company, which can slow initial data loads.
How Peliqan solves this:
- Peliqan automatically throttles requests to stay within limits
- Intelligent batching optimizes the number of API calls needed
- Incremental sync ensures only changed data is fetched after the initial load
- You can prioritize critical tables to sync first
2. Complex data relationships
Challenge: Odoo’s relational structure can be complex with many foreign keys and nested objects.
How Peliqan solves this:
- Automatically detects and preserves all Odoo relationships
- Flattens nested data structures for easy Power BI consumption
- Provides pre-built data models for common Odoo use cases
- Star schema templates optimize query performance
3. Multi-company scenarios
Challenge: Organizations with multiple Odoo companies need consolidated reporting with proper data isolation.
How Peliqan solves this:
- Connect multiple Odoo instances to a single Peliqan workspace
- Automatic company identifier tagging for all records
- Easy implementation of row-level security in Power BI
- Consolidated views alongside company-specific dashboards
4. Historical data tracking
Challenge: Standard Odoo syncs don’t track how records change over time (e.g., price changes, status updates).
How Peliqan solves this:
- Optional SCD Type 2 (Slowly Changing Dimensions) tables automatically track historical changes
- Time-travel capabilities for point-in-time analysis
- Audit trail for compliance and forensic analysis
5. Performance with large datasets
Challenge: Power BI can slow down with millions of records or complex calculations.
How Peliqan solves this:
- Pre-aggregate data in Peliqan’s data warehouse before Power BI
- Create summary tables for common report queries
- Optimize data types and remove unnecessary columns
- Option to use enterprise data warehouses (Snowflake, BigQuery) for massive scale
See why leading Odoo Partners like Dynapps, OdooExperts, ERPopen trust Peliqan to solve their data challenges.
Why choose Peliqan for Odoo to Power BI integration?
While there are multiple ways to connect Odoo and Power BI, Peliqan stands out for several reasons:
- 5-minute setup – Connect Odoo and start syncing data in minutes, not days
- Built-in data warehouse – No need to provision separate infrastructure
- Automatic relationship handling – Odoo’s complex data model is simplified automatically
- Rate limit management – Intelligent syncing that respects Odoo’s API limits
- Historical tracking – Optional SCD Type 2 tables for time-travel analysis
- Multi-source support – Combine Odoo with 250+ other data sources
- Enterprise security – SOC 2 Type II certified, GDPR compliant, ISO 27001
Conclusion
Integrating Odoo with Power BI transforms how organizations leverage their ERP data. By combining Odoo’s operational strength with Power BI’s analytical capabilities, businesses gain real-time visibility into performance, automate reporting workflows, and make data-driven decisions faster.
With Peliqan’s Odoo to Power BI integration, you can complete the entire setup in under 3 hours – from connecting your Odoo instance to publishing your first dashboard. The platform handles all the complexity of data extraction, transformation, and loading, while you focus on building insights that drive your business forward.
Whether you’re a small business looking to gain better visibility into operations, or an enterprise seeking to unify data across multiple Odoo instances and other systems, Peliqan provides the foundation for scalable, reliable analytics.
Ready to get started?
- Start your free Peliqan trial – No credit card required
- Get started with Odoo connector – See documentation
Transform your Odoo data into actionable Power BI insights today with Peliqan.
