| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 457 |
| Technical Name |
powerbi_connector |
| License | OPL-1 |
| Versions | 17.0 18.0 19.0 |
Power BI Connector
Turn your Odoo database into live Power BI dashboards. Secure, fast, and ready in minutes — no manual exports, ever.
🛡️ Lifetime Support Guarantee
Every purchase includes lifetime support and bug fixes. We respond to every issue within 6 hours and resolve problems fast — your success with this module is guaranteed.
Key Features
Everything you need to analyze Odoo data in Power BI.
|
🔑
Token AuthenticationGenerate a secure access token in one click. No passwords stored in Power BI. |
📊
Browse Every ModelAll Odoo models — standard and custom — appear in the Power BI Navigator, ready to load. |
⚡
Raw SQL QueriesRun custom SQL for precise, high-performance control over exactly the data you pull. |
|
📦
Batch PaginationLarge tables stream in batches, so even millions of rows load reliably without timeouts. |
🌐
UTF-8 & Cyrillic SafeNon-Latin text (Bulgarian, Russian, Greek, Arabic…) displays perfectly in Power BI. |
📝
Full Sync LoggingEvery request is logged with status, record count, and timestamps for full auditability. |
What You Can Build
Popular dashboards that drive real business decisions.
📈 Sales AnalyticsRevenue, pipeline, conversion, and rep performance across regions. |
💰 Financial ReportingAutomated P&L, cash flow, and balance sheet dashboards. |
📦 Inventory KPIsStock levels, warehouse use, and demand forecasting in real time. |
👥 HR MetricsHeadcount, turnover, and employee performance analytics. |
🎯 Customer IntelligenceLifetime value, segmentation, and engagement patterns. |
🏭 ManufacturingProduction output, quality control, and supply-chain efficiency. |
How to Connect
Five simple steps to load Odoo data into Power BI.
1 |
Generate your tokenIn Odoo, open Power BI → Connector, then click Generate Token. Copy the URL and token. |
![]() |
|
2 |
Install the connectorCopy the included .mez file into your Power BI Custom Connectors folder and restart Power BI Desktop. |
3 |
Get Data → OdooIn Power BI, choose Get Data, search Odoo, and select the connector. |
![]() |
|
4 |
Enter URL & tokenPaste your Odoo URL and token. Optionally add a SQL query for a custom dataset. |
![]() |
|
5 |
Load & buildPick your tables, click Load, and start building dashboards. Refresh anytime for fresh data. |
![]() |
Frequently Asked Questions
Can I refresh dashboards automatically?
Yes. Publish your report to the Power BI Service and set a refresh schedule — it pulls the latest Odoo data automatically.
Does it expose custom models and fields?
Yes. Any standard or custom model in your database is available to browse, plus raw SQL for anything else.
Is there a limit on table size?
No hard limit. Batch pagination handles large datasets; throughput depends on your database and Power BI capacity.
Which Odoo hosting is supported?
Odoo.sh and On-Premise (Community & Enterprise). Odoo Online (SaaS) is not supported, since it does not allow custom modules.
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You 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. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.




Please log in to comment on this module