Power Query Active Directory Pull Never Finishes Loading

Question

I have a simple Excel 365 - Power Query pulling some basic user information and it looks like it will return less than 2,000 rows. I get the columns all setup in the Power Query Editor. Then close the editor to load. I watch the “Queries and Connections” window count up the rows it has loaded reaches what I assume is the max then it jumps back to 0 and starts counting the records up again. It does this over and over … after 15-25 minutes I usually stop it.

While investigating the issue I did notice the Power Query editor seems to freeze if I try an scroll down past row 200 of the AD listing. I did try and make multiple queries. One that pulled the first 100 rows a 2nd pull the next 200 and so on… however that did not seem to do any better and looped on all the queries.

Any ideas or thoughts?

Thanks

Alan

Answer 1

To analyze the issue please enable tracing for Power BI Desktop, reproduce the issue, and send us traces.
How to enable traces:
Options -> Diagnostics -> Clear Traces folder -> Enable Tracing

Logs collected with Fiddler app also could be helpful.