Forum Discussion
Lync/Skype lcscdr database
Hi there, you could try checking whether or not the Active Directory connector in Power BI Desktop will do what you want?
If you click on the "Get Data" button:
Then search for 'Active', you'll see the Active Directory data source. When you click it, it'll then ask you for a domain.
Though I've not used it myself and not currently in a position to test it (I don't have access to a domain right now), I suspect that it'll at minimum let you bulk export some users so that you can shape the dataset in Power BI (e.g create relationsips, apply filters etc.)
Hope that helps.
Hi Jason and thanks for reply! :)
I did an Active Directory query as you described, but it shows a long list of tables and most of them are empty. If i choose user (first table) not many user attributes are shown. IE missing country,manager and other basic attributes. Account im using is domain admin so it should have access to "every" attributes.
I could do export using powershell and get all attribute i want, but it is static and i have to manually export them when new user is introduced or leaves the company.
Other ideas are much appriciated!
The default view of users will most likely give you a number of 'Record' columns which you'll then have to expand to get at the information that is going to be useful for you.
Just tried it myself, right now. That's one complicated schema :-)