Actualisation from Odoo database

[orlandopicq]

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

[lbendlin]

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 · Accepted solution]

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,