cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Exporting list of those with access to the Report

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

1 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())})

 

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

 

View solution in original post

18 REPLIES 18
Impactful Individual
Impactful Individual

You can proably use the REST API to get this using some PowerShell.

 

You can of course query the backend database (ReportServer DB) if you have access with something like this

 

All our security is applied at a folder level (hence the Type=1) if its an indivuidual report you would need to figure out how to query for that within the dbo.catalog table.

 

SELECT	u.UserName
	   ,r.RoleName
FROM	dbo.PolicyUserRole pur
		LEFT OUTER JOIN dbo.Roles r
			ON r.RoleID = pur.RoleID
		LEFT OUTER JOIN dbo.Users u
			ON u.UserID = pur.UserID
WHERE	pur.PolicyID = (
						 SELECT	PolicyID
						 FROM	dbo.Catalog
						 WHERE	Type = 1
								AND Path = '<PATH_TO_FOLDER>' );

from where i can get the access of the db

Impactful Individual
Impactful Individual

When you install PBI Reporting Server it has to be setup with a database backend. You can see where this is by running the PBI Reporting Server config tool on your PBI Reporting server. You will need permissions to go query that server and DB.

 

 

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())})

 

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

 

View solution in original post

Hi, Can it be that something changed on the site? It is not working for me. 

LinVPowerBI1_0-1612970933440.png

Thanks in advance!

Hi there,

just tried it and it still works for me.... did you open the Manage permissions page of the dataset first? The URL that starts with https://app.powerbi.com/groups/me/permission/report 

Yes it worked, I was looking at the pop-up screen. Great thanks!

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,

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())})

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!

Thank you @AlexanderK79 , worked perfectly

Impactful Individual
Impactful Individual

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"

 

Hi,

 

Where do you get from the Report Server URI parameter?

 

Thanks!

Cristina

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

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

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

Could you explain me which aproach did you take?

 

Thank you so much!

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

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Kudoed Authors