Kaizen — Odoo - Microsoft Power BI & Fabric Connector
by Kaizen Principles http://www.kaizenae.com/$ 338.99
Availability |
Odoo Online
Odoo.sh
On Premise
|
Odoo Apps Dependencies |
Discuss (mail)
|
Lines of code | 3696 |
Technical Name |
kaz_odoo_powerbi_connect |
License | OPL-1 |
Website | http://www.kaizenae.com/ |
Availability |
Odoo Online
Odoo.sh
On Premise
|
Odoo Apps Dependencies |
Discuss (mail)
|
Lines of code | 3696 |
Technical Name |
kaz_odoo_powerbi_connect |
License | OPL-1 |
Website | http://www.kaizenae.com/ |
Microsoft Power BI & Fabric Connector
for Odoo
Bring live analytics into Odoo with a secure, end-to-end connector for Microsoft Power BI and Fabric. Publish Workspaces, Datasets/Tables (or Eventhouse/KQL Databases in Fabric), push Odoo records on-demand or via scheduled cron, and embed interactive Reports & Dashboards directly inside Odoo. Includes relationship validation, incremental sync (last-sync window), role-based security, and a visual Connector Dashboard for quick status and actions.
© 2025 Kaizen Principles

What's New in Microsoft Power BI & Fabric Connector for Odoo

One active, governed Power BI/Fabric connection per database

Publish Workspaces, Datasets, Tables; Eventhouse & KQL DB (Fabric)

Incremental export with last sync datetime + cron automation

Embed Power BI Reports & Dashboards inside Odoo via Embed Tokens
Kaizen Principles
Your Partner
We're here to support your growth 24/7. Connect with our experts now.

All Features

Odoo Power BI Connector seamlessly integrates Odoo with Power BI for streamlined data management

Create and export datasets with multiple tables for detailed reporting.

Build table relationships to derive actionable insights

Automate data exports using cron jobs to ensure up-to-date reports

Ensure secure data handling with encrypted transfers to Power BI

Manage multiple Power BI workspaces for better organization

Odoo Power BI Connector enables the creation of interactive dashboards for clear and actionable insights.
Kaizen's Top App Recommendations
Take a look at our other Odoo apps designed to make your life easier with a smooth workflow. Don't miss the chance to uplift your Odoo ERP experience with our apps!
More Apps »
POS Tamara
Pay point of sale orders with tamara payment gateway and refund orders paid with tamara....
Learn More »
UAE Corporate Tax
Get Complete State-specific legislation view of Company income taxes Generate / redraft related journals at any time during the year...
Learn More »
Stock Report PDF
PDF report to print inventory transactions using different fillters...
Learn More »
Payment Provider: Tamara
Integration With Tamara Payment Gateway (E-commerce and Point of Sale)...
Learn More »Free 30 Days Support
Kazien Principles will provide FREE 30 days support for any doubt, queries, and bug fixing (excluding data recovery) or any type of issues related to this module. This is applicable from the date of purchase.

Microsoft Power BI & Fabric Connector
Unlock real-time business intelligence inside Odooâpublish curated datasets and tables to Microsoft Power BI or Fabric with a click, then embed interactive reports and dashboards directly where teams work. From sales, inventory, and finance KPIs to ad-hoc operational views, exports are incremental and automated via cron, relationships are validated for reliable models, and schema updates are handled safely. No more CSV shuffles or manual refreshesâyour Odoo records flow continuously to BI. Every publish, sync, and embed action is recorded in chatter for full auditability, while role-based security and a single governed connection keep access tight. Whether youâre standardizing executive dashboards, accelerating month-end analytics, or giving departments self-serve insights, this connector centralizes your data pipeline, reduces overhead, and turns Odoo into a live analytics hub.

Connect to Power BI

Create a secured connection using your Azure app (Client ID/Secret, Tenant, Redirect URI). Choose Master User or Service Principal, test the link, and activate a single governed instance for the database.
Enter Power BI Credentials

Provide your Master User or Service Principal details, set Tenant/Client IDs, and click Test Connection to verify access before enabling sync.
Connection Failed

We couldnât authenticate with Power BI. Check username/password (or app secret), Tenant ID, API permissions/consent, and the Redirect URIâthen click Test Connection again.
Update Power BI Credentials

Edit the account username or enable Update Password to rotate the secret for this connection. Save the changes, then re-run Test Connection to validate access.
Schedule BI Exports

Configure the cron to push new/changed Odoo records to Power BI/Fabric at regular intervals. Uses the last sync time for incremental loadsârun manually anytime to trigger an immediate export.
Enable Microsoft Fabric Mode

Turn on Fabric items in Odooâunlock Eventhouse and KQL Database menus, Fabric-aware tables, and related rules. Click Save to apply; requires proper Fabric permissions/capacity.
Manage Workspaces

Create or import Power BI workspaces, assign responsible users, and set a default workspace. From here youâll organize datasets and tables for publishing and exports.
Publish Workspace

Review name, responsible users, and default flag, then click Publish to create this workspace in Power BI. After publishing, start adding datasets, reports, and dashboards.
Create a Dataset

Define a dataset for your workspace, then add tables and relationships. Publish it to Power BI to start exporting Odoo data and building reports.
Publish Dataset

Review the dataset and its workspace, add required tables, then click Publish to create the dataset in Power BI. After publishing, you can export data and build reports.
Add Tables to Dataset

Create tables from Odoo models, choose fields, and (optionally) enable relationships. Save to prepare the dataset for publishing, schema updates, and exports.
Define Table Columns & Preview Export

Choose fields, enable relationships, and set filters. Use Preview Export to see record counts and sample IDs before publishing or turning on cron-based sync.
Import & Manage Dashboards

Pull dashboards from a selected Power BI workspace and list them here. Open any record to embed it in Odoo with a secure token for instant, in-app insights.
Import & Manage Reports

Retrieve reports from a Power BI workspace and list them here. Open any report to render it inside Odoo with a secure embed token for real-time analysis.
Connector Dashboard Overview

See totals and publish/unpublish counts for Workspaces, Datasets, Tables, Reports, and Dashboards. Use the mini-trend bars to spot weekly activity and click any tile to drill down or take actions.
Why Kaizen
You know us as the makers of the Odoo "Microsoft Power BI & Fabric Connector for Odoo".
Kaizen's Top App Recommendations
Take a look at our other Odoo apps designed to make your life easier with a smooth workflow. Don't miss the chance to uplift your Odoo ERP experience with our apps!
More Apps »
POS Tamara
Pay point of sale orders with tamara payment gateway and refund orders paid with tamara....
Learn More »
UAE Corporate Tax
Get Complete State-specific legislation view of Company income taxes Generate / redraft related journals at any time during the year...
Learn More »
Stock Report PDF
PDF report to print inventory transactions using different fillters...
Learn More »
Payment Provider: Tamara
Integration With Tamara Payment Gateway (E-commerce and Point of Sale)...
Learn More »Kaizen Odoo Services
Upscale your business with expert services from an Odoo Gold Partner.

Module Development

Implementation

Customization

Integration

Migration

Support & Maintenance

Consulting
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