Odoo Power Bi Connector
Odoo Power BI Connector links Odoo with Microsoft Power BI. It supports Power BI integration with Odoo and helps you create reports from your ERP data.
- Easily connect Odoo to Power BI without hassle.
- Connect both Power BI service and desktop.
- Export datasets directly using a web URL.
- Export multiple tables to Power BI for better analysis.
- Link tables to get deeper insights from your data.
- Apply filters to sort and refine data for clear reports.
- Schedule automatic data exports to save time.
- Keep your data safe with secure encryption.
- Create interactive dashboards for real-time updates.
- Description
- Reviews
- FAQ
- Customers ()
- Specifications
- Cloud Hosting
- Changelog
Odoo Power BI Connector connects Odoo ERP with Microsoft Power BI. It supports ERP Power BI integration.
This gives you stronger reporting and analytics tools. You can sync data and build dashboards. The module improves data visualization for ERP models.
It also provides stable Power BI ERP integration. Your data stays accurate between Odoo and Power BI and dashboard is simple and easy to use.

Why do we need Odoo Power BI Connector?
Odoo manages daily operations. Power BI helps you understand that data better.
With Power BI integration with Odoo, you can move beyond basic ERP reports. Through ERP Power BI integration, you can track sales, inventory, finance, and customer data in one place.
Dashboards help teams review performance quickly.
Prerequisites for Using Odoo Power BI Connector
If you use Odoo Online (SaaS), you must migrate to Odoo.sh first as Odoo Online does not allow direct third-party software installations.
Highlighted Features of Odoo Power BI Connector
Easily Connect Custom Models
Sync data from both standard and custom Odoo models as part of your Power BI ERP integration strategy.
Smart Filters for Reports
Create live dashboards to track sales, inventory, and finances, improving overall data visualization for ERP reporting.
Interactive Dashboards
Create live dashboards to track sales, inventory, and finances, improving overall data visualization for ERP reporting.
Automatic Data Export
Schedule exports to keep your Power BI reports up to date automatically.
Supports KQL and Eventhouse
Connect with Microsoft Fabric’s Eventhouse and KQL databases for better data handling.
Choose What to Sync
Pick only the data you need to keep your system clean and organized.
Link Data Tables
Easily connect tables to make data analysis smoother.
Work with Multiple Workspaces
Manage and analyze data across different Power BI workspaces.
Secure Data Transfers
Protect your data with token-based authentication for KQL databases.
Access Power BI Data
View and manage Power BI database details directly from Odoo.
Connect to Power BI service and desktop
You can now connect with both Power BI Service and Desktop
Directly import datasets
Bring your datasets into Power BI instantly using a web link.
Multi-Workspace Support
Odoo Power BI supports multiple Power BI workspaces. It improves reporting within your ERP Power BI integration setup.
- The module supports many workspaces.
- User can also import workspaces from Power BI to Odoo.
- Odoo Power BI Manages online orders for global reach.
- User can also create workspaces in Odoo and export them.

Filters for Precise Data
This Module provides filters that differentiate data from tables, such as filtering products by various options.
- Users can use filters to distinguish data from tables.
- Moreover, you can export datasets to Power BI.
- Users can create datasets that contain one or more tables.
- For example, filter products by group, country, or other criteria based on the model fields.

Create and Manage KQL Databases
Easily set up and managed KQL databases in Power BI for advanced analysis as part of a reliable Power BI ERP integration framework.
- User can create and organize KQL databases
- Publish KQL database tables to Power BI
- Ensure secure transfers with token-based authentication
- User can optimize query speed for faster data retrieval

Create Tables and Datasets
With the Odoo Power BI Connector, you can easily create, manage, and sync your data tables with Power BI to support efficient data visualization for ERP reporting
- Make clear and organized tables and datasets to keep your data neat
- Send your data straight to Power BI for quick and easy analysis
- Keep your tables updated even after syncing with Power BI
- Import datasets into Power BI using a simple web link

