Forum Discussion
Connect Power BI to Odoo and Extract Data
Hello every body,
I want to connect Power BI Desktop to Odoo and extract all the data.
I looked for a solution online but they are not clear.
Someone can please explain to me how I can access to the data in Odoo via Power BI step by step ? For information I use Windows System.
I need your help :), Thank you.
Best,
15 Replies
- tmijail
Advocate I
For anyone still looking for a free solution, I made an open source Odoo connector.
https://github.com/tmijail/Odoo-Power-BI-Connector/
It doesn't support query folding yet, so make sure to read the README for the recommended way to use it.
Hi Tmijail,
Been using your connector and it works great.
However my organization now runs Odoo with google authenticator instead of email/password authentication and I can't find a way to connect it to powerbi anymore.
Is there a way or work around? I have a few dashboards pending on this so any help would be appreciated!
Keep up the good work!
Hi friend, i from Perú. How could your odoo connector use it with powerbi service? The desktop works perfectly, but it does not connect to the powerbi service.
From what I have found, there is only one Odoo Power BI Direct Connector Module on the ODOO app store from TECHNEITH.
I am using this for my customers also, it is actually good and I don't have to download data it is a direct connector also we can refresh with a single click on Power BI for any recent data changes that happened in ODOO.
The team is very helpful and helped me with the setup also.
https://apps.odoo.com/apps/modules/15.0/bi_direct_connecter/I have used this connector. Really good product. But this link is no more valid, the updated link is https://www.techneith.com/products/odoo_power_bi_direct_connector/
Hello,
I utilized Techfinna's Odoo Power BI Direct Connector to connect my client's Odoo dataset with Power BI Desktop. This connector enables integration between Odoo and Power BI Desktop with a secure, One-click connection, imports data using SQL and manual and automatic data refresh etc.
Connector:
- amitchandak
Super User
Anonymous , refer if these can help
https://www.youtube.com/watch?v=35UrcrHPunY
JulesVDDAdvocate II
Hi there, if you are looking for a live example of a Power BI dashboard build on Odoo data, you can find it on the Odoo app market place. You can connect the dashboard to your own Odoo data.
https://apps.odoo.com/apps/modules/15.0/power_bi/I would highly suggest you to use a module which would help you integrate ODOO dataset so that you don’t have to upload the dataset again & again , a Module that has really helped me would be :- https://techneith.com/products/odoo_power_bi_direct_connector/ , Hopefully this would have been of some help
Hello,
I believe I can be the right person to answer this.
I have also been looking out for ways to connect PowerBI with Odoo and came across this connector which helped all my hassle to complete the work.
Visit: https://techneith.com/products/odoo-power-bi-direct-connector/
to use the connector
It was easy to install and the support team helped me throughout the process, since I knew I would be using this connector only for a year they didn't charge me for more than one year of pricing.
Here's an easy step-by-step tutorial to connect your Odoo with PowerBI.
