Fetching a whole database #10
Replies: 1 comment
-
You'd have to write a Maybe it would be possible to automate it by reading the Regarding maintaining the links between tables, Odoo's and PowerBI's relationships aren't 100% compatible (especially many2many relationships). You can get PowerBI to automatically recognize one2one or one2many relationships between two tables if the related columns have the same name. For example, the Either way, I'd recommend you import just the models, fields and relationships necessary for your reports. Large PowerBI models are hard to mantain and your proposed model will require maintenance when you upgrade to a newer Odoo version or when your user's permissions change. Also, Odoo servers are prone to time out when you try to read a lot of data at once (especially if that data includes computed, non stored fields) |
Beta Was this translation helpful? Give feedback.
-
Hello,
I'm using your connector to connect Odoo to powerBI.
I have a lot of models on Odoo (more than 200) meaning I cant use search_read for each of them. I also want to keep the links between the tables.
In a nutshell, I want to fetch all the data and database from Odoo.
Is that possible?
Beta Was this translation helpful? Give feedback.
All reactions