Maintain Table Relationship
Build simple and useful data models by connecting related tables in Odoo and Power BI to strengthen Power BI integration with Odoo reporting accuracy.
- Easily link tables to understand your data better
- Use many-to-one links to match how your business works
- Keep table and dataset connections correct for accurate reports
- Send data to Power BI with automatic links for easy reporting

Track data from the dashboard
Odoo Power BI Connector supports Power BI-generated reports and dashboards within a structured ERP Power BI integration environment.
- Import reports and dashboards from Powerbi.
- Odoo allows you to visualize these reports and dashboards.
- Visualise PowerBi reports and dashboards from Odoo.
- The reports offer a unique outlook.

Support
For any query or issue please create a support ticket here CREATE A TICKET HERE
You may also check our other top-quality Odoo Modules.
Specifications
Frequently Asked Questions
Move to Cloud Today
AWS Free tier hosting for one year by amazon web services, for more details please visit AWS Free Tier.
GCP Free tier hosting for one year with 300 credit points by google cloud platform, for more details please visit GCP Free Tier.
Azure free tier hosting for one year with 25+ always free services, for more details please visit Azure Free Tier.
In our default configuration we will provide tremendous configuration for your eCommerce Website which is fast to load and response.
Default Configuration Details of Server
- 1 GB RAM
- 1 Core Processor
- 30 GB Hard Disk
- DB with 1 GB RAM and 1 Core Processor
* Server Configuration may vary as per application requirements.
Want to know more how exactly we are going to power up your eCommerce Website with Cloud to fasten up your store. Please visit the Cloudkul Services.
Get Started with CloudModule Released in Version 1.0.0:
- 1 -> [Features] Import workspaces from Power BI to Odoo and create workspaces in Odoo for export.
- 2 -> [Features] Create datasets with one or more tables. Also, export datasets to Power BI.
- 3 -> [Features] Export data from any Odoo model by creating tables and schedule data export using cron.
- 4 -> [Features] Create dynamic server actions for any model from datasets, facilitating data export to Power BI.
- 5 -> [Features] Import reports and dashboards from Power BI to Odoo.
- 6 -> [Features] Visualize reports and dashboards directly in Odoo.
- 7 -> [Features] Define filters to differentiate data from tables based on selected model fields.
Version 2.0.0 Newly Added Features:
- 1 -> [Features]Display tabs on the dashboard showing the number of total, published, and unpublish records. Clicking on these tabs redirects to specific records.
- 2 -> [Features]Ability to unpublish Power BI datasets either from Odoo or Power BI end.
- 3 -> [Features]Introduce a responsible user feature in Power BI Workspace, granting access levels to related records based on user roles.
- 4 -> [Features] Once a connection is established, make all credential fields read-only. Added a reset_connection button to disconnect the connection and make fields editable again.
- 5 -> [Features] Add or delete server actions in Power BI Table, visible when the related dataset is published.
- 6 -> [Features] Add server action option is only visible when a server action is not created, while the delete server action button is visible when a server action is added.
Version 6.1.0 Newly Added Features:
- 1 -> [Features] added last sync date feature When exporting it'll check the last sync and will export only those changes that has been done after the last sync,
- 2 -> [REMOVE] Report and dashboard wizard
- 3 -> [REMOVE] Remove Report and Dashboard wizard
Version 6.2.1 Newly Added Features:
- 1 -> [Features] Table count in dataser and report,dashboard count in workspace.
- 2 -> [Features] Table Relation
- 3 -> [FIX] fix memory issue during data export
- 4 -> [FIX] Reseting last sync date on data deletion
- 5 -> [Features] provide option to use relation or not in table.
Version 6.2.2 Newly Added Features:
- 1 -> [Fix] data export issue, memory limit
- 2 -> [Features] adding table relation feature per table
- 3 -> [Fix] default param issue
- 4 -> [Features] hide access method from view.