The news we received today from the Enterprise Mobility team at Microsoft are truly great and something I and many with me have been waiting for!
One of the challenges with Intune has, in my opinion, been the limited amount of reporting data you can get out from the service. This has made a few of my customers go with a hybrid configuration rather than a Cloud-only one – just to get that data. The data and information you (now) can get from Intune is a real asset, especially when you implement the service.
So, my plan is to provide you with a brief step-by-step guide to how to access your data using Intune Data Warehouse and Power BI Desktop!
Start by downloading and installing the latest version of Power BI Desktop:
And also the Power BI reports-file (it can also be found in the Intune portal):
Start by logging into the Azure Portal and browse to the Intune service. You should see the icon for Intune Data Warehouse to the right.
A new blade will open and give you the option to use a third-party reporting service or Microsoft Power BI. From here you’ll find the links to Power BI as well as the Power BI file you downloaded previously. If you would like to use a third party solution, you’ll find the link required to access the data here as well.
Now it is time to start (first install it if you havent already) Power BI Desktop. The setup is super easy, so I wont cover it. Once its installed, start it and you will we greeted by this screen:
You don’t need to sign up for anything at this point, and you can wait to sign in. Instead, click the “Open other reports” and open the Power BI file (Intune Data Warehouse Report.pbix).
The file will open and show you some empty charts. This is only the reports as of yet – but we will soon fill them with data.
Currently we have seven different pages:
- App Protection Policy
- Compliance Policy
- Device configuration profile
- Software update
- Device inventory
They are quiet self-explanatory, and you can look around yourself to see whats in it. I find most of it to be really useful, but the power will be to build things yourself to suit your needs.
Bring me the data!
Now, at the top of the main window you have a yellow ribbon with an “Apply changes” button. If you click that, it will run the necessary queries to gather the required data.
After a few seconds a small windows will open, and soon you’ll be prompted to authenticate. Choose “Sign In” and authenticate using your Intune (Azure AD) credentials. When you have completed the sign in, click “Connect”.
Now the first small windows that opened will appear again and this time it will start gather data. You can follow the progress as it goes.
This could take a while depending on how much data you have. In my case, with my tiny environment it took about 30 seconds. When its done, you can start browsing the report again and see what it found for you! I felt that, for my small tenant, I got some good data and I cant wait to try it out at some of our customers.
And now when you got the data, it’s up to you what to do with it. There are a bunch of good resources if you are new to Power BI, and hopefully me and Alexander could create something on the topic later on.
I hope that this has been valuable to you, and enjoy your data!