Installation
What Power BI Connector for Odoo requires, how to install it, and how to check the install worked.
Requirements
- Odoo 18.0, Community or Enterprise
- Advanced Report Builder (technovision_report_builder)
- Odoo reachable over HTTPS from Power BI
Install
- Put technovision_powerbi in your addons path alongside the Report Builder.
- Update the apps list and install Power BI Connector for Odoo.
Odoo registers three routes under /powerbi/odata and adds a Power BI menu under Reports.
What installing it does not do
No report is published and no token exists. A fresh install answers 401 to everything, and the table list would be empty even with a valid token.
Serve it over HTTPS
Power BI sends the token as HTTP Basic on every refresh. Over plain HTTP that is readable by anything in between. Set web.base.url to the public HTTPS address - the connection instructions are generated from it, and Odoo warns you at issue time if it is not HTTPS.
Upgrading
Standard Odoo upgrade. Tokens, published flags and table names are preserved.
Uninstalling
Removes the routes and the tokens. Datasets already refreshed in Power BI keep their data; they simply stop refreshing.