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!

Tagged with: , , , , , , , , , , , , ,
Posted in Azure, Intune, Microsoft, News, Power BI, The Basics

Getting started with Intune for Education

Working in Education? Or do you have customers that are? This post is for you. Intune for Education were introduced a couple of months ago and will add lots of value for teachers and students – as well as lower the amount of time used by IT to manage Intune. In this post we will go through a basic setup, based on the available sample-files for School Data Sync. Later post will cover SDS in a bit more depth, as well as additional configuration for Intune and Intune for Education.

If you havent signed up yet, please visit sign up using this link. You will also, as I will show you later in this post, need to add Office 365 and Azure AD licenses as well. If you already have a working tenant with licenses, you could start by going to the Intune for Education portal and sign in using your Azure AD credentials. You will also need access to the Office 365 portal.

Remember! Currently Intune for Education ONLY supports Windows 10 PCs. If you are using an older Windows OS, iPads or Android-tablets you still need to do the configuration in the Azure Portal.

When you log on to the Intune for Education portal for the first time, you may find it to be a bit, empty.


The account you access the portal with (this goes for all staff that need access) needs to have a Intune for Education license assigned. The easiest way to do this is in the Admin Center of the Office 365 portal. Choose your user and assign the license.


When the license has been assigned you can log back into the Intune for Education portal, which will now be a bit more populated.


Now, the easiest way to get going is by using the Express Configuration. This will also be the easist way for a teacher to configure a new groups, class or course. So, remember that you can use the Express Configuration more than once.

When you launch the Express Configuration the four steps that you need to walk through are shown. Get school information can be done in several ways (Ill use the School Data Sync in this example) and is basically to set up the necessary groups, teachers and students.

Choose a group to set up lets you choose the group to configure. The group is an Azure AD group, and usually represents a grade, class, group or team. The Express Configuration can be run as many times as needed to configure all the required groups.

Choose apps to install – not much to explain here, I will go into more detail on this later on.

And lastly Choose group settings were you configure the settings that will be applied to the user and/or the currently used device.


After you’ve pressed Get started you get to the second page of the wizard were you are asked to add school info.


The suggested approach to this is to use Microsoft School Data Sync (SDS). This enables you to sync data from your SIS (Student Information System) to Azure AD and Intune. Several SIS are supported, but today the focus is primarily on North American as far as I can see. You can however use CSV-files exported from your SIS with SDS as well, which could be a temporary solution for you until your SIS is supported.

But then again, if you for other reasons have your students and teacher in Azure AD or a local AD, you can use those groups as well. Ill go into more detail on SDS in a coming blog post. In this I’m using the publicly available sample data which you can download from GitHub. You can use them as they are for testing purposes, edit them to suit your needs or use them as templates to create your own CSV-files. Again, ill cover this a bit more in-depth later on. In this example I havent done any changes to the files.


You enable School Data Sync and the next step is to create a new profile.

SDSProfileIntuneEDUThe profile will enable you to sync different schools with different settings if you like to. For this example we are doing a manual import, but if you have a supported SIS or if you set up the SIS toolkit you can automate this. Another piece of the upcoming post. 🙂


When you have chosen how to connect you need to configure your sync options. You an already existing Azure AD tenant you can update your existing users with more information. If you are configuring a new tenant you add the users from scratch.


Now its time to upload your files. The sample files consist of six files with information on schools, sections, students, teachers and to what course a student has enrolled to as well as what students (and course) each teacher are responsible for. You also have additional files if you would like a UK sample school instead of an US one.


When the files are uploaded you can configure what attributes to keep – this is the default selection. You can configure if a teacher should have the right to over-write a section (group) name as well as configure a later date for when to add the students to each section. Lastly you allow the teachers and students to be managed by Intune – and there by configure to add a Intune license to each user.


The two following steps lets you configure additional options for students and teachers. The most essential parts of this are  probably what domain the teachers and students should use as well as what license. This could again be a reason to use different profiles.

You are then asked to review the settings you’ve made, create the profile and then start the sync.





The initial sync will take a couple of minutes, but you are able to follow the process by refreshing the page. When the sync is done you will get success message telling you all went well. In my case I didn’t have enough licenses to assign, so I ended up with a bunch of errors. However, all users, groups etc has been created and you can fix this later on by running an additional sync or adding the licenses in the Office portal.


Time to head back to the Intune for Education portal and continue the configuration.


The second step let you choose the group to configure. Again, you can run the configuration as many times as you like to configure your groups. Also remember that a student may be a member of more than one group, so apps, settings and so on could be combined in the end. If you have used Intune previously you will feel right at home.


This may be the right time to point out something essential: As you may already have realized, Intune for Education isn’t really introducing anything but a more user-friendly GUI. Everything you do in the Intune for Education portal will be visible in the regular Azure portal as well.

