Include Analyze in Excel and XMLA queries in Usage Metrics for semantic models

Idea. Extend the built in usage metrics so they also cover direct semantic model access, including Analyze in Excel, Excel connections and other XMLA clients, and not only report and dashboard views.

Why. Many organizations have users who consume a semantic model directly from Excel instead of opening reports. The standard Usage Metrics report only shows report and dashboard consumption, so owners cannot easily see how many people use a model, who they are, or how many queries they run. Today this needs audit log exports or workspace monitoring.

Suggested behavior. A semantic model level view showing distinct users, active users over time, total queries, and the client application (for example Excel), available to workspace admins without extra setup.

Benefit. Better decisions about certification, capacity sizing, and retiring unused models.

Source thread (raised by another community member) https://community.fabric.microsoft.com/discussions/power-bi-web-app/x/5373339