Webkul Logo
Back to Top

User Guide for Odoo Power BI Connector

Updated 4 December 2025

Live Demo Buy Now

Introduction

Odoo Power BI Connector seamlessly integrates Odoo with Microsoft Power BI, enabling advanced data export and visualization for better decision-making.

Odoo Power BI Connector ensures top-tier security, safeguarding your data with reliable and encrypted handling during exports.

With support for multiple workspaces, table relationships, and dynamic dashboards, Odoo Power BI Connector empowers businesses to transform raw data into actionable growth strategies.

You can also check the newly released Odoo 19 migration to explore its latest functionalities.

NOTE: Odoo Power Bi Connector uses https://pypi.org/project/msal/ library. Therefore, You need to install this library for the proper functioning of the module.

Searching for an experienced
Odoo Company ? Find out More

Important Points: Odoo Power BI Connector

  1. For Odoo online(SAAS) users, You first need to install Odoo.sh tool before installing Odoo Power BI connector because Odoo restricts third-party software installations on Odoo online(SAAS).
  2. Power BI/Fabric capacity is required for our module. Since our module has been migrated to the latest Real-Time Intelligence (RTI) features.
  3. We utilize Fabric components like Eventhouse and KQL database. Therefore, the workspace must be assigned to a capacity.
  4. Please note that the dataset published from Odoo to Power BI and the semantic model in Power BI are closely linked—they essentially function as the same entity. Once a dataset is published from Odoo to Power BI, you cannot add or remove tables from it.
  5. If you need to change or reduce the number of tables, the dataset must first be unpublished. Upon republishing with changes, Power BI will treat it as a new semantic model. Even if two datasets have the same structure, Power BI treats them as independent semantic models. Therefore, it’s important to ensure all required tables are included before publishing.
  6. To Know More about capacity assignment kindly check the Documentation.

Features

  1. Odoo Power BI Connector seamlessly integrates Odoo with Power BI for streamlined data management.
  2. Create and export datasets with multiple tables for detailed reporting.
  3. Build table relationships to derive actionable insights.
  4. Apply filters to focus on specific data for accurate analysis.
  5. Automate data exports using cron jobs to ensure up-to-date reports.
  6. Ensure secure data handling with encrypted transfers to Power BI.
  7. Manage multiple Power BI workspaces for better organization.
  8. Build and publish Eventhouses and KQL databases for advanced analysis.
  9. Odoo Power BI Connector enables the creation of interactive dashboards for clear and actionable insights.
  10. Export dataset directly using secure web URL
  11. You can connect both Power BI Service and Desktop.

Check the video mentioned below for an overview of the workflow of this Connector:

Dm6LzZtJblE

Installation

  1. Once you purchase the App from the Webkul store, you will receive a link to download the module’s zip file.
  2. Extract the file on your system after the download finishes. As a result, you will be able to see a folder named- ‘power_bi_connector’
  3. Copy and paste this folder inside your Odoo Add-Ons path.
  4. Now, open Odoo App and click on the Settings menu. Here, click on Activate the Developer Mode.
  5. Then, open the Apps menu and click on ‘Update Modules List.’
  6. In the search bar, remove all the filters and search ‘power_bi_connector’
  7. You will be able to see the module in the search results. Click on ‘Install’ to install it.

Workflow

1. After installing Odoo Power BI Connector, log in to Odoo instance and go to Power BI Connector > Configuration > Connection.

connection in odoo power bi connector

2. Select the Access Method and After that, add the Credentials which include Power BI Username and Password.

power bi user credentials

3. Navigate to App credentials, here fill in Client ID, Tenant ID, Redirect URL, and Client Secret. you get all these from Azure Portal.

app credentials

4. Now click on the test connection. Connection Successful.

connection successful

5. In Workspace tab, you can see Workspaces, Datasets, and Tables.

Workspaces, Datasets, and Tables.

6. In Settings, Enable Microsoft Fabric

power bi fabric

7. Now Workspace, Eventhouse, KQL Database, and Tables tab are available.

Workspace, Eventhouse, KQL Database, and Tables

8. Once done, click on the Workspace tab. Go to the workspaces menu and create a Power BI workspace by adding workspace name and publishing it.

create a Power BI workspace

9. Now, create Eventhouses for each workspace. Click on the Workspace tab, go to Eventhouse menu, and create an Eventhouse.

create an Eventhouse.

10. Click on the Workspace tab and go to KQL Database menu, where you can create KQL Databases.

create KQL Database

11. Click on the Workspace tab and go to the Tables menu, where you can create Tables to store data in databases.

create Table in odoo power bi connector

12. Navigating to Publish, You can publish and validate the Power BI table.

publish and validate the Power BI table.

13. Now disable Power BI Fabric.

disable Power BI Fabric

14. Now you can see dataset instead of KQL Database.

dataset view instead of KQL

15. Create a new dataset by selecting workspace. Now set dataset type to Push.

push-dataset

16. Create a new table inside the dataset and publish the dataset.

create-table
publish dataset

17. Now you can export table data by opening the table and clicking on export.

export-table-data

18. You can also directly export dataset tables using the import option in Dataset type while creating the dataset.

directly-export-dataset

19. You can export a dataset using a web URL. Add tables to dataset, set Dataset Type to Import, and Web Auth Type to Web Token. Then click Generate Token to create the URL and token.

