If you do not want to use manual export or import method, you may use direct connector which handles almost everything in a couple of clicks.
YouTube: https://www.youtube.com/watch?v=XfjPP8LW0l4
Website: Odoo PowerBI Direct Connector - TechFinna - Techfinna
Odoo App Store: https://apps.odoo.com/apps/modules/18.0/powerbi_desktop_connector
Search TechFinna Odoo Power BI Connector or Odoo Power BI Desktop connector on Odoo App Store or Google.