Connect Power BI to Odoo database

Idrissshatila · ‎02-24-2023

Hello Everyone,

There's no Odoo connecter in Power BI connectors, can anyone refer any alternative to be able to connect Power BI to Odoo databse?

Thank you

Did I answer your question? Mark my post as a solution! Appreciate your Kudos

Follow me on LinkedIn

Vote for my Community Mobile App Idea

Proud to be a Super User!

monty · ‎03-03-2023

There are various options. First of all move to on-premises and access PostgreSQL directly. Other alternatives (disclaimer: I work there):

https://cloud.invantive.com/en/odoo/power-bi-connector

https://documentation.invantive.com/2017R2/odoo-data-model/webhelp/index.html

This might be an option too, but I have no working experience:

https://cdn.cdata.com/help/OEH/ado/default.htm

Please note that when you query multiple Odoo-databases in one go, the data models can be different in number of tables installed and version.

amitchandak · ‎02-24-2023

@Idrissshatila , refer this

https://community.powerbi.com/t5/Desktop/Connect-Power-BI-to-Odoo-and-Extract-Data/td-p/1247465

https://apps.odoo.com/apps/modules/15.0/odoo_powerbi_connect/

https://store.webkul.com/odoo-powerbi-connector.html

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!