Forum Discussion
Capacity dashboard doesn't share the client that is making interactive queries.
Hi Anonymous
I agree with you, and I'm certain there is some sort of a scheduled refresh that causes the spike. There are lots of PBI users with access to the dataset (read/build). Given the number of users who can connect to this, it isn't easy to know whose scheduled refresh is responsible.
Normally a scheduled refresh would show the name of the user who is connecting (via the "Analysis Services" import queries).
However in this example, there is no name associated with the queries.
As I mentioned, I suspect it may not be a normal user who is reading this data, but an Entra service principal (app registration). Does that make sense? Have you ever used service principals? Have you ever seen them appear on a capacity dashboard? I'm guessing there isn't a well-defined behavior for service principals, so it is falling back on "Power BI Service" whenever it is displaying the activity for those users.