Forum Discussion
user stats in Power Bi service
Hi All,
I am a Power BI Admin with a Power BI Pro license, and I need to see how many users have logged into the Power BI service over the last 30 days to check their reports.Also need to see who are people not logged in.
Just need to remove their licenses if they dont use.
How to get this info
Hi viswaaa
Unfortunately, this information isn't available directly in Fabric, but you can access it in Purview if that's an option.
Go to Microsoft Purview Compliance Portal.
Navigate to Audit under the Solutions section.
Filter Record types by PowerBIAudit.
Set the date range (e.g., last 30 days).
Optionally, filter by specific activities like ViewReport, PublishReport, etc.
Export the results to identify active usersI hope this helps.
Hi. It might not be specifically login, but you can see features and operations of the users in the report that is created at the Admin Workspace. I'm talking about: https://learn.microsoft.com/en-us/fabric/admin/feature-usage-adoption
That report will show last 30 days of activity. If a users is not there, they haven't used power bi for absolutely anything, so it could be like not login.
You can also build you own report and grow in historic data if you take this data from the API: https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events
I hope that helps,
Hi viswaaa
You can certainly look at the Feature Usage and Adoption report. If the user has accessed a report then they haven't logged in. It is simple as that. Really. There is no need to look for login information because unless they're viewing reports, there's no need to identify whether they've logged in. That is what I use for my other customers and it works quite well.
7 Replies
- wardy912
Super User
Hi viswaaa
Unfortunately, this information isn't available directly in Fabric, but you can access it in Purview if that's an option.
Go to Microsoft Purview Compliance Portal.
Navigate to Audit under the Solutions section.
Filter Record types by PowerBIAudit.
Set the date range (e.g., last 30 days).
Optionally, filter by specific activities like ViewReport, PublishReport, etc.
Export the results to identify active usersI hope this helps.
- ibarrau
Super User
Hi. It might not be specifically login, but you can see features and operations of the users in the report that is created at the Admin Workspace. I'm talking about: https://learn.microsoft.com/en-us/fabric/admin/feature-usage-adoption
That report will show last 30 days of activity. If a users is not there, they haven't used power bi for absolutely anything, so it could be like not login.
You can also build you own report and grow in historic data if you take this data from the API: https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events
I hope that helps,
- V-yubandi-msft
Community Support
Hi viswaaa ,
To clarify, Power BI does not offer a direct login metric. To identify inactive users, you can review their activity using the Feature Usage & Adoption report, Purview Audit logs, or the Activity Events API.
Thank you all for your valuable input.Regards,
Yugandhar. - GilbertQ
Super User
Hi viswaaa
You can certainly look at the Feature Usage and Adoption report. If the user has accessed a report then they haven't logged in. It is simple as that. Really. There is no need to look for login information because unless they're viewing reports, there's no need to identify whether they've logged in. That is what I use for my other customers and it works quite well.
- V-yubandi-msft
Community Support
Hi viswaaa ,
I wanted to check in regarding your issue. Has it been resolved, or do you need any further information. Let me know if you’d like more details.
Thanks.
- V-yubandi-msft
Community Support
Hi viswaaa ,
Just following up has your issue been resolved, or are you still having any difficulties? If you need more information or help, please let us know.
Thanks.
- V-yubandi-msft
Community Support
Hi viswaaa ,
May I know if the issue has been resolved, or are you still facing any challenges? Please let us know if you need any additional details or assistance.
Thanks.