Forum Discussion

Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
3 years ago

Connect Power BI to Odoo database

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
Need Help
monty's avatar
monty
Icon for Advocate II rankAdvocate II
3 years ago

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.