question

ArsenioQuijanoLarrosa-4956 avatar image
0 Votes"
ArsenioQuijanoLarrosa-4956 asked DSPatrick answered

Power BI - Active Directory Query Performance

We want query from Power BI to the active directory, asking for users and groups of those users, but the query is very expensive. Poor performance. There is some way to optimize it or get this data in another way.
The query we currently use is:

let
Origen = ActiveDirectory.Domains("domain.local"),
domain.local = Origen{[Domain="domain.local"]}[#"Object Categories"],
user1 = domain.local{[Category="user"]}[Objects],
#"Se expandió top" = Table.ExpandRecordColumn(user1, "top", {"memberOf"}, {"top.memberOf"}),
#"Se expandió top.memberOf" = Table.ExpandListColumn(#"Se expandió top", "top.memberOf"),
#"Se expandió top.memberOf1" = Table.ExpandRecordColumn(#"Se expandió top.memberOf", "top.memberOf", {"cn"}, {"top.memberOf.cn"})
in
#"Se expandió top.memberOf1"

where "domain.local" is our domain.

Thank you

not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

Power Bi is not currently supported here on QnA. The product group for Power Bi actively monitors questions over at
https://community.powerbi.com/

--please don't forget to Accept as answer if the reply is helpful--




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.