Forum Discussion
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
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.