Forum Discussion
mpkorich
3 years agoFrequent Visitor
Active Directory Expanding Record Performance Issues - Take 2 from 2018
This was asked previously answered with a not-so-useful response so I'll re-post in hope of something other than "don't expand records from AD" 😉.
I connected to an AD user base with Power BI (no record expansions...yet) and the query loads in seconds on my desktop. Now, the mystery: with the expansion of 1 record (Person.sn), it times out loading 43k records (never ending refresh... over a weekend it ran).
Questions...
- what is happining with AD in the expansion process?
- Are 43k requests being made in the background for every expansion?
- Is there a way to narrow the initial AD request to the records I want without downloading the world?
- Will "Table.Buffer" help here? (doesn't seem to)
Thanks!
PS. Saw this post from 2018 but the response fell short of a solution really.
1 Reply
- IoannisTAdvocate IFacing the exact same issue so very keen to see if there is going to be an answer. *following