Power BI is the reporting layer of the Microsoft stack
Power BI's advantage is everything around it. It works with Microsoft identity, Azure, Teams, SharePoint, and Office, so access control follows the directory IT already manages and reports show up where employees already work. Security and compliance coverage is mature, administrative control is deep, and per-user licensing is generally lower than other enterprise BI suites, which matters when the audience is the whole company.
The burden sits with the builders. Reports are typically authored in Power BI Desktop, and meaningful semantic models rely on DAX, a formula language with a steep learning curve. Row-level security and workspace management take configuration, and as reports multiply, maintaining models and calculations can consume a lot of specialist time.