| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 854 |
| Technical Name |
powerbi_odoo |
| License | OPL-1 |
| Website | https://ksrolabs.com/ |
| Versions | 16.0 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 854 |
| Technical Name |
powerbi_odoo |
| License | OPL-1 |
| Website | https://ksrolabs.com/ |
| Versions | 16.0 17.0 18.0 19.0 |
Effortlessly Connect Odoo - Power BI
No Manual Uploads. No Tokens. Full Automation.
Push, Sync, and Automate — connect Odoo directly with Microsoft Power BI using a secure Azure Service Principal. No reauthentication. No manual dataset updates. Manage your workspace, datasets, and data refresh cycles directly from Odoo.
Launch Offer: 30% OFF
To celebrate the launch of our Odoo - Power BI Connector, we're offering an exclusive 30% discount for early adopters.
Limited-time deal — don't miss it!
Why Use an Azure Service Principal?
Unlike user-based authentication, the Service Principal method is secure, automated, and designed for enterprise-grade reporting pipelines. No more manual tokens. No dependency on a Power BI user's login session.
Enterprise Authentication: Connect Odoo directly to Power BI using client ID, tenant ID, and client secret.
Never Reauthenticate: Once configured, Odoo maintains a permanent, secure connection.
Centralized BI Control: Manage Power BI workspaces, datasets, and pushes right from Odoo.
Automated Refresh: Push updated data anytime — or on scheduled cron jobs.
Powerful Features
Direct Export to Power BI: Push Odoo model data directly into Power BI datasets.
Workspace Management: Create and manage Power BI workspaces from within Odoo.
Field Mapping: Choose exactly which Odoo fields are sent to each dataset.
Auto Dataset Creation: Automatically build datasets inside Power BI with a single click.
Real-Time Data Push: Instantly refresh your BI dashboards with updated Odoo data.
Scheduled Updates: Integrate with Odoo cron to automate periodic data refreshes.
How It Works
1) Add your Azure Service Principal credentials in Odoo.
Enter Tenant ID, Client ID, Client Secret, and Power BI User Email.
2) Create or link a Power BI Workspace.
Odoo can automatically create workspaces.
3) Configure your export mapping: choose a model and fields.
4) Power BI instantly displays your dataset.
5) Build stunning dashboards using your live Odoo data.
Zero Friction. Total BI Power.
This isn’t just a connector — it’s your Power BI automation engine. No more downloading files, importing CSVs, or refreshing datasets manually. Control everything directly from Odoo — fast, secure, and perfectly integrated.
Connect once. Automate forever.
Compatibility
Odoo Versions: 16.0, 17.0, 18.0 & 19.0 (Community + Enterprise)
APIs Used: Microsoft Power BI REST API
Authentication: Azure AD Service Principal (Client ID + Secret + Tenant)
Data Push Type: Streaming + Push Datasets
Supported Models: Any readable Odoo model
FAQs
Q: Can I push multiple datasets?
Yes — create multiple export configurations, each pushing into its own dataset.
Q: Dataset not showing in Power BI?
Ensure your Service Principal has workspace access and proper API permissions.
Q: Is the data secure?
Yes — data flows directly from Odoo to Microsoft’s official Power BI endpoints.
Q: Can I automate daily refreshes?
Absolutely — use Odoo cron jobs to push updated data on any schedule.
Contact Us
Email: ksrolabs.info@gmail.com
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