Add a Power BI and SQL connector for Odoo as described on External API — Odoo 15.0 documentation.
Be aware that there are several versions of Odoo, older ones do not have the API enabled on the shelve.
Also APIs may suffer issues when the volume of data exceed some amount. Then a sync strategy is required like Invantive’s one with
We have a self-modified Odoo11 version.
We use a direct
PostGres connection with a secured-by-restricted-IP port.
Then using the Invantive’s PostGres connector and [tables-replication-automation-with-stored-procedure-giving-statistics-error-handling-by-email] works like a charm.
Thanks for your additions. In the past we have also used direct database connection, but it seems that this one is sometimes not available.