This means that you could run into some challenges when you have IT-staff configuring policies etc in the Azure portal and teacher in the Intune for Education portal. The challenges may not be technical, but rather process and/or policy related.

However, lets move on to the next step, time to choose apps!

You are able to deploy web-apps, Store-apps and desktop-apps. Some of them are pre-populated, some are additional apps that are popular in Education and later on the apps you add yourself (covered in an upcoming blog post) will be visible.




Choose the apps you would like to deploy to the group you are configuring (you can of course edit the selection later) and go on to settings.

The settings that are configured in this step are probably the settings a teacher would like/need to configure. Again, you have additional settings (for wi-fi, e-mail and so on) in the Intune for Education portal as well as in the regular Intune portal.


When you are done you are asked to review the settings for the group you have selected and after that you are done with your first group! Now you can either start enrolling devices or re-start the wizard again to configure an additional group.



I hope you have enjoyed this post and others will follow. If you have any questions, please drop me a comment!

Tagged with: , , , , , , , , , , , , ,
Posted in Education, Intune, Microsoft, The Basics, Windows 10

Episode 18 – The team song

A very late update with the latest episode of our podcast! This episode was recorded on June 30th, but are still up to date. 🙂

To qoute my fellow podcaster Alexander:

“We talk about YET another configmgr preview, do a recap of the first six months of this podcast, the upcoming conferences in the fall and our hopes for future releases.

As always we gladly accept tips and criticism, as well as ideas for content for us to cover. Just tweet me (@arcticdba) or Simon (@bindertech)!”

Until next time!

Tagged with: , , , , ,
Posted in ConfigMgr, Microsoft, News, Okategoriserade, Podcast, SCCM, System Center, Technical Preview

Episode 17 – iPhone Body

So, first week of my parental leave and for some reason I’m at the office recording another episode of our podcast. This time with our brand-spanking-new theme song!

We start of with probably one of the most important news of the year: Windows Server has been added as the latest bi-annual release software. So, joining Windows, ConfigMgr and Office we will see two new releases of Windows Server each year. We discuss how it works, what it will mean for you (and us) and the other hidden messages inside of that blog post: Delivering continuous innovation with Windows Server

As always we have new exiting news to share on Power BI – and Alexander also shares the latest insights on how to use, mind of, SSIS in Azure.

We end the episode by discussion Apples WWDC and the reparability of hardware in general, an that of the Microsoft Surface Laptop in particular.

As always, any feedback you have – let us know! You can find us on Twitter were we go by the names: @Bindertech and @Arcticdba.


Tagged with: , , , , , , , , , , , , , , ,
Posted in Azure, Hyper-V, Microsoft, News, Okategoriserade, Podcast, Windows as a Service, Windows Server

Episode 16 – Sustainability of clouds

The week of major subjects, everything from Sustainability and eco-friendly clouds to what is really the modern way to work?

From the technical point of view we get the latest on Power BI and the never-ending story of licensing it. Also, we now start to see the new way of device management with the latest Technical Preview of ConfigMgr and the integration of Azure AD.

Me and Alex ( @Bindertech & @Arcticdba ) always appreciate your feedback and would love for you to get in touch with us if you would like to participate.


Tagged with: , , , , , , , , ,
Posted in Azure, Microsoft, News, Okategoriserade, Podcast, SCCM, Technical Preview

Episode 15 – The super-great episode

New week and new episode of Knee Deep in Tech. Alexander and I have searched high and low for subjects and today is the day you should start listening to our podcast if you are interested in:

  • The question everyone(?) is asking: Should you test updates before you deploy them?
  • The new Surface line-up.
  • SSIS on Azure, is it possible and how should you do it?
  • Power BI and the extended trial that will be on offer starting June 1st.
  • And of course the usually ranting and insults of your favorite podcast hosts!

As always let me ( @Bindertech ) or @Arcitcdba know if you have any feedback or input on our podcast.

Tagged with: , , , , , , , , , , ,
Posted in Application Management, Azure, Microsoft, News, Okategoriserade, Podcast

Episode 14 – Knee Deep in Trains

We are again speaking about trains – but this episode contains a lot more than that! We start of by letting Alexander share his experience from speaking at Swedish .Net User Group. What’s important for a developer to know about databased and vice versa for a DBA to know about developing.

I later on shares my fresh views on VMwares offering about Cloud and End-user computing as well as some insights whats to expect.

We end the show by talking about speaking at technical conferences and share some of our experience on that.

Just ping either me ( @Bindertech ) or Alexander with any feedback or suggestions! And again, thanks for listening to our podcast!

Tagged with: , , , , , , , , , , , , ,
Posted in Azure, Microsoft, News, Podcast, Public Speaking