Forum Discussion

orlandopicq's avatar
orlandopicq
Regular Visitor
4 years ago
Solved

Actualisation from Odoo database

Hello,

 

My project is to connect our ERP (www.odoo.com) which runs on Odoo.sh (GitHub repository).

I've been able to connect PowerBI desktop to Odoo database with this PowerBI connector --> Odoo-Power-BI-Connector 

 

Now that I've created my dashboards, I published it on the web.

My question now is how to actualize the data as I get this message when I try to configure the automatic actualisation :

 

 

I'd appreciate any help on this topic.

 

Kind regards,

Orlando Picq

 

  • Hello,

    Thanks for replying. I was using a Odoo connector provided by Mijail. I don't think it was direct query.

    But I got the solution from him directly, see the discussion : Github discussion 

    It might help some others who encounter this issue.

    Kind regards,

2 Replies

  • Looks like you are connecting to odoo via direct query, and the Power BI service doesn't seem to like it.

     

    Are you using search_read or the other approach?  

    • orlandopicq's avatar
      orlandopicq
      Regular Visitor

      Hello,

      Thanks for replying. I was using a Odoo connector provided by Mijail. I don't think it was direct query.

      But I got the solution from him directly, see the discussion : Github discussion 

      It might help some others who encounter this issue.

      Kind regards,