The short answer
Looker Studio is free and quick for marketing and Google-ecosystem reporting. Power BI is the stronger choice for complex data models, finance and operations reporting, row-level security and Microsoft-centric organisations.
Cost
Looker Studio is free to use, with paid connectors for some non-Google sources. Power BI requires per-user licences for sharing (Pro or Premium per user), or capacity licensing at larger scale.
Data modelling
Power BI includes a powerful modelling engine and DAX calculation language, suitable for multi-table finance and operations models. Looker Studio is lighter and works best on pre-modelled data, often from BigQuery.
Connectors
Looker Studio connects natively to Google Analytics, Google Ads, Search Console, Sheets and BigQuery. Power BI connects to Microsoft sources, SQL databases, Excel and hundreds of other systems.
Sharing and security
Power BI offers mature row-level security and governance within Microsoft 365. Looker Studio sharing is simple, using Google account permissions.
Recommendation
- Marketing performance dashboards on Google data: Looker Studio.
- Leadership, finance and operations reporting across ERP and CRM: Power BI.
- Many organisations use both, fed by the same data warehouse.