michaelsendpoint.com

Appearance

👋 Introduction ​

Use the data warehouse to build reports that give you insights into your environment how you need it. It is the data interface between your Intune data and a reporting tool.

You can use it by connecting your reporting tool to the OData feed of the Intune data warehouse.

INFO

This data does not include records of Co-Managed devices. These are kept in the Configuration Manager which has a separate interface.

🔧 Report configuration ​

OData feed ​

First open your Microsoft Intune admin center -> Reports and select Data Warehouse. Next copy the OData feed for reporting service URL and use it to connect your reporting tool to the Intune data warehouse.

PowerBi ​

Download and install Power BI Desktop here or go to https://app.powerbi.com to start with Power BI Web.

  1. To get started, first open a Blank Report.
  1. In the new report, first click Get Data and then more.
  1. In the following popup window search intune, select Intune Data Warehouse and click Connect.
  1. Next you will get a warning Windows that this is a Preview Connector, which you need to confirm.

INFO

If you do not feel comfortable using a preview connector, you can also connect to the Intune Data Warehouse using the OData feed connector instead of the Intune Data Warehouse connector.

  1. In the next step you paste in the OData feed URL you copied before from Intune, select the number of days you want to pull data for and click OK.
  1. Now you need to sign-in, to authenticate to the Intune Data Warehouse connector and click Connect.
  1. In the last window you select the data tabled you want to use in your report. Here you can just select everything and click Load.
  1. Now PowerBi will load the data, which can take a moment depending on the amount of data.

  1. After loading the data, you can start building the report you need. In my example I created a simple pie chart showing the OS distribution on my devices.

    1. To do this, I first selected the Pie Chart visual from the Visualizations pane.
    2. Then I dragged the operatingSystem field from the devices table to the Values field and the same field to the Legend field.
    3. Next I changed the aggregation of the operatingSystem field in the Values field to Count.
    4. Finally I dragged the isDeleted field to the Filters pane and only selected True, to make sure only the active devices show up.
  1. If you want to publish this report now to PowerBi and give other people access to it, you click on the Publish button on the Home ribbon.
  2. A window will pop up where you need to select the workspace you want to publish the report to and click Select.
  1. Then the report will publish and give you a confirmation afterwards.

INFO

The data will refresh once every day.

💡 Conclusion ​

By leveraging the Intune Data Warehouse feed, you can build your own reports and dashboards leveraging PowerBi or any other reporting tool that supports OData feeds. Use this to get the unique insights and data you need to manage your environment better or present the data in more visual ways.

References