One of the most interesting things about Power BI is that it covers a wide range of areas. Therefore, it can help a wide range of different users to analyse and understand their businesses easily. For instance system administrators can use Power BI to analyse their Microsoft Windows Active Directory. As a matter of fact, Power BI and Active Directory can work together very nicely so that a system administrator can create high level reports and dashboards.
In this , we’ll create a report of the following charts:
- Total number of computers by Operating System/Service Pack
- Total number of computers by year and Operating System
- Total number of computers
- Print pages per minute by printer
- Total number of printers by year and driver name
As a system administrator you can create heaps of other useful reports.
Get Data
- On Power BI Desktop click “Get Data” then click “More”
- Click “Other”, click “Active Directory” then click “Connect”
- Enter a Domain name then click OK
- As you can see there are 374 tables you can select to create heaps of reports. In this post I use “Computer” and “PrintQueue”
Continue reading “Power BI and Active Directory for System Administrators”
It’s been awhile that lots of us were waiting for this feature. And some of us like me just tried to build it in our way. I spent some time to develop something similar using OData in combination with IIS and Basic Authentication features. Well, it was sort of successful and unsuccessful simultaneously! I mean, I was able to refresh SQL Server data remotely, but, when it came down to refreshing the dataset uploaded into the cloud Power BI it just failed. It was mainly because of the method that Power BI uses to refresh data.
