Need help finding all Apps and the users within through PowerShell.

[Anonymous]

I need help finding a way to pull all the Apps and the users within through PowerShell. I have a working script for workspaces and users and would like the same for Apps but dont see much in the way of pulling such info through PowerShell.

Does anyone have methods or script examples on how to pull all the Apps and correlated users? 

Thank you for the help in advance! 

[Icey]

Hi @Anonymous ,

To my knowledge, it is not supported in Power BI currently.

One workaround, you can try to use Power BI REST APIs to get apps:

https://docs.microsoft.com/en-us/rest/api/power-bi/apps/getapps.

Here is a similar idea and you can vote it up, or create a new idea: 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33778159-retrieve-power-bi-app-information-using-powershell

Best Regards,

Icey

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

[Greg_Deckler]

I just went down this path and didn't find much. I had to brute force it. Luckily there were only about 30 apps.

[Anonymous]

@Greg_Deckler when you say brute force, what methods did you use? 

[Greg_Deckler]

Here is the basic process:

1. Log into the Power BI Service
2. Open the Workspace
3. Click Access
   1. If it is a Classic Workspace it will launch Outlook interface to look at Groups (sometimes you have to do this multiple times)
   2. If it is a new workspace, take a screen shot of the permissions
   3. If multiple pages of results, more than one screen shot
4. Click on Update App
5. Go to Permissions pane
6. Document the permissions
7. Back to workspace
8. Click on Dashboards
9. Look at the permissions on each dashboard
10. Click on reports
11. Look at the permissions on each report
12. Click on datasets
13. Look at the permissions on each dataset
14. If there is RLS for each dataset
15. Look at the RLS permissions

You get the idea. Brute force. Now, I will almost guarantee you that if you go through this excercise you will find individual permissions all over the place unless you have had a very strong governance program for Power BI from the start. So, the easiest way to clean all that up a lot of times is to unpublish the app, wipe out all of the individual crazy permissions all over the place. Verify that the Workspace owners are correct, Re-publish the app to the correct groups of people.