Forum Discussion
Anonymous
6 years agoNot applicable
Need help finding all Apps and the users within through PowerShell.
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 ...
Greg_Deckler
Community Champion
6 years agoI just went down this path and didn't find much. I had to brute force it. Luckily there were only about 30 apps.
Anonymous
6 years agoNot applicable
Greg_Deckler when you say brute force, what methods did you use?
- Greg_Deckler6 years ago
Community Champion
Here is the basic process:
- Log into the Power BI Service
- Open the Workspace
- Click Access
- If it is a Classic Workspace it will launch Outlook interface to look at Groups (sometimes you have to do this multiple times)
- If it is a new workspace, take a screen shot of the permissions
- If multiple pages of results, more than one screen shot
- Click on Update App
- Go to Permissions pane
- Document the permissions
- Back to workspace
- Click on Dashboards
- Look at the permissions on each dashboard
- Click on reports
- Look at the permissions on each report
- Click on datasets
- Look at the permissions on each dataset
- If there is RLS for each dataset
- 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.