Active Directory

Summary

Item Description
Release State General Availability
Products Power BI (Datasets)
Power BI (Dataflows)
Excel
Analysis Services
Authentication Types Supported Windows
Function Reference Documentation ActiveDirectory.Domains

Note

Some capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities.

Capabilities Supported

  • Import

Prerequisites

Connect to Active Directory from Power Query Desktop

  1. Select the Active Directory option under Other in the Get Data selection, and then select Connect. More information: Where to get data

    Screenshot of the Get Data window with Active Directory selected.

  2. In the Active Directory dialog box, provide the domain for your Active Directory.

    Screenshot of Active Directory window with a domain entered.

  3. You can choose to use your current windows credentials or enter alternate credentials. Then select Connect.

    Tip

    You may need to add the domain suffix to your username. For example: domain\username.

    Screenshot of Windows credentials page with alternate credentials selected and a username and password added.

  4. In Navigator, review and/or select data from your database. Then select OK.

    Note

    The navigator doesn't load data for the configuration partition. More information: Limitations and issues

Connect to Active Directory from Power Query Online

  1. Select the Active Directory option under Other in the Choose data source selection, and then select Connect. More information: Where to get data

    Screenshot of the Choose data source window with Active Directory selected.

  2. In Connect to data source, enter your domain, select connection credentials if you've connected before or select Create new connection, and select your on-premises data gateway.

  3. Only Windows authentication is available. Add your username in the format domain\alias, and add your password. Select Next.

    Screenshot of the Connect to data source page, showing a domain added, using a new connection, a data gateway selected and a username and password provided.

  4. In Navigator, review and/or select data from your database. Then select OK.

    Note

    The navigator doesn't load data for the configuration partition. More information: Limitations and issues

Limitations and issues

Some objects in the Navigator return empty tables

The Power Query Active Directory connector supports search in the Schema and Domain partitions, but not in the Configuration partition. This limitation is the current design. So if there are any objects that reside in the Configuration partition, Power Query doesn't load data for those objects into the navigator.