Monitoring - Fabric Capacity Metrics and Get-PowerBIActivityEvent

Hi tobny76 

The Capacity Metrics app will only tell you that a dataset is consuming a lot of capacity, but it won’t show which visual or embedded report is behind it. That’s why you don’t see the detail in Get-PowerBIActivityEvent  those logs mainly capture activity from Service users, not always embedded workloads.

A couple of things you can try:

• For normal Power BI Service reports >> the activity logs should show “QueryData” events with report and user details.
• For embedded capacity >> queries triggered from embedded visuals usually won’t show in ActivityEvent. In this case, use the Capacity Metrics app together with Log Analytics (if you have it enabled) to see which dataset/operation is heavy.
• To get the actual query text >> run Performance Analyzer in Desktop or capture it in DAX Studio against the dataset. That way you can map the expensive query back to a visual.

So in short: ActivityEvent won’t expose embedded queries, you’ll need to use Capacity Metrics/Log Analytics for usage patterns and Performance Analyzer/DAX Studio to see the actual query.