Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 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! 

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    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's avatar
      Anonymous
      Not applicable

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

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion

        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. 

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support

    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.