Troubleshooting
What goes wrong with Power BI Connector for Odoo, how to recognise it, and what to do.
Power BI asks for credentials again and again
Choose Basic, not Anonymous, Windows or Organizational account. Username can be anything; the password is the token.
401 from the feed
The token is wrong, revoked, expired, or belongs to an archived user. Issue a new one - the old one cannot be read back.
The table picker is empty
Nothing is published, or nothing published is readable by the token's person. Check the Power BI tab on your reports, then check that person can open the report in Odoo.
One table is missing
It is unpublished, or the token's person cannot read its model. The feed answers the same way in both cases, deliberately, so check the report in Odoo.
The refresh brings back fewer rows than I see in Odoo
You and the token's person have different access. That is the module working. Look at Reads as on the token.
The refresh stops partway
Lower Rows per page on the report. A page large enough to time out is worse than two pages.
Dates come through as text
Check the column's field type in the report. $metadata maps real Odoo types to EDM types; a Char field holding a date arrives as text because that is what it is.
"This URL is not HTTPS"
Odoo is warning you at issue time. Fix web.base.url and terminate TLS at your proxy before using the token outside a private network.
Where do I look first?
The token list. If Last used never updates, Power BI is not reaching Odoo at all and the problem is the URL or the network, not the data.