One of the most resource-intensive operations performed by Power BI is refreshing datasets. Each dataset can use multiple data sources, for example, your data warehouse or a SQL Server. It's important to monitor the load on these sources as well.
Even great tools have problems. Power BI is a great tool, but it is not perfect. In this article, Brent and Greg discuss some common problems and challenges in Power BI.
A guest post by Štěpán Rešl describing an approach to automated collection of Usage Metrics across many workspaces, without using the Admin APIs. This is highlighting a free solution that Štěpán has created to automate this workflow.