Power Query Active Directory Feature
I tried to use Active directory feature of Power Query but still not able to find any solution in any forum to speed up the downloading data.
I have more than ~300,000 records to import (i.e. Distribution list contains each member list) from Active directory but it takes 12-~14 hrs to import using Power Query.
Can we look into this feature why there is so much time taken by Power Query and How we optimize the same ?