Why never ending load data from AD?

[Anonymous]

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?

[amitchandak]

@Anonymous , if possible, first got to power query, check sample data is coming. Restrict data there close ans apply