Exporting list of those with access to the Report

[Anonymous]

Hi, 

I'd like to export the list of those that my report has been shared with. The list has gotten rather long and exporting is the most efficient way. Is there a way to do this? I am already at the list of recipients, I just don't see a way to export.

Thanks

[AlexanderK79 · Accepted solution]

Open the Manage permissions page of the dataset  in Chrome, and then start a developer mode using F12

in the console area type the following command:

$('span.emailColumn').each(function() { console.log ($(this).text())})

This will give you all the mail addresses 🙂 in a list

or.... even cooler:
$('.permissionTable li').each(function() { console.log ( $(this).children('span.nameColumn').text(),",",$(this).children('span.emailColumn').text(),",",$(this).children('span.memberAccessColumn').text())})

Check Bart's updated version of the script since the release of the new sharing experience: https://community.powerbi.com/t5/Report-Server/Exporting-list-of-those-with-access-to-the-Report/m-p...

which will give you a CSV list in the console to be copy/pasted

[AkshayManke]

Hi, i tried the solution suggested by you and it worked very perfectly. I just would want to tweek some parameters like instead of Email i want Alias. How should i do that? From where i can get more references to make more combinations?

Many Thanks,

[AlexanderK79]

no, I'm sorry... you can only retrieve what shows up in the permissions list...

have you tried:

$('.permissionTable li').each(function() { console.log ( $(this).children('span.nameColumn').text(),",",$(this).children('span.emailColumn').text(),",",$(this).children('span.memberAccessColumn').text())})

[marteaga]

This is great!!! thank you! do you have a similar coding for extracting the users assigned to each row-level security role? this would be so helpful to control accesses and manage the security roles. Thank you in advance!

[sarava0483]

Hi, I have a similar kind of requirment to export list of users assigned in different roles..any update on this

Thanks in advance!

[AlexanderK79]

Nope 😞

[Anonymous]

Thank you @AlexanderK79 , worked perfectly

[Anonymous]

If you install the ReportingServicesTools PowerShell module from here

https://github.com/Microsoft/ReportingServicesTools

you can get the data back pretty easily.

Import-Module ReportingServicesTools

$CatItemRoles = Get-RsCatalogItemRole -Path "/ThisFolderOrItem" -ReportServerUri "http://yourServerName/ReportServerPBI"

$CatItemRoles | Export-Csv -LiteralPath "C:\CatItemRoles.csv"

[Anonymous]

Hi,

Where do you get from the Report Server URI parameter?

Thanks!

Cristina

[AlexanderK79]

You don't need the  Report Server when you use the trick with the debugging tools

[Anonymous]

No? What do you need then? I write this on Power Shell: Import-Module ReportingServicesTools; Get-RsCatalogItemRole this is what I'm getting:

Failed to establish proxy connection to http://localhost/reportserver/ : Failed to establish proxy connection to http://localhost/reportserver/ReportService2010.asmx : There was an error
downloading 'http://localhost/reportserver/ReportService2010.asmx'

The first lines of code are part of this: 

Import-Module ReportingServicesTools
$CatItemRoles = Get-RsCatalogItemRole -Path "/ThisFolderOrItem" -ReportServerUri "http://yourServerName/ReportServerPBI"
$CatItemRoles | Export-Csv -LiteralPath "C:\CatItemRoles.csv"

That's why I was asking for the ReportServerUri parameter.

Please, help me 🙂 

Kind regards, 

Cristina Simion

[AlexanderK79]

Sorry, but I don't know... I took a different approach

[Anonymous]

Could you explain me which aproach did you take?

Thank you so much!

[tamilkumaran]

@Anonymous He took the console approach which he did explain in his previous message. It works perfectly!!