Excel/CSV Export All User Report Permissions Across All Reports & Workspaces within a Tenant

[WinterMist]

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 can go into the Service and manually take screenshots from the data from Power BI Service.

- But this will take days of effort time for hundreds of users, across dozens of reports and double-digit Workspaces.

- Additionally, even before the manual process is finished, the data will likely have already changed.

- And the major problem remains that screenshots do not provide an easily searchable & sortable Excel/CSV file.

The below screenshots are from ChatGPT.

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 

[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.

[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 

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.

[WinterMist]

@GilbertQ 

Thanks very much for the recommendation.  I will check it out & hopefully it can meet the need!

Regards,

Nathan

[GilbertQ · Accepted solution]

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/