Connect Power BI to Odoo database

[Idrissshatila]

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

[monty]

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]

@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