Loading page
Power BI Connector for Odoo
by TechnoVision · Odoo App
Get Data, OData feed, paste, done.
Power BI Desktop has an OData connector built in. Point it at this feed and you get a table picker, typed columns, paging and scheduled refresh - with no custom connector to install and no Power Query to write.
One-off licence per Odoo instance. The store bills in its own base currency, so checkout may differ by a few cents.
- Odoo 18
- Community & Enterprise
- Requires Advanced Report Builder
- Version 18.0.1.0.1 · 2026-09-07
Security Center
Live82
Score
1.2k
Events / 24h
3
Alerts
Export volume · 14 days
Unusual export detected
res.partner · 4,812 rows · outside business hours
Illustrative UI. Product screenshots to be dropped into this frame.
What it does
The thing every other connector gets wrong
A token reads as a person
Every other Odoo-to-BI connector authenticates with an administrator’s API key, which is why the refreshed dataset contains rows the person who built it was never allowed to see.
Your reports are the tables
A report already says which model, which filter, which columns and in what order. So the dashboard and the Monday email cannot disagree about what Overdue invoices means.
Column names you chose
The field list reads Customer and Amount due rather than partner_id and amount_residual.
Proper OData, not a JSON URL
Service document, $metadata with real EDM types, and $top/$skip paging with @odata.nextLink so a large table arrives complete.
Credentials handled properly
HTTP Basic, because that is what Power BI offers and what its scheduled refresh can store. Never a key in a query string, which would end up in browser history and proxy logs.
Publishing is off by default
Per report. Exposing every saved report the moment somebody installs a module is a decision made by the wrong person.
Screenshots
Product gallery
3 captures of the shipped product: the whole set-up, publishing a report, tokens.
The whole set-up
Publishing a report
Tokens
How it works
Installed in minutes, useful the same day
- 1
Publish a report
Tick one box on a report you have already built, and give the table a name.
- 2
Issue a token
Odoo shows the feed URL, the token and the exact Power BI steps - and warns you if your base URL is not HTTPS.
- 3
Get Data, OData feed
Paste the URL, choose Basic, token as the password. Tick the tables you want.
- 4
Refresh on a schedule
Enter the same credentials in the Power BI Service. Revoking the token stops the next refresh.
FAQ
Questions we get asked
No. Power BI Desktop has an OData connector built in. Get Data, then OData feed.
They can, and they should not. Every row would be read with one person’s rights. Issue one per person, or decide deliberately whose view a shared dashboard should show.
$filter and $orderby are not implemented. The report’s own filter and sort are the ones that were reviewed and shared; letting a dashboard widen them would defeat the point. Filter in Power BI, or edit the report.
No. The feed is read-only and there is nothing behind it that could write.
The Apps Store prices a module together with what it requires. This one needs Advanced Report Builder, so the listing shows $128 - $69 for the connector plus $59 for the report builder. If you already own the report builder you are not charged for it twice.
Get Power BI Connector for Odoo
Install from Odoo Apps, or talk to us about a guided rollout across multiple companies.