# MEM Managed Device Report template

## Overview

I have created a sample PowerBI template for MEM managed devices that you can download and use. To use it, you **must** have first exported data from MS Graph into an Azure storage account using the provided automation account runbook in the previous sections. The template is configured to use exactly the properties that this runbook exports as well as the 3 exported files for each OS.

## Screenshots

![](/files/-M_SWsa1VD3HzvfiagKV)

![](/files/-M_SX7LaCc_62xqrGZT7)

![](/files/-M_SXLH8kBktSSihDYH0)

![](/files/-M_SX_skBsxHYA_Ui0IL)

![](/files/-M_SXpLszyFUMzroPROP)

![](/files/-M_SY1x0FFf-Rx4AVNhP)

## Download

Download the PowerBI template [here](https://github.com/SMSAgentSoftware/ConfigMgr/raw/master/PowerBI%20Templates/Intune%20Managed%20Devices%20Report.pbit).

## Configure the datasource

* Open the PowerBI template
* Upon opening, you will be prompted for the **storage account name** and the **container URL**

![](/files/-M_SUxPZ0kGcUjB7q35-)

* You can retrieve the **container URL** from the storage account as follows:
  * In the Azure portal, in the storage account, navigate to the container where the 3 exported CSV reports are
  * Under **Settings**, click **Properties**
  * Copy the **URL** and paste it as the **Container URL** in the report
  * **Important!** Add a **forward-slash** to the **end** of the URL, eg <https://.../intune-powerbi/>
* Click **Load**
* You will be prompted for the **Account key**. Retrieve this from the storage account under **Access Keys**.

![](/files/-M_SWAQtLAU1fn3CIPe9)

The data should then be imported into the report.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.smsagent.blog/microsoft-endpoint-manager-reporting/managed-devices-report/mem-managed-device-report-template.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.