Hello All,
Has anyone use Power BI conconnected with oDoo DB? I have been downloading reports to feed PBI but it's a tedious task.
Help will be appreciated, Thanks.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Contabilidad
- Inventario
- PoS
- Proyectos
- MRP
Se marcó esta pregunta
1
Responder
2805
Vistas
Unless your goal is to use Power BI to visualize sql queries directly from the Odoo Postgres database, connecting directly to any ERP database is not advised. You may even consider Metabase, perhaps it’s better suited for that purpose.
Power BI works best with a star scheme data model. Using the Power Query editor to construct a data model is possible, but can get very complex very soon.
Best advise I can give you is to periodically backup your entire Odoo database and import that database into a staging database and create a data warehouse to connect PowerBI to. There are 3rd party apps to facilitate periodic backups. Basically you need to process a sql dump each time.
I am currently doing a pilot with Pentaho to do this. I would be happy to assist if you have any questions.
¿Le interesa esta conversación? ¡Participe en ella!
Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.
Registrarse| Publicaciones relacionadas | Respuestas | Vistas | Actividad | |
|---|---|---|---|---|
|
1
ago 24
|
2306 | ||
|
2
jun 24
|
2762 | ||
|
1
mar 23
|
4578 | ||
|
1
oct 20
|
4398 | ||
|
1
feb 20
|
7766 |
