Forum Discussion
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 challenges. Unfortunately, I’m unable to use PowerShell to pull the audit logs because I don’t have the necessary administrative rights to run PowerShell.
I’ve managed to pull some data using the Feature Usage and Metrics app, but I would like to verify those results and, if possible, gather additional insights. I believe the REST API could be a good alternative, but I’m currently facing some issues with the token.
Any guidance or suggestions on how to overcome these challenges would be greatly appreciated.
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
4 Replies
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.
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=04iw9SYI2HN80HKSHi, 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 😅
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by our super user Poojara_D12 helps you? or let us know if you need any further assistance here?
Your feedback is important to us, Looking forward to your response.
Thanks.
