Connect Power BI to Odoo and Extract Data

[Anonymous]

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,

[vishallsinghh]

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.

[aayu1010]

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

[chandsharma]

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/

[odoo]

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/ 

[JulesVDD]

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/ 

[tmijail]

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.

[OscarPoltti]

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. 

[Anonymous]

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!

[chandsharma]

https://apps.odoo.com/apps/modules/15.0/bi_direct_connecter/

[amitchandak]

@Anonymous , refer if these can help

https://www.youtube.com/watch?v=35UrcrHPunY

https://apps.odoo.com/apps/modules/12.0/PowerBIConnect/

https://www.cdata.com/drivers/odoo/powerbi/

[Anonymous]

Hello,

Thanks for your answer. Is not for what I look.

I have already seen thes links, I am no longer looking for a free solution.

Best,

[chandsharma]

https://apps.odoo.com/apps/modules/15.0/bi_direct_connecter/
this might be of your interest. only direct odoo to powerbi connector on odoo app store.
it gives features like, direct connection, token based authentication, single click data refresh, data from all the tables , even custom modules data. its a nice one.
support team is also good

[Anonymous]

Hi, how did you connect with odoo? 

[chandsharma]

check this out
https://apps.odoo.com/apps/modules/15.0/bi_direct_connecter/
this might be of your interest. only direct odoo to powerbi connector on odoo app store.
it gives features like, direct connection, token based authentication, single click data refresh, data from all the tables , even custom modules data. its a nice one.
this is a single click install on odoo and windows powerbi also.
support team is also good