Getting Started with Intune Data Warehouse

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!

The Intune Data Warehouse are now in public preview!

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):

Lets start!

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.


You can also get additional information from the links. If you want to know more about Power BI, I would recommend looking at my colleague Alexanders – aka @arcticdbablog.

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:

  • Devices
  • Enrollment
  • 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!

As a Solution Architect, Simon inspires customers, partners and colleagues to create the best possible workplace for their users. His main focus is the Windows platform – but todays workplace consists of so much more than that. As an MCT he is passionate about teaching and sharing knowledge. He’s a frequent speaker, blogger and podcaster – as well as a penguin fanatic.

Tagged with: , , , , , , , , , , , , ,
Posted in Azure, Intune, Microsoft, News, Power BI, The Basics
One comment on “Getting Started with Intune Data Warehouse
  1. […] if you are into Intune – which I am of course! We have received new reporting capabilities (here are my post on how to get started) and today we got some additional capabilities when it comes to one of, perhaps most vital, […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

I’m speaking!
I’m going!
Follow me on Twitter!
%d bloggers like this: