Forum Discussion
Export Report user list to CSV/Excel
Hi,
I need to export the list of my Report users to a CSV or Excel file. However there seems to be no option to do that. When I try to copy the content from the Power BI service HTML page, its either not working or the copied values are not in <TR> <TD> format. Its all jumbled up!
This happens both in the Manage Security and the "Shared User list"
I cant beleive we dont have this feature yet
HI Anonymous ,
I checked power bi REST API but haven't found any API can export report users. (it only allow you to export users list for group or gateway datasource)
Maybe you can consider tracing power bi audit log to extract specific logs that logged users view power bi reports. (you can group users by viewed report id)
Use auditing within your organization
Regards,
Xiaoxin Sheng
4 Replies
HI Anonymous ,
I checked power bi REST API but haven't found any API can export report users. (it only allow you to export users list for group or gateway datasource)
Maybe you can consider tracing power bi audit log to extract specific logs that logged users view power bi reports. (you can group users by viewed report id)
Use auditing within your organization
Regards,
Xiaoxin Sheng
Ugly but efficient.....
open the share page 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
