See Intune Data Warehouse in action

We've heard a little about this feature recently but the Intune Data Warehouse is finally in public preview. It will give us powerful custom reporting with a dataset spanning up to 90 days of historical data. You can use Power BI or Excel to connect to the warehouse, or indeed any other tool that supports OData feeds.

There is a good blog post describing the feature but I wanted to see it in action with my own data. It is very easy to configure and get started.

Open the Intune admin console on your Azure Portal

Click on the Intune Data Warehouse tile on the bottom right of the screen. This opens the Intune Data Warehouse blade.

The blade gives us the instructions we need.

• Download and install the Power BI desktop app
• Download the Power BI template file
• Open the Power BI template with the Power BI desktop app
• Authenticate with your tenant

This is the Power BI app......

....and the Power BI template file. It contains a set of custom reports to get you started.

Install the app.

When the app installs select File -> Open.

Browse to the template file.

Select to Apply changes.

You will see the changes being applied.

The OData feed dialog box open. Select the Organizational account section. Sign in with an a global admin account on your tenant. Click Connect.....

.....and we can see the reports have been populated with our own data.