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:
- Müşteri İlişkileri Yönetimi
- e-Commerce
- Muhasebe
- Envanter
- PoS
- Proje Yönetimi
- MRP
Bu soru işaretlendi
1
Cevapla
2820
Görünümler
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!
Üye Ol| İlgili Gönderiler | Cevaplar | Görünümler | Aktivite | |
|---|---|---|---|---|
|
1
Ağu 24
|
2318 | ||
|
2
Haz 24
|
2768 | ||
|
1
Mar 23
|
4590 | ||
|
1
Eki 20
|
4405 | ||
|
1
Şub 20
|
7775 |
