Why AD never finished loading?

[ovonel]

I am trying to consume the group table in Active Directory, but it takes long time:

(it loads for hours, never finishing...)

Is there a way around this? I am showing in PowerBI,  folder + AD groups  (I want to enable a drill down on 'groups', to see members of the group).

Is there a way where, I can load only data that I need?

[v-luwang-msft]

Hi @ovonel ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @ovonel ,

You could test to get   list of AD Groups and their members  by using PowerQuery,refer:

https://matt40k.uk/2016/06/getting-a-list-of-ad-groups-and-their-members-using-powerquery/  

If not work ,nd you could update your Power BI Desktop to the lastest version  and test agin.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Lucien