POWERBI Service

[Anonymous]

Hi,

How do I extract "Direct Acess" user list to excel from PowerBI Service. ?

Thank you. 

[collinq]

HI @Anonymous ,

I am not sure I understand the question - could you clarify what you are looking at and where?  Perhaps a screen shot?

[Anonymous]

I want to extract the users list in the direct access to excel. 

[collinq]

Hey @Anonymous ,

So, if I understand the request - you want to know all of the users in each of the Workspaces.  In my mind, the best way to get that is to call the API (Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn) 

Specifically this one: Admin - Groups GetGroupUsersAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Learn