cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
J013 Frequent Visitor
Frequent Visitor

Power Query for specific OU

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.

1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: Power Query for specific OU

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.