Export Users of Power Bi App

[ap360]

Good day,

Is there a way of exporting users who have access to a Power BI App? I have tried numerous ways and I am not getting anywhere.

Thank you.

[Anonymous · Accepted solution]

Thanks for the reply from @lbendlin , please allow me to provide another insight:

Hi @ap360 ,

You can try the following code to get all the users of the created app in the console. Then save it to a file.

document.querySelectorAll("div .ng-star-inserted .user-info")[0].textContent

Also, you can try solution like below:

Export List of App "Users" - Microsoft Fabric Community

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ap360]

I figured out a way to Export the users that have access to a Power BI App as a CSV file. I was able to use the Developer's Tool and underneath the Console use a specific code to show the users, their email addresses, and to which reports they have access. 

Thank you to everyone for helping out.

[ap360 · Accepted solution]

 Make sure when creating the variables, need to ensure that you are using the correct column header's label.

var text = '';
$('.row').each(function() {
    var username = $(this).find('.user-name').text();
    var email = $(this).find('span.col-emailAddress').text();
    var audience = $(this).find('span.col-message').text(); 
    text = text + (username + "," + email + "," + audience + "\n");
});
 
// Create a Blob with the CSV data
var blob = new Blob([text], { type: 'text/csv;charset=utf-8' });
 
// Create a download link
var downloadLink = document.createElement('a');
downloadLink.href = window.URL.createObjectURL(blob);
downloadLink.setAttribute('download', 'user_data.csv');
 
// Simulate click on the download link
downloadLink.click();

[Anonymous]

Hi @ap360 ,

A great program indeed, thanks for the feedback!

Best Regards,
Adamk Kong

[AMeyersen]

Hi @ap360 :
In my opinion, there is an automatic way using the Admin API
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/apps-get-app-users-as-admin

You need to enable the Admin API in the Admin Portal first. 

I'd highly recommend to enable the API only for a single security group and make your service principal a member of that specific group.

[lbendlin]

@AMeyersen That solves part of the issue.  It doesn't show the audience assignments though.

[Anonymous · Accepted solution]

Thanks for the reply from @lbendlin , please allow me to provide another insight:

Hi @ap360 ,

You can try the following code to get all the users of the created app in the console. Then save it to a file.

document.querySelectorAll("div .ng-star-inserted .user-info")[0].textContent

Also, you can try solution like below:

Export List of App "Users" - Microsoft Fabric Community

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

No, this is a long-standing gap.  Impossible to report on audience members vis API.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

[ap360]

Thank you for your reply.

Is there any method that you would recommend? I have heard using Azure might be beneficial.

[lbendlin]

For now your only way is to use eyeballs.