Forum Discussion
Finding a specific user's PBI workspaces
Hey all,
I have an associate who left the business I work at, and I need to locate what Power BI workspaces they were in so I can make sure their replacement has access to their PBI reports and dataflows. However, the only method I can find online for determining which workspaces he was in is to use the admin portal to check every workspace. However, due to the size of my company, there are way too many workspaces to check like this. Is there a way for me to check what workspaces a specific user is a member/contributer/viewer/admin of?
Any and all help is appreciated.
Hi jarwest ,
The answer given by Mauro89 is good but if you do not have Fabric yet you can uses the Power BI rest API's. That link is here: Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn
Specifically, I think the users list of access is this one:
Admin - Users GetUserArtifactAccessAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Learn
2 Replies
- collinqSuper User
Hi jarwest ,
The answer given by Mauro89 is good but if you do not have Fabric yet you can uses the Power BI rest API's. That link is here: Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn
Specifically, I think the users list of access is this one:
Admin - Users GetUserArtifactAccessAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Learn - Mauro89Super User
Hi jarwest,
Fabric brings the perfect tool for that out of the box 🙂
Check out the docs for it and once it is in place, slice and dice the "OneLake Catalog - Governance for Admins" PBI report to get this information. You can select the user and check which items belong to this user and in which workspaces they are.
What is the admin monitoring workspace? - Microsoft Fabric | Microsoft Learn
Best regards!
PS: If you find this post helpful consider leaving kudos or mark it as solution