Unable to get Active+Inactive users from Power BI usage metrics report

[manoj0285]

Hi Team,

I wanted to know how can I get Active + Inactive users (Total Users) from Power BI usage metrics report, I have approximately 200+ reports and 15+ workspaces. I need this in single report.

[manoj0285]

Its really weired that we can not see users, to whome I have provided access in one shot/report. Power bi should provide such details.

[lbendlin]

you cannot measure stuff that is not there.  How do you define "inactive users" ?

[manoj0285]

Hi, if microsoft is providing active users in the report then they must have inactive users as well and inactive users means we have shared the report with users but they have not seen this in last 30 days or more than that. 

[lbendlin]

Talk to your tenant admin and ask for the ViewReport audit logs.

Keep in mind that the preferred way of sharing is via distribution lists. That adds complexity to your ask.

[manoj0285]

I had word with tenant admin and he provided audit logs but they dont have view which I want. 

[lbendlin]

Which view do you want?  The combination of CreateApp/UpdateApp (sharedto) and ViewReport (actual consumption) audit logs should give you "all" you need.

[manoj0285]

Thanks for your reply, I am looking a data which will tell me with how many users I have shared the report. I mean sharedto, I have actual consumption data. Please guide me from where can I get this. Many Thanks.

[lbendlin]

You get these from the tenant inventory reports. Talk to your tenant admin.