Hi all,
does anybody know if it is possible to connect Power BI to odoo.sh ?
Cheers,
Dominique
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
3
Replies
15784
Views
I've made a Power BI connector that's free and doesn't require access to PostgreSQL.
Check it out https://github.com/tmijail/Odoo-Power-BI-Connector/
Hi Dominique,
It is not possible. In order to be able to connect PowerBI to Odoo you will need to create a direct connection to the database. As the postgreSQL on Odoo.sh does not allow remote connections and you cannot configure the postgreSQL configuration file you won't be able to connect.
You could alternatively export data to CSV's and import those in PowerBI or you could create a Python script that downloads/parses the Odoo data (through XML-RPC) to use it later on in PowerBI.
Regards,
Yenthe
thanks for the clarification
Yenthe, is it possible to connect Power BI to an Odoo On Premise setup?
Thanks a lot.
Yes, with a direct connection to postgresql.
You will need to install an odbc driver for postgresql.
On Thu, 13 Feb 2020 at 5:21 AM, Germán Barrientos Mora <gbarrientos@soluciones4g.com> wrote:
Dominique KON-SUN-TACK [Project Manager]
Odoo Gold Partner, best Odoo Partner 2014 for APAC
Mobile: + 65 8502 2399
Skype: dominique_elico
Website: www.elico-corp.com
When using separate BI tool you often have a case where you have a lot of data, let's say 100 million rows of data or more. This is fine with direct db connection, but do you have experience of exporting this kind of data volumes daily using XML-RPC. Just based on earlier experience of my this does not sound feasible?
Hi Dominique,
I don't have a big idea about this, but I think if you can add python script for enabling PowerBi to fetch data from Odoo , It's possible.
Also you may take a look at this Advanced Graph View module , It's not like PowerBi but it somewhat helps to visualise the data.
Hope I Helped
Regards
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
Sep 24
|
1636 | ||
|
0
Sep 24
|
312 | ||
|
|
0
Sep 24
|
133 | ||
|
|
0
Sep 24
|
154 | ||
|
2
May 24
|
586 |
Hi Dominique... you may check out this module on appstore....https://apps.odoo.com/apps/modules/12.0/PowerBIConnect/