If this requirement to to  get data by executing SQL statement  -for  ODOO.SH  not working for us.

After many  search.. we are using CDATA ( PAID) utility  to extract..  

Hello,

You can use the module below to connect Power BI with odoo. I hope this is helpful to you.
https://apps.odoo.com/apps/modules/18.0/cr_power_bi_desktop_connector

Thanks,
info@creyox.com

You have access to your database in the shell directly on odoo.sh

Look here under "Shell", but basically just type psql and your in

https://www.odoo.com/documentation/user/16.0/odoo_sh/getting_started/branches.html

I believe that you know how to build a URL string of database and authenticate it.

why woudl you want to connect to Power BI. Arent there enough excel functionalities Odoo to get your desired informations?

sorry for the question i am new to Odoo :-)

If you're looking for something open-source, i'd highly recommend this connector.
Used successfully in a few projects.

https://github.com/tmijail/Odoo-Power-BI-Connector

Hi,

You can use the following module to integrate your data with Power BI:

https://apps.odoo.com/apps/modules/17.0/power_bi_integration

Hope it helps

You can connect Power BI with Odoo by following these simple steps:

1. Enable Odoo API Access: Ensure that your Odoo instance has API access enabled. You can use the built-in XML-RPC or JSON-RPC API.
2. Use Power BI Connector or Script:
   • You can use a Power BI Odoo connector (some are available on GitHub or marketplaces).
   • Alternatively, you can write a Python script or use Power BI's Web data source to fetch Odoo data via the API.
3. Get the Odoo Data: Use the API to pull data, such as customers, sales, and products, into Power BI.
4. Build Your Reports: Once data is loaded, you can build dashboards and visuals in Power BI.

Need it easier? Some companies also offer ready-made Odoo-to-Power BI connectors or custom modules to simplify the process.

Please let me know if you'd like a sample script or a connector link.