Blog Post

Building Power BI Dashboards with Intune Data Warehouse

D Walsham • Jan 20, 2021

Get Data from your Intune Device Managment

Introduction

When it comes to the available reports which you see in your Intune Device Management console, you may not get a wide coverage of everything you would want to see, especially when it comes to more information such as the following;

  • Device Inventory
  • Full Application Deployment History
  • Further Device Compliance Information

These needs can be leveraged when utilising the Intune Data Warehouse. It contains all of the historical data within your Intune estate and is refreshed on a daily basis due to the retention periods which it holds.

This can be utilised as a data connection method within your Power BI reports and dashboard which we will show more details of below.

Setting up the Data Connection to Intune Data Warehouse

  • Firstly open up a new report/dashboard in either your Power BI service or desktop application.
  • Go to the Get Data option in the toolbar.
  • In the Search Bar type in "Intune" to find the following listing below

Once you select this option you will get a disclaimer of connecting to this service.
( Note: it is currently noted of it being in beta at this current moment until its final version is released. But will show more detail on the information of which you can obtain from it)

After clicking on the continue disclaimer you will then be given an option to select how many days of historical data that you wish to go back to. Now if you are looking to maintain the latest data the better option maybe to go for 1 day.

But if you are looking to take advantage of a full data warehouse capability then you may proceed to go back further to customize your dashboard even further.

Once you click OK then you will be presented with the Navigator screen which will show all of the available tables within your Intune Data Warehouse. Very similar to if you created a data connection to your SQL Server and Database but without specifying a particular query.

Here you select the appropriate tables which you require.

When ready you can then load the data or proceed to Transform Data so that you can edit any of the information which you have processed from the selection of tables.

Once done you will then have your datasets ready to start formulating reports.

Where relationships are concerned they are pretty dynamic where keys for important data such as Apps, Devices, Device types etc are included in almost every table. So as soon as you apply the changes 99% of the time the correct relationships are formulated which you can see below.

by D Walsham 13 Dec, 2021
Looking through the current SQL Server topology and how it affects our decision
by D Walsham 07 Oct, 2021
Introduction
by D Walsham 06 Oct, 2021
Introduction
by D Walsham 12 Aug, 2021
All the parts of the series we went into great detail about how we analyse an end to end solution and how we would design a solution in which would allow us to build endpoints without SCCM being a dependency. Whilst we did this, there is another scenario which we have not touched on yet, which is the hybrid scenarios. In a perfect world ideally you would have your Azure Active Directory within the cloud, every machine meets the recommended requirements for Windows 10, everything is imported into Intune/Autopilot and everyone is happy. But we know this isn't realistic in all cases. Many organisations cannot just simply up and go from on-premise into the cloud therefore the checkpoint here is of course getting into hybrid solutions such as; Co-Management Between Intune and SCCM Hybrid AD with Azure AD and On-Premise AD syncing together These things can play a very interesting part in how you would tackle this if you envisage the next step in the blueprint is to be in a position in which you can build and manage endpoints soley within Intune. With this final part of the series we will go in-depth in how the common hybrid setups look like and how we go about moving into the next step of being able to manage and build devices without SCCM.
by D Walsham 29 Jul, 2021
In continuation from the previous part where we had discussed how we create the "on site" piece of the solution, this was the part which would allow us to get our endpoints into a state in which they would essentially be ready to go through the Autopilot process. Which leaves our next piece of the puzzle, to begin the configuration of the actual backend side that resides within our Endpoint Management console. And you will see how everything ties up together to satisfy the full end to end process of getting an unknown (or known) device to proceed thorough the whole workflow to be finally managed by Intune without the aid of SCCM taking part in any of the prerequisites or preparation at hand.
by D Walsham 15 Jul, 2021
In this part we are now going to look into the technical step by step points on how we put everything together. In the previous part we spoke about the structure of how we would asses whether a machine was actually ready to be built with Autopilot or not with a build checklist process which would step through all areas which would cover an endpoints eligibility. Now with everything planned out we finally want to step into making things reality by putting everything together.
by D Walsham 02 Jul, 2021
When it comes to managing your endpoints in endpoint manager, one of the things you may be looking to do is to get all of your Intune registered machines to also be enrolled as Autopilot devices. Now we can of course just have the deployment profile deployed to all machines and then hit the "Convert targeted machines to autopilot" but this might not necessarily be feasible for every client. We may want to perform some due diligence first so we can at least understand what devices in Intune are not in Autopilot.
Show More
Share by: