Forum Discussion

SLI's avatar
SLI
Helper IV
7 years ago
Solved

ad connector

hello How to recover the user table from the azure active directory. Using the content pack it does not work because I do not have the data I want. My goal is to have the list of users with their ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    SLI,

    The AD connector in Power BI Desktop only works with Windows Active Directory. To query Azure Active Directory, you can use Azure AD Graph API. You can add a blank query in Power BI Desktop, then paste the following code into Advanced Editor of the blank query.

    let

Source = Json.Document(Web.Contents("https://graph.windows.net/domain.com/users?api-version=1.6")

in

Source


    There is a similar thread for your reference.
    https://community.powerbi.com/t5/Desktop/Get-Data-Active-Directory/m-p/73792

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

SLI,

The AD connector in Power BI Desktop only works with Windows Active Directory. To query Azure Active Directory, you can use Azure AD Graph API. You can add a blank query in Power BI Desktop, then paste the following code into Advanced Editor of the blank query.

let

Source = Json.Document(Web.Contents("https://graph.windows.net/domain.com/users?api-version=1.6")

in

Source


There is a similar thread for your reference.
https://community.powerbi.com/t5/Desktop/Get-Data-Active-Directory/m-p/73792

Regards,
Lydia