The problem of slow reports in Odoo
At a logistics company, the operations team needed daily inventory and sales reports. Every time the analyst opened Power BI, the direct query to the Odoo database took minutes, saturating the workers and slowing down access for other users. After months of frustration, they discovered that the key was using optimized SQL queries and a secure connection. That is how the solution we share here was born.
Why connect Odoo SH to Power BI?
Connecting Odoo SH (Odoo.sh) to Power BI lets you visualize data in real time without affecting ERP performance. By using direct SQL queries, you avoid overloading the workers and get fast reports. For example, a retail company managed to reduce its daily sales report loading time from 5 minutes to 10 seconds by applying this technique.
Step 1: Get the connection data
You need the name of your database in Odoo SH. If you don't know it, your account manager at Ganemo can provide it easily. Then, in Power BI Desktop, select 'Get data' and choose 'PostgreSQL'. Fill in the server with 'localhost:25432' and the database name. A real case: at a tech startup, the team forgot the database name and checked it with their Ganemo contact, solving the problem in minutes.
Step 2: Use SQL queries to optimize
In the 'Advanced import' window, write a custom SQL query. This is critical to load only the data you need and avoid pulling entire tables that consume resources. For example, a financial analyst uses:
SELECT id, name, amount_total, date_order FROM sale_order WHERE state = 'sale' to pull only confirmed orders. Their monthly report now refreshes in seconds.Step 3: Secure credentials
Enter the username and password of your PostgreSQL database. Never share passwords over chat. At a services company, the CEO used a secrets manager such as Secret Vault (similar to secrebo) so that his AI agent could query the password without exposing it. That way, even if the chat were hacked, the key stays safe. Ganemo recommends this practice for all its clients.
Step 4: Fix certificate error
If 'The remote certificate is not valid' appears, go to 'File > Options and settings > Data source settings', select the connection, edit permissions and disable 'Encrypt connections'. This is normal for connections to Odoo SH and poses no security risk. A manufacturing team solved this error in 2 minutes by following these steps.
Step 5: Successful connection and publishing
Once the table is loaded, you can create reports in Power BI Desktop. To publish them to the cloud, use app.powerbi.com with a free account. Keep in mind that the free plan does not allow sharing reports, but it is perfect for testing. Once ready, get a Pro license. With Ganemo as your partner, you get advice to scale without complications.
Benefits of this connection
- Performance: optimized SQL queries reduce the load on Odoo SH.
- Security: passwords are managed with tools such as Secret Vault.
- Free: you only need Power BI Desktop and a free Power BI account.
If you are a Ganemo client or a member of its subscriptions, access the full Power BI manual in the portal. Implement this solution today and forget about slow reports.