Odoo-Power BI

The limitation is probably coming from the Odoo connector rather than Power BI. Many free Odoo connectors expose Odoo models/tables through the API but don't expose PostgreSQL views directly.

If you have access to Odoo development, one option is to expose the required database view as a read-only Odoo model using _auto = False. The connector can then expose that model to Power BI like a normal Odoo model.

Alternatively, if you have database access, Power BI can connect directly to PostgreSQL and query the view, preferably through a read replica/reporting database rather than the production Odoo database.

Hi consultorbi​,

I think the key distinction here is between a PostgreSQL SQL view and an Odoo model.

If the connector is accessing Odoo through its API/ORM layer, it will normally discover Odoo models and their fields rather than every VIEW object that exists directly in PostgreSQL. Odoo's external API documentation describes access in terms of models, fields and methods.

So if you need Power BI to consume a specific SQL view through Odoo, a more Odoo-native approach is to expose that view as a read-only model using _auto = False. Odoo documents this pattern for models backed by SQL views.

Conceptually, that would be:

PostgreSQL SQL view → Odoo model (_auto=False) → connector/API → Power BI

You would then need to confirm whether the free connector you are using also exposes custom Odoo models, because that part is connector-specific.

The other option is to connect directly to PostgreSQL. Power BI's native PostgreSQL connector can work with tables and views, but I would only use that route if your Odoo deployment allows direct database access. It also bypasses the Odoo ORM/security layer, so ideally this would use a read-only account and, where possible, a reporting replica rather than the production database.

It would also help to know which free connector you are using and whether your Odoo environment is Odoo Online, Odoo.sh, or self-hosted, because the available options differ quite a bit between those deployment models.

AI-assisted drafting: AI was used to help structure and phrase this response. I reviewed and validated the technical content before posting.