Configuration
Every setting in Power BI Connector for Odoo, and what each one changes.
1. Publish a report
Open any report in Reports > Reports, go to the Power BI tab, and tick Publish to Power BI.
| Field | What it does |
|---|---|
| Publish to Power BI | Off by default, and per report |
| Table name | What Power BI shows. Derived from the report name; editable when two would collide |
| Rows per page | How many rows one OData page carries. Power BI follows the next-page link until the feed stops, so this is a page size, not a ceiling |
A table name must be an identifier: letters, digits and underscores, not starting with a digit. Two reports cannot share one.
Publishing changes nothing about who can read what. Each token still returns its own person's rows.
2. Issue a token
Reports > Power BI > Connect Power BI
| Field | What it means |
|---|---|
| What is it for | A name you will recognise when revoking |
| Reads as | The person whose access rights every row is read with |
| Expiry | Optional and recommended |
Press Issue token. The feed URL and the token are shown once, with the exact Power BI steps. Copy them now: the token is stored only as a digest.
The wizard refuses to issue a token if nothing is published, because the feed would show an empty table list and you would spend twenty minutes wondering why.
3. Connect Power BI
- Get Data > OData feed
- URL: https://your-odoo.example.com/powerbi/odata
- Sign in with Basic
- Username: anything - it is ignored. Password: the token
- Tick the tables you want
For scheduled refresh in the Power BI Service, enter the same Basic credentials in the dataset's data source settings.
Revoking
Reports > Power BI > Tokens, then Revoke. It stops the next refresh; it does not delete anything already in Power BI.
Column names
The properties Power BI sees are the labels on the report's columns, not the technical field names. Amount due rather than amount_residual. Set good labels once and every dashboard built on them reads properly.