Odoo Power BI Advance Connector | Execute SQL query in Power BI | Techfinna
Here you will understand how to execute SQL query in Power BI and simply export the data from your Odoo to create informative reports. You can find the basic connector here https://techfinna.com/odoo-powerbi-co...
Advance connector https://techfinna.com/odoo-powerbi-ad...
--------------------------------------------------------------------------------
Example SQL Query -
SELECT so.id, so.name, so.date_order::date AS order_date, so.state, so.amount_total, rp.id AS customer_id, rp.name AS customer_name, u.id AS salesperson_id, up.name AS salesperson_name, co.id AS company_id, co.name AS company_name, rc.name AS currency, rc.symbol AS currency_symbol FROM sale_order so JOIN res_partner rp ON rp.id = so.partner_id LEFT JOIN res_users u ON u.id = so.user_id LEFT JOIN res_partner up ON up.id = u.partner_id LEFT JOIN res_company co ON co.id = so.company_id LEFT JOIN res_currency rc ON rc.id = so.currency_id WHERE so.state IN ('sale','done') AND so.date_order::date BETWEEN DATE '2025-01-01' AND DATE '2025-10-08' ORDER BY so.date_order DESC, so.id DESC;
------------------------------------------------------------------------------
Odoo Data Model -
https://techfinna.com/odoo-data-model/
------------------------------------------------------------------------------
If you have any issue regarding this module feel free to reach out to us at [email protected] or connect with us on whatsapp