Forum Discussion

Dimitris_Kats's avatar
Dimitris_Kats
Icon for Helper V rankHelper V
1 year ago
Solved

Identify Inactive Wlrkspaces

Hello everyone, I hope you're all doing well. I need your help once again with a task I’m currently working on. I’m trying to identify inactive workspaces in Power BI, but I’ve encountered some ch...
Need Help
  • Poojara_D12's avatar
    Poojara_D12
    1 year ago

    Hi Dimitris_Kats 

    To identify inactive Power BI workspaces:

    • Authenticate with REST API:Register an Azure AD app, enable permissions, and get an access token.
    • Use REST API:Retrieve workspace list using Get Groups API.Check dataset activity with Get Dataset Last Refresh API to identify inactivity.
    • Cross-Validate:Use data from Feature Usage and Metrics app to confirm inactivity.
    • Automate:Write a script to automate authentication, data retrieval, and analysis.

     

    Did I answer your question? Mark my post as a solution, this will help others!
    If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

    Kind Regards,
    Poojara
    Data Analyst | MSBI Developer | Power BI Consultant
    Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago
Unfortunately, I’m unable to use PowerShell to pull the audit logs because I don’t have the necessary administrative rights to run PowerShell.

Find someone who can do that (ie the tenant admins).  

 

"inactive workspace"  is a very, very loaded term. You want to be very precise in the definition of that to avoid looking for a black cat in a dark room.