FAQ
The questions asked most often about Power BI Connector for Odoo, answered.
Do I need a custom Power BI connector?
No. Power BI Desktop has an OData connector built in. Get Data > OData feed.
Which Power BI do I need?
Desktop to build, and the Service if you want scheduled refresh. Both use the same Basic credentials.
Can two people share one token?
They can, and they should not. Every row would be read with one person's rights. Issue one token per person, or decide deliberately whose view a shared dashboard should show.
Why can I not filter in the URL?
$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.
Why is my table empty?
Either the report returns no rows for the token's person, or the report is not published. Check both - and remember the two can differ from what you see.
Can it write back to Odoo?
No. The feed is read-only and there is nothing behind it that could write.
How large a table can it serve?
As many rows as the report's own limit allows, paged. Set Rows per page to something your server answers comfortably; Power BI will follow the pages.
What does the store price mean?
The Odoo Apps Store prices a module together with what it requires, so this listing shows the connector plus the Advanced Report Builder it depends on.
Does it work with Excel or Tableau?
Anything that speaks OData v4 with Basic auth can read the feed. Power BI is what it is tuned and tested for.
Where do I see who has been refreshing?
Reports > Power BI > Tokens - last used, refresh count and last address.