Power BI Connector (OData Feed)
Publish any Odoo table, standard or custom, as a read-only OData v4 feed at /odata/v4/ that Power BI Desktop's built-in Get Data > OData feed connector understands out of the box. Access is protected by scoped, per-user API keys with an optional expiry, and every read runs with that user's access rights, never as admin. Pick the tables, pick the columns, filter the rows, and let the typed $metadata schema deliver real dates, decimals and integers straight into your reports.
What this module does
No gateway, no custom connector, no CSV exports. Expose exactly the tables your report needs, generate a connection key, and Power BI reads live Odoo data through a standards-compliant OData v4 endpoint. Refresh in Power BI Desktop and scheduled refresh after publishing to the Power BI Service both work with the same Basic credentials (Odoo login plus API key).
How it works
From a fresh install to a refreshing Power BI report in minutes. Here is the whole flow, including how to connect from Power BI Desktop.
- Install the module and expose your tables. Open Power BI > Exposed Tables, pick any model (standard or custom), click Populate Columns to load sensible defaults, untick what you don't need, and add an optional Record Filter to keep the dataset small and refreshes fast.
- Review the data model. Open Power BI > Data Model to see how the exposed tables link together (keys and N:1 relations), and note the relationships you will recreate later in Power BI's Model view.
- Generate a connection key. Run Power BI > Generate Connection Key, choose the data user (a dedicated read-only reporting user is recommended, since their access rights apply to everything Power BI reads), optionally set an expiry, and copy the key: it is shown only once, together with the feed URL.
- Connect from Power BI Desktop. Use Get Data > OData feed with the URL https://<your-odoo-host>/odata/v4/ and Basic authentication: user name is the data user's Odoo login, password is the connection key. Tick the tables you need in the Navigator and Load; the types come through correctly from the OData schema.
- Refresh and publish. Refresh in Power BI Desktop re-fetches from Odoo with no extra setup. After publishing to the Power BI Service, re-enter the same Basic credentials in the dataset's data source settings and scheduled refresh works from the cloud.
| Connector | Get Data > OData feed |
| URL | https://<your-odoo-host>/odata/v4/ (the key wizard shows the exact URL) |
| Authentication | Basic (not Anonymous, not Organizational account) |
| User name | the data user's Odoo login |
| Password | the connection key from the wizard (not the user's Odoo password) |
Screenshots
Helping businesses work smarter with tailored Odoo solutions. We deliver custom modules, integrations, and workflow improvements designed for your needs.
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 743 |
| Technical Name |
mindscript_powerbi_connector |
| License | OPL-1 |
| Website | https://www.mindscriptech.com/ |
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module