Availability |
Odoo Online
Odoo.sh
On Premise
|
Lines of code | 305 |
Technical Name |
powerbi_api |
License | See License tab |
Website | https://www.infintor.com |
Versions | 17.0 18.0 |
Availability |
Odoo Online
Odoo.sh
On Premise
|
Lines of code | 305 |
Technical Name |
powerbi_api |
License | See License tab |
Website | https://www.infintor.com |
Versions | 17.0 18.0 |
Power BI Connector for Odoo
Easily connect your Odoo data to Power BI and unlock advanced data visualization and reporting capabilities.
Our Power BI Connector module enables seamless integration between Odoo and Microsoft Power BI, helping businesses transform their raw data into actionable insights. With easy token-based access, selective field exposure, and full API auditing, this module ensures secure, customizable, and efficient reporting.
1. Community
2. Enterprise
3. odoo sh
Key Features of Power BI Connector for Odoo

Direct Odoo to Power BI Integration
Export your Odoo data models directly into Power BI using built-in connector endpoints. Connect tables from sales, CRM, inventory, accounting, HR, and more – without manual CSV exports or third-party middleware.

Secure REST API Connectivity
Our module uses Odoo's native security and authentication systems with token-based REST API architecture, ensuring safe and encrypted data transmission between Odoo and Power BI.

Customizable Data Models
Choose the exact Odoo models (and fields) you want to analyze in Power BI. Whether it's revenue by region, inventory trends, or employee performance, you stay in control of your metrics.

No External Tools Required
Unlike other connectors, our app is built to work independently within Odoo and Power BI. No need for additional ETL tools, middleware, or server configurations.

Role-Based Access Control
Maintain strict control over what data is exposed to Power BI. Define access levels based on user roles or departments to prevent unauthorized exposure of sensitive business data.

Easy API Token Management
Generate, manage, and revoke API tokens for different users or services through the user-friendly Odoo backend.

Developer Friendly
Our module is fully extensible for developers. Need to add custom fields, or connect to custom models? It's easily done through standard Odoo development practices.

Multi-Company Support
Built to handle Odoo's multi-company environments. Fetch and analyze data specific to one or multiple companies based on your access rights.
--- HOW IT WORKS ---
Power BI Menu Integration
A dedicated Power BI menu added to your Odoo interface for easy access and configuration.
API Tokens:
Generate secure API tokens per user for connecting Power BI to Odoo.
Control access with active/inactive token status
Token-based access ensures data protection and user-level control.


Power BI Models
Choose specific models (Odoo objects) to expose for Power BI reporting.
Flexibility to select only required models, avoiding unnecessary data load.

Field Selection
Select specific fields to be shown in Power BI from the chosen models.
Customize the dataset based on your reporting requirements.

API Audit Trail
Monitor all API calls with detailed logs.
Logs include:

Odoo – Power BI Connector
Easily connect your Odoo data with Power BI for real-time reporting and dynamic visualizations.
Install the Power BI Integrator Module from Infintor & install Custom Connector
Power BI Functional Flow:
Navigation: Power BI – Get Data
Open Power BI Desktop
Go to Home > Get Data > Odoo
Odoo Enhancement Connector Wizard:
In Odoo, click on Odoo Enhanced (custom) and enter the details
Enter the following details:
IP Address
API Token
Click the OK button to activate the connection

Model Navigation in Power BI
In Power BI, under the Navigator, you will see all models selected in Odoo
Choose your desired model

Power BI will show a preview of the table, including the selected Odoo fields.
Sample Graphs & Visuals
Below is a example screenshot to showcase how your data can be visualized once connected and configured.




Our Services

Odoo Implementation
End-to-end Odoo implementation to meet your business needs.

Odoo Customization
Custom solutions tailored to your unique requirements.

Odoo Support & Training
Comprehensive support and training to enhance your Odoo usage.

Hire an Odoo Developer
Get access to skilled Odoo developers for your project needs.

Odoo Integration
Integrate Odoo seamlessly with third-party apps and systems.

Odoo Hosting & Cloud
Secure and scalable Odoo hosting solutions.

Odoo Maintenance
Ensure smooth and uninterrupted operations.

Odoo Consulting
Expert consulting to help you leverage Odoo for maximum efficiency.
Support & Demo
**Software License Agreement** This Software License Agreement ("Agreement") is made by and between Infintor Solutions ("Licensor") and any purchaser or user of the software ("Licensee"). 1. **Grant of License** Infintor Solutions hereby grants Licensee a non-exclusive, non-transferable license to use the software product (the "Software") purchased from the Odoo Apps Store under the terms and conditions set forth in this Agreement. 2. **Scope of Use** 2.1 Licensee may install and use the Software on one production instance and one development instance, as applicable. Any additional usage must be covered by separate licenses. 2.2 The Software and associated files may only be used (executed, modified, executed after modifications) if a valid license has been purchased from Licensor, typically via Odoo Apps, or if written agreement has been received from Licensor. 2.3 Licensees may develop Odoo modules that use the Software as a library (typically by depending on it, importing it, and using its resources), but without copying any source code or material from the Software. Licensees may distribute those modules under the license of their choice, provided that this license is compatible with the terms of the Odoo Proprietary License (e.g., LGPL, MIT, or proprietary licenses similar to this one). 2.4 Licensee may not publish, distribute, sublicense, sell, or provide copies of the Software to third parties, except as explicitly permitted under this Agreement. 3. **Ownership** The Software and any associated documentation are the sole property of Infintor Solutions. Licensee acknowledges that no title or ownership of the Software is transferred by this Agreement. 4. **Restrictions** Licensee shall not: - Copy, modify, or create derivative works of the Software; - Reverse engineer, decompile, or disassemble the Software; - Rent, lease, or sublicense the Software to any third party; - Use the Software in any manner that violates applicable laws or regulations; - Remove, alter, or obscure any proprietary notices (including copyright and trademark notices) from the Software. 5. **Confidentiality** Licensee acknowledges that the Software and any associated documentation contain proprietary and confidential information of Infintor Solutions. Licensee agrees to maintain the confidentiality of such information and not to disclose it to any third party without the prior written consent of Infintor Solutions. 6. **Updates and Support** Infintor Solutions may provide updates to the Software at its discretion. Any updates provided shall be governed by the terms of this Agreement. Support services, if offered, shall be subject to separate terms. 7. **Termination** 7.1 This Agreement shall remain in effect until terminated. 7.2 Infintor Solutions may terminate this Agreement immediately if Licensee fails to comply with any of its terms. Upon termination, Licensee must cease all use of the Software and destroy all copies. 8. **Limitation of Liability** In no event shall Infintor Solutions be liable for any indirect, incidental, special, or consequential damages arising out of or in connection with the use of the Software, even if Infintor Solutions has been advised of the possibility of such damages. 9. **Indemnification** Licensee agrees to indemnify, defend, and hold harmless Infintor Solutions from and against any claims, damages, losses, liabilities, and expenses arising out of or in connection with Licensee's use of the Software. 10. **Governing Law** This Agreement shall be governed by and construed in accordance with the laws of India. 11. **Entire Agreement** This Agreement constitutes the entire understanding between the parties with respect to the Software and supersedes all prior agreements, understandings, and communications. 12. **Severability** If any provision of this Agreement is found to be invalid or unenforceable, the remainder of this Agreement shall remain in full force and effect.
Please log in to comment on this module