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 

Poojara_D12's avatar
Poojara_D12
Icon for Super User rankSuper User
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 

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

    Hi, thank you so much for the reply. This is very helpful.

    Could you please give me more information regarding the script I need to write to automate the authentication? I am new to the automation staff 😅