Forum Discussion

viswaaa's avatar
viswaaa
Icon for Helper IV rankHelper IV
1 year ago
Solved

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 users

     

    I 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

  • 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 users

     

    I 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,

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Icon for Community Support rankCommunity 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.

  • 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's avatar
    V-yubandi-msft
    Icon for Community Support rankCommunity 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's avatar
    V-yubandi-msft
    Icon for Community Support rankCommunity 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's avatar
    V-yubandi-msft
    Icon for Community Support rankCommunity 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.