$ 250.12
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 2533 |
| Technical Name |
eb_powerbi_integration |
| License | OPL-1 |
| Website | https://www.echobitzit.com |
| Versions | 16.0 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 2533 |
| Technical Name |
eb_powerbi_integration |
| License | OPL-1 |
| Website | https://www.echobitzit.com |
| Versions | 16.0 17.0 18.0 19.0 |
Power BI Integration
This module delivers a seamless integration between Odoo and
Microsoft Power BI, providing businesses with a powerful solution for
real-time analytics, reporting, and decision-making – all directly within Odoo.
It is designed to simplify business intelligence workflows by enabling direct access to Power BI features such as:
Workspaces,
Datasets,
Reports,
Dashboards,
Eventhouse,
KQL Databases, and
KQL Tables.
With this integration, organizations can embed Power BI reports and dashboards
directly inside Odoo, eliminating the need to switch between platforms. It ensures accurate and secure communication
with the Power BI API, supporting real-time synchronization of Odoo data with Power BI datasets.
The integration enables business users to visualize Reports and dashboards, track operational performance, and make data-driven decisions
without leaving their Odoo environment. Reports and dashboards can be customized, shared, and interacted with, all within
the Odoo interface – ensuring a single source of truth for business intelligence.
Whether you’re monitoring sales pipelines, financial performance, inventory health, or customer behavior, this connector
empowers your teams with interactive insights. By reducing manual data exports, automating updates, and centralizing analytics,
it enhances decision-making accuracy and operational efficiency while keeping your Power BI intelligence fully aligned with
Odoo workflows.
Screenshots
Open the 'PowerBI Integration' app, then click on the 'PowerBI Auth' menu, and finally click on the 'New' button.
In Microsoft Azure, click on 'App Registrations'.
Click on '+ New registration' or select an existing application.
Copy the 'Client ID' and 'Tenant ID'.
In Microsoft Azure, copy the 'Client ID' and 'Tenant ID', then paste them into the 'Client ID' and 'Tenant ID' fields in Odoo under 'Microsoft PowerBI Auth'.
Click on 'Client Credentials'.
Click on the 'New client secret' button.
Click on the "Settings" Submenu.Enter a description, then click on the 'Add' button.
Copy the 'Client Secret'.
Microsoft Azure, copy the 'Client Secret' and paste it into the 'Client Secret' field in Microsoft PowerBI Auth within Odoo. Then, click on the 'Generate PowerBI Refresh Token' button.
Click on 'Microsoft Account'.
Enter the 'Workspace Name' and then click the 'Create Workspace' button.
In Power BI, click on 'Workspaces' and then select the newly created workspace 'Test_Workspace_003'.
Click on the 'Tables' submenu.
Enter the 'Odoo Model Name' and then add a field in 'Fields Mapping'.
Click on the 'Datasets' submenu.
Enter the 'PowerBI Workspace ID', then add a 'Table', click the 'Create Table' button, and finally click the 'Export Table Data' button.
The dataset was successfully created in Power BI.
Open the 'Workspace' datasets, then click on the 'Explore' menu, and select the 'Create a blank report' submenu.
Create a report in Power BI.
Click the 'New item' button, and then select 'Dashboard'.
Click the 'Fetch Report' button, and then click the 'Fetch Dashboard' button. This will fetch all reports and dashboards from Power BI into Odoo.
All Power BI reports are fetched into Odoo.
All Power BI Dashboard are fetched into Odoo.
Click on the 'Embedded Report & Dashboard' menu, select the report, and then click the 'Get Report' button.
Click the 'Fetch Report' button, and then click the 'Fetch Dashboard' button. This will fetch all reports and dashboards from Power BI into Odoo.The Power BI report is successfully displayed in Odoo.
The second Power BI report has been successfully displayed in Odoo.
Click on the 'Eventhouse' submenu.
Enter the 'PowerBI Workspace ID', and then click the 'Create Eventhouse' button.
Create an Eventhouse, then go to the Workspace, and click the 'Fetch KQL Databases' button.
The KQL Database has been successfully synced in Odoo.
In the 'KQL Table' form view, add a 'Table', then enter the 'PowerBI KQL Database ID', click the 'Create KQL Table' button, and finally click the 'Export Table Data' button.
All Dashboards, Reports, Datasets, Eventhouses, and KQL Databases are successfully visible in the dashboard.
📦 Version 1.0.0 – Initial Release
- First stable release of Power BI Integration for Odoo 16, 17, 18 and 19.
- Secure authentication and connection to Microsoft Power BI service.
- Support for Workspaces, Datasets, Reports, and Dashboards.
- Embed Power BI reports and dashboards directly inside Odoo views.
- Real-time synchronization of Odoo data with Power BI datasets.
- Support for advanced features:
- Eventhouse for event-driven data ingestion
- KQL Databases integration
- KQL Tables for advanced queries
- Dynamic filters and slicers applied within Odoo
- Automatic refresh of embedded dashboards with live Odoo data.
- Manual and scheduled dataset refresh options.
- Clean, responsive UI with easy setup and configuration.
Demo & Support
We're here to help! Whether you need assistance with Odoo app installation, customization, or have any technical or functional questions, our support team is just a call or click away. Choose your preferred method to connect with us - phone, email, or schedule a meeting. You can also explore our detailed video playlist for step-by-step guidance.
Need Odoo Support?
Power BI Integration FAQS
Yes, the integration supports both Community and Enterprise editions of Odoo, including Odoo.sh and On-Premise.
Yes, you need an active Microsoft Power BI account with appropriate API access permissions.
Yes, the integration allows seamless embedding of Power BI reports and dashboards within Odoo forms, menus, and dashboards.
Yes, you can sync Odoo data models with Power BI datasets in real-time or through scheduled updates.
The connector supports Workspaces, Datasets, Reports, Dashboards, Eventhouse, KQL Databases, and KQL Tables.
Yes, the connector uses Microsoft’s secure Power BI REST APIs and Odoo’s access control mechanisms for safe data transfer.
Yes, lifetime-free updates are provided for the same version of the module you purchased.
Yes, we offer free technical support for 365 days after purchase. Contact us at info@echobitzit.com.
Free Support for 365 Days
We believe that great apps deserve great support. That's why every purchase of our Odoo apps comes with 365 days of free expert support-no hidden fees, no hassle. Whether you need help with installation, customization, or troubleshooting, our team is here to guide you every step of the way. We're committed to ensuring your Odoo experience is smooth, efficient, and worry-free. With fast response times and professional assistance, you can focus on growing your business while we handle the tech. Start strong with support you can count on-for free, for the first 365 days.
Demo & Video
Schedule Meeting for Any Query
Watch Video Playlist
Our Services
Odoo Integration
Seamlessly integrate Odoo with third-party apps, platforms, and tools for better workflow.
Odoo Implementation
We plan, configure, and deploy Odoo tailored to your business processes.
Customization
Get modules and workflows customized to meet your exact needs in Odoo.
Community Apps
Access or develop robust community apps to enhance your Odoo functionality.
Development Outsourcing
Hire dedicated Odoo developers to build solutions efficiently and cost-effectively.
Support & Maintenance
Enjoy peace of mind with our reliable support, updates, and bug fixing services.
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