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
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
1
Reply
1866
Views
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.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
1
Aug 24
|
145 | ||
|
2
Jun 24
|
327 | ||
|
1
Mar 23
|
1805 | ||
|
1
Oct 20
|
2400 | ||
|
1
Feb 20
|
5509 |
