Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Im pretty new with PowerBI and its component in Excel and also new using SQL query.
Im managing Skype for business server 2015 in our environment and would like to build up some reports. As far as i can see, there are no Country table so I have to sort users out manually.
In PowerBI or Excel i connect to sql server, define database and define the following sql query:
Select *
FROM[LcsCDR].[dbo].[VoipDetailsview]
Where ToUri like '%MainSwitch%' or ToUri like '%Accounting%'
This i wil get all Uri, which in this case is response groups. It works fine, but now i would like to do user query from Active Directory OU instead.
So if CEO wants all statistic for all users in France office (has own OU), is it possible?
What if CEO wants statistic for everyone in French accounting team (does not have own OU, but has it in Department attribute), is this possible as well?
Thanks!
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |