Power BI has the versatility that you can publish your reports to the cloud (Power BI Service) and grant your organization’s individuals with access to view them anywhere and from any device. If there’s changing data then you need a way to refresh it automatically.
Also, senior management may need a way to refresh it on demand, i.e. when a major sale occurs, or when they’re expecting to reach end of month sales goals.
If the report is published to the Power BI Service, it doesn’t have access to your on-premises SQL Server (intranet), so you need an additional configuration