Forum Discussion
Impactful IndividualExcel/CSV Export All User Report Permissions Across All Reports & Workspaces within a Tenant
Hello Community -
Is there a way to export to Excel/CSV all user report permissions across all reports & all workspaces within a tenant?
- Include workspace level access (Viewer, Member, Admin - user name, report name, access level)
- Include report level access (Direct Access, Links etc. - user name, report name, access type)
- Include RLS (user name, report name, RLS role)
ChatGPT is telling me this is not possible. However, I'm in disbelief that this is the case.
Can it really be true there is no way to do this?
I've researched a few additional routes that don't seem viable:
- PowerShell cannot see RLS assignments and can only return data at the user to Workspace level (not the User to Report level)
- REST API presents the same problems. No RLS or user to report level data available.
- Microsoft Purview Does NOT include RLS or Direct report-sharing access
- Power BI Metadata Scanning API still cannot show RLS role to user
If anyone is aware of an efficient way to comprehensively audit user-to-report permissions across an entire tenant, I would be grateful if you could point me in the right direction.
Regards,
Nathan
Hi WinterMist
From my understanding, you can get this all from the scanner api. You just need to expand all the nodes in the Json that you get back from the scanner api.
Here is a blog post: https://powerbi.tips/2021/10/using-the-power-bi-scanner-api-to-manage-tenants-entire-metadata/
5 Replies
- GilbertQ
Super User
Hi WinterMist
From my understanding, you can get this all from the scanner api. You just need to expand all the nodes in the Json that you get back from the scanner api.
Here is a blog post: https://powerbi.tips/2021/10/using-the-power-bi-scanner-api-to-manage-tenants-entire-metadata/
- WinterMist
Thanks very much for the recommendation. I will check it out & hopefully it can meet the need!
Regards,
Nathan
- v-csrikanth
Community Support
Hi WinterMist
Thank you for being part of the Microsoft Fabric Community.
As highlighted by GilbertQ , the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolved
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth. - v-csrikanth
Hi WinterMist
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!Best Regards,
Community Support Team _ C Srikanth. - v-csrikanth
Hi WinterMist
I wanted to follow up since I haven't heard from you in a while. Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!Best Regards,
Community Support Team _ C Srikanth.