export-dataset-using-web-URL

20. Publish the dataset and copy the URL. Open Power BI Desktop or service and select data source as web. Click on connect to proceed further.

select-desktop-data-source

21. Enter the copied URL from the instance and paste it in the URL box. Click OK to load data

paste-URL
load-data-in-desktop

22. You can Import Reports and Dashboards from Configuration Tab.

Import Reports and Dashboards

23. In Power BI Reports tab, Open Dashboards menu.

Open Dashboards

24. Here you can see list of Power BI Dashboards.

list of Power BI Dashboards.

25. Here, you can see Power BI Dashboard of ‘demo dash’.

Power BI Dashboard of ‘demo dash’.

26. In Power BI Reports tab, Open Reports menu.

Open Reports menu.

27. Here you can see list of Power BI Reports.

list of Power BI Reports.

28. You can see an insightful Power BI Report.

insightful Power BI Report.

OTHER CONFIGURATION-RELATED VIDEOS

Data Import from Power BI to Odoo

Data Synchronization from Odoo to PowerBI

Connect your Odoo with Business Intelligence PowerBi!

Need Help?

Hope you find the guide helpful! Please feel free to share your feedback in the comments below.

If you still have any issues/queries regarding the same, please raise a ticket at the UV Desk.

I hope this helps. In case of any further queries, contact us at our support mail : support@webkul.com

Thanks for paying attention!!

Current Product Version - 3.2.0

Supported Framework Version - Odoo V19,Odoo V18,Odoo V17

business intelligence odoo odoo powerbi power bi integration powerbi
author-thumb
Sakshi 6 Badges

Sakshi is a proficient Odoo Business Analyst specializing in multichannel integration, connector platforms, and business intelligence tool integration with Odoo. She excels in optimizing business processes, ensuring seamless system integration, and enhancing data-driven decision-making, driving operational efficiency and strategic growth for businesses.

View More

. . .

Comments

Leave a Comment

Your email address will not be published. Required fields are marked*


10 comments

  • Joacim Raiml 3 months ago
    This PowerBi Connector works well. We had some issues before we got it to work but thanks to Webkul Team we now have a working PowerBi connection to Odoo!
    Reply
    • Sakshi (Moderator) 3 months ago
      Hello Joacim

      Thank you for your kind words! We’re delighted to hear that the Power BI Connector is now working smoothly for you.

      Our team at Webkul always strives to ensure seamless integration and support, and it’s great to know that we could help you get everything running perfectly.

      We truly appreciate your feedback and look forward to assisting you with any future needs!

      Best regards,
      WEBKUL-TEAM

      Reply
  • Milad Mealzo 10 months ago
    I hope you are doing well. I have a couple of questions regarding the Power BI Connector module in Odoo.

    How can I increase the size of the report displayed in this module? Is there an option to adjust the width and height, or can this be done through custom code?

    Additionally, how can we add the Power BI dashboard to the Odoo dashboard module? I would like to embed the report/dashboard directly within Odoo for easier access. Could you guide me on how to do that?

    Looking forward to your guidance.

    Reply
  • Niral Patel 11 months ago
    Request for Live Demo/Meeting for Odoo-Power BI Connector

    Connector Provider Team,

    I hope you are doing well.

    We are interested in understanding how your connector facilitates data transfer between Odoo and Power BI. Specifically, we would like to know:

    Odoo Version: 18

    How the connector works in real-world scenarios.
    The steps required to enable automatic data fetching from Odoo to Power BI.
    Any configuration, setup, or maintenance considerations.
    To clarify these aspects and address any additional queries, we would appreciate a live demo or a meeting with a concerned expert. Please let us know your availability for the same.

    Looking forward to your response.

    Reply
  • Ujjwal Kumar 2 years ago
    I hope this email finds you well.

    We are interested in connecting Odoo 16 to Power BI for our business analytics needs. Could you please arrange a demo to showcase the integration process and capabilities?

    Looking forward to your response.

    Reply
    • Sakshi. (Moderator) 2 years ago
      Hello Ujjwal,
      Greetings of the day
      Excuse us for the delayed response.
      We have created a ticket on your behalf. Please refer to the below link for further information.
      Ticket Link: https://webkul.uvdesk.com/en/customer/ticket/view/545556
      Thanks and regards
      Webkul-Odoo Team.
      Reply
  • NG 2 years ago
    Hi! I dont seem to be getting in because of this error “Connection error : AADSTS50126: Error validating credentials due to invalid username or password.” Im pretty sure im using the correct credentials, what could it be?
    Reply
  • Withoon C 2 years ago
    If have some issues about PowerBI Connect that I install in Odoo.
    When we run cron finsihed, It show data duplicated on power BI.

    Is Cron delete old data or have process replacement data ? Our company I user Odoo.sh

    Thanks.

    Reply
    • Sakshi Attri (Moderator) 2 years ago
      Hello there

      Greetings for the day!!

      I hope you are doing well.

      The already synchronized data should not be duplicated. You have created a ticket with us for this issue, and our team is assisting you on the ticket.

      Kindly refer to ticket 514753 for further details.

      I hope you understand.

      Thanks and Regards

      Reply
    • Back to Top

    Start a Project




      Message Sent!

      If you have more details or questions, you can reply to the received confirmation email.

      Back to Home

      User Guide for Odoo Power BI Connector