Need Power shell script to know what are the power bi dashboard using by user

[abhijeetbehuria]

Hii Thanks in advance .I need the script to know what are the power bi dashboard using by user .

[sevenhills]

Check these and see if it gives you a head start

• https://learn.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.admin/get-powerbiactivityev...
  • https://github.com/microsoft/powerbi-powershell/blob/master/src/Modules/Admin/Commands.Admin.Test/Ge...
  • https://tomaztsql.wordpress.com/2022/08/24/longterm-storage-of-power-bi-activity-logs-and-statistics...
  • https://pbi-guy.com/2022/03/

[ibarrau]

Hi. I'm not good with PowerShell, but I can tell you how to achieve this. You can do this with any language programing tool and the Power Bi REST API. Using admin priviledges, you can check all the artifacts a user has access to. Request: https://learn.microsoft.com/en-us/rest/api/power-bi/admin/users-get-user-artifact-access-as-admin

I hope that helps,

[abhijeetbehuria]

Thanks for you reply .Actually i tried this  "Admin - Users GetUserArtifactAccessAsAdmin".But it's showing me irrelevant output.Like if i enter x in the UserId field , i should get the list of dashboards where the user have direct access .But with this one , it's showing other dashbaord .Like if the user x has direct access to only A1 dashboard but it's showing B1,c1 and A1.Can you please help me out .

[ibarrau]

The request will show absolute everything the user can access. So I'm sure it's there. It can be a long request if it's an important user. The tricky part would be filtering the content by dashboards or things like that. You can take adventage of libraries of rest api in order to make it easier, like SimplePBI when using python will solve the pagination and can return a pandas dataframe to easy filter or view the data.

Like I said before I can't help with powershell. I can just say that's the request. It requires pagination (continuationToken for more results to get them all).

I hope that make sense