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

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 :-)

Hi! To connect Power BI with Odoo 16 Enterprise Edition, you can utilize the Odoo REST API to extract data and then import it into Power BI for analysis. Since you have access to Odoo.sh, ensure that the necessary API endpoints are enabled in your Odoo settings. If you need further assistance, there are also resources and tutorials available that can guide you through the integration process step by step.

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