Power Query for specific OU

[J013]

I am creating a report to show user metrics for a specific subset of users in AD. I am using the Active Directory connector in Power BI Desktop and while it works and pulls back the data I need, it is SLOW..... I am only looking to pull back information on currently about 100 user objects, but it seems to need to query over 30k across the entire domain before I can filter down to the specific OU I am looking for.

Does anyone know if it is possible using Power Query to specify the OU up front, like a base search string? Right now it takes like 5-10 minutes to pull data back when I think it should only take seconds.

Thanks.

[v-yuezhe-msft]

@J013,

I haven't found any methods that can be used to prefilter the OU before you load data into Power BI Desktop. It is only possible to filter specific OU after loading all the data in Power BI.

There is an idea about this issue, please vote it up.

Regards,
Lydia