When you start managing devices from Intune, obviously you would start having requirement to check the reports for various purposes, like if you are doing patching using WUfB you need to check how many devices are compliant, if you are deploying an application you may want to check its compliance count. We had many reports in MECM which made our tasks easy. But in Intune I still feel we lack few important reports. Yes we do have many reports under Device Monitoring but we may still need to create some dashboards as per our requirements.
Now, Intune may not have much inbuilt reports but it certainly gives you opportunity to build some dashboards by exploring the Data warehouse data model which you can get access to. This blog post helps you reach there where you should be able to create a report or dashboard. It seemed pretty straightforward to me. So, here we go...
The first thing you would require here is Power BI Desktop app. Now that's free either you can download it and install from App store or you can check the below link, download and install manually the latest version:
When the installation is complete and you have opened the app you will find the below screen.
There are generally 2 ways to connect to OData feed of Intune, one by clicking on Get Data from Home menu or you can just click on the Get data from another source pointed by the red arrow above. Both will open the same window like below.
so, when you see this window come to the last option Other and select oData Feed. When you click on this it will ask you for the link of the OData feed:
Select Basic or Advanced as per your need, I am gonna go with Basic for demo purposes. To get the URL for OData Feed of Intune you need to got to your Intune Console -> goto Reports -> under Intune Data Warehouse select Data Warehouse and the copy the URL from OData feed for reporting service.
Now come back to Power Bi Desktop and paste the URL on the required window and click OK.
New window opens for authentication and it will ask you to sign in to connect to this OData Feed. Now, remember here to use Organizational account and then click on Sign In and provide your creds for Intune. Make sure you have enough permissions to do this in Intune when doing in Production.
In my test environment I have not faced any issue with connection or any slowness, but when I tried to connect using my prod credentials it threw error one time and the loading of tables or data seemed a bit laggy, but it can be anything maybe my internet connection was not good enough.😂
Anyways, you will now see the tables loading with all the required data under Navigator.
looking pretty good up until now huh. 😎
if you want to check some data on these tables, just click on any one and you can see like above on the right hand side you corresponding values stored in them.
Now, if you want to create a dashboard, based on your requirement just select the tables and you will check boxes highlighted once you select them. Once done click on Load. This will begin to load your tables with values on your workspace.
When loading of data is complete you can then work with them click on Visualisations to select the type of graph or data representation according to your needs and then work with columns under Fields and create your own dashboards like below:
That's it done, now you can create your own dashboards/reports as per your requirement. I am not that much good with Power BI so digging down deep to create reports and dashboards is lil difficult for me here but you guys are expert so go on and create reports and help people like me in need.😊
That will be all folks for this time, see you guys in my next post. Until then, Cheers 